[Gambas-user] Database Access

[Rob Kudla]

On Mon February 20 2006 04:14, Llew Ashdown wrote:
> IE in delphi (or dbisam) a *database* is just any directory.
> a table is any dbisam table within that directory.(so
> simple)no user no password.
> I simply create that table or those tables within that
> directory and point the components to it -- done.

OK, you've been using file-based databases, whereas MySQL and 
Postgres are client/server-based databases (meaning the database 
can be on another computer if you want.)  

Client/server databases are pretty much required for any major 
database application, even in Delphi, because of the flexibility 
and security they allow.  Anytime you want to have people on two 
or more computers updating the same database, it has to be 
client/server.  

But if you've been using file-based databases already, and they 
work fine for your purposes, try selecting Sqlite as the 
database type because that's what Sqlite is.  I think the "host" 
is then the path to the directory full of database files, and 
"username" and "password" can be left blank.

You'll need to create those files, either using the sqlite3 
program or in the Gambas Database Manager, prior to running your 
program (it's possible to write your program to create the 
databases at runtime, but since you're still new to Gambas I'd 
say worry about that later.)

Rob