SQLite configuration

[BxGeek]

Where do you define the location of your SQLite files in the
config.php file? I see where you can define the default DB but not a
directory path to a repository/db store.

Thanks

[Calvin Lough]

SQL Buddy only lets you work with a single SQLite file at a time. So
there is no preference for a directory, but you can put the a path to
a single file here:

$sbconfig['DefaultDatabase'] = "/path/foo.sqlite";

[BxGeek]

Can you specify a directory out side of your www\sqlbuddy\ directory?

Like:
C:\Program Files\WAMP\sqlite_directory
***
I've done that and I get an error message as follows...

<<< ERROR
( ! ) Fatal error: Call to undefined function sqlite_libversion() in C:
\Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43
Call Stack
# Time Memory Function Location
1 0.0033 437296 {main}( ) ..\login.php:0
2 0.0414 796840 SQL->SQL( ) ..\login.php:51
ERROR>>>

I get the error message even when I have the sqlite3 database in the
www\sqlbuddy\ directory?

Like:
C:\Program Files\WAMP\sqlite_directory
***
I've done that and I get an error message as follows...

<<< ERROR
( ! ) Fatal error: Call to undefined function sqlite_libversion() in C:
\Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43
Call Stack
# Time Memory Function Location
1 0.0033 437296 {main}( ) ..\login.php:0
2 0.0414 796840 SQL->SQL( ) ..\login.php:51
ERROR>>>
---

[Calvin Lough]

The SQLite functionality is honestly not very well tested. I've
actually considered removing SQLite support. There must be better
software out there for working with SQLite, I just haven't done any
research so I can't help you out.

[BxGeek]

OK thanks...

I would like to see you cuntinue to work on to work with SQLite. There
are other solutions out there (phpSQLiteAdmin) but none with the
functionality of SQLbuddy (at least from what I see on the MySQL
side).

I like the interface.


Thanks Again!

[Ricker Polsdorfer]

Please remove my address from this thread. I know nothing about SQLite and
am not interested in it.

Ricker Polsdorfer MD
Chief Medical Officer

Society-Endorsed
Quick-Reference Tools
5740 Executive Drive Suite 218
Baltimore MD 21228
R...@GuidelineCentral.com
Phone: 434 973-4529
Fax: 206-984-2019