Page 1 of 1

Newbie question about SQLite3

Posted: Fri Aug 14, 2020 2:50 pm
by 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

Re: Newbie question about SQLite3

Posted: Fri Aug 14, 2020 6:02 pm
by 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 :-)

Re: Newbie question about SQLite3

Posted: Fri Aug 14, 2020 8:24 pm
by 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

Re: Newbie question about SQLite3

Posted: Fri Aug 14, 2020 9:21 pm
by 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 :-)

Re: Newbie question about SQLite3

Posted: Fri Aug 14, 2020 9:49 pm
by 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