[New Extension] SQLite 3 - Public beta 1

[byo]

I see. I thought that the "Multimedia Fusion 2" version information would be good for both versions. I'll rebuild the installer as soon as I can. Thanks for reporting this.

Andre Guerreiro

[Jeff]

Thanks Byo

[byo]

Thanks for the support.

I'm going to add a new installer in the File Archive forum before making it official so those who have the MMF2Dev version could test it.

[EDIT]
Click here to download the new installer.
Thanks.

Andre Guerreiro

[Jeff]

Works like a charm!

Good to go

[byo]

Thanks. Good to know that.

Could someone please test if the extension works in MMF2DEV properly? I think I may need to configure something especifically for the the Developer version. If everything works, then it's ok. And it's set to work only from build 247 and above (default in the rSDK).

Any sugestions to improve the extension are welcome too.

[MechatheSlag]

Theres something I don't get.
How the hell do you connect to a database

I mean, it wants me to include the full path, but sofar I know, the path should be "localhost" and the username and password should be an input required to connect to anything at all.

This extension is merely confusing.

[Corentin]

SQLite doesn't connect to a remote db like MySQL or others. That's exactly the point of this library actually, and that's why it's the most used database.

In SQlite a database is a single file

[eceva]

Thanks byo! It works now

[dingdong]

So how do you create a new database? Or does it automatically do it if you start adding data?

[byo]

dingdong: Use the action Open database file and enter the file full path. If the database doesn't exist, it'll be created and then you can start adding tables, views, triggers, etc.

If it exists already, you'll just open the file (although you can change this behaviour - see below).

Right now, there are three options to open a database file, and this goes as a second parameter to the Open database file action:

0 - ReadOnly
You'll be able to only retrieve the data from the file but never write any information to it. If the file doesn't exists, it won't be created. If you try to write data, the last error message (retrievable with an expression) will state that the database is in read only mode.

1 - ReadWrite(Open)
That means you can open a given database file for read/write operations.

2 - ReadWrite(Create)
This will overwrite the database file even if it exists already so use this option wisely.