Newbie question about SQLite3

[NubeCheCorre]

Sorry for the very dummy post but is there a very simple tutorial that show how to create a simple database under hollywood and sqlite3? I have experience with mysql and PDO but none at SQLite3...
Thanks

[NubeCheCorre]

OK I found documentation with examples inside Hollywood and also using Google and I am understading almost everything so the admin can close this topic, thanks

[lazi]

Not so fast on closing the topic, maybe others will have similiar questions in the future

The two most helpful information source for Hollywood SQlite:

1. Lua SQLite implementation wiki which is almost identical to our need
http://lua.sqlite.org/index.cgi/doc/tip ... lite3.wiki

2. The main SQlite syntax docs:
https://www.sqlite.org/lang.html

These two are covers everything for beginners.

If you have any Amiga like system, there is an SQlite database manager tool written in Hollywood which would be handy:
http://aminet.net/package/biz/dbase/SQLMan

[NubeCheCorre]

Thanks!
I become familiar with rapagui and i am finding very handy and easy in creating gui. I hope to use it also for android system

[NubeCheCorre]

Maybe you were right, I still have a question, and before I populate the database I would like to know a thing, If I set the main app with utf-8 charset how do I set the database with that charset? I am able to do that when I use mysql and php but I don't know how to do it with Sqlite3