How to use sqlite in gambas? I'm using gambas in raspberry pi and DB browser for Sqlite.

Thats a big question, and I don't know how much you know about Gambas & Sqlite, but you will need to include the gb.db component and if you want to use Data Bound controls gb.db.form.

This is the simplest code I can think of to get you started;

Create a new project and add a textArea to the Form. Enter this text:-



When you run this code using a valid database, the textArea should list your database tables.

 Thank you very much! I'l try the code.

I tried this out today too, since I'm finally looking at db access in Gambas. Trying the code as is (with my own project and database paths) I got the equivalent of the following error (I say equivalent because I have edited it to show what it would look like with the path information from the example given):

"Unable to locate database `/home/steve/Gambas/my-tv/me-tv.db` in ``"

    When I altered mine to move the path portion of the name into the Host property (in a manner similar to what is shown below), then it opened just fine.

stevedee said

Thats a big question, and I don't know how much you know about Gambas & Sqlite, but you will need to include the gb.db component and if you want to use Data Bound controls gb.db.form.

This is the simplest code I can think of to get you started;
[…]

This is a bit odd. When I wrote my original sqlite3 database code in 2009, it certainly worked with .Host="" and .Name={full path + file name}

The Gambas Documentation now show .Host =path and .Name is just the file name.

However, the documentation still suggests that .Host is a computer name or IP address (which is normally what "host" implies):-

"Returns or sets the host where the database server resides.
This host can be a machine name, or an IP address. The default host is localhost."

Agreed, that is how I've always though of host.
Perhaps, since this is a server-less (or in their words 'engine-less file-based') database, they felt they needed to re-purpose the Host property.

Anyway, here is the help for SQLite, where they are even suggesting 'Application.path' for the value:
http://gambaswiki.org/wiki/howto/databasesqlite?nl

stevedee said

This is a bit odd. When I wrote my original sqlite3 database code in 2009, it certainly worked with .Host="" and .Name={full path + file name}

The Gambas Documentation now show .Host =path and .Name is just the file name.

However, the documentation still suggests that .Host is a computer name or IP address (which is normally what "host" implies):-

"Returns or sets the host where the database server resides.
This host can be a machine name, or an IP address. The default host is localhost."

I haven't created a mySQL db in about 10 years since SQLite is all I've needed for my apps. If you think of ".Host" as a "location" and not just as a path, machine name, or IP address, and use a variable to hold that "location", you should be able to craft your db access code to be swap-able between mySQL and SQLite with minimum effort. There used to be a blurb on this in the wiki, but it looks like db access has been rewritten in the wiki for both SQLite and mySQL.

A few things…

When setting the ".host" path, no need to use a trailing slash ("/").
When putting the db file in a user's home directory, set the ".host" path by using "User.Home" (instead of hard coding the path).

When putting the db file in a directory outside of the user's home directory (such as an NFS shared directory), omit "User.Home" and add an absolute path with a beginning slash ("/").



This is how I set up my sqlite databases. (This is from my event reminder app.) If I need to have the db in a NFS location, I can easily change the sBaseDir string variable and drop the "User.Home &/" from the xxxPath string variables. When creating a new db app, I just copy these 2 files into the new app and make a few changes.

MGlobal.module file…

MDatabase.module file…

Good path tips, Thanks!

Got2BeFree said

This is how I set up my sqlite databases. (This is from my event reminder app.) If I need to have the db in a NFS location, I can easily change the sBaseDir string variable and drop the "User.Home &/" from the xxxPath string variables. When creating a new db app, I just copy these 2 files into the new app and make a few changes.