Newbie question about SQLite3

Discuss GUI programming with the RapaGUI plugin here
Post Reply
User avatar
NubeCheCorre
Posts: 77
Joined: Mon Mar 19, 2012 1:24 am
Contact:

Newbie question about SQLite3

Post 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

User avatar
NubeCheCorre
Posts: 77
Joined: Mon Mar 19, 2012 1:24 am
Contact:

Re: Newbie question about SQLite3

Post 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 :-)

User avatar
lazi
Posts: 553
Joined: Thu Feb 24, 2011 11:08 pm

Re: Newbie question about SQLite3

Post 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

User avatar
NubeCheCorre
Posts: 77
Joined: Mon Mar 19, 2012 1:24 am
Contact:

Re: Newbie question about SQLite3

Post 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 :-)

User avatar
NubeCheCorre
Posts: 77
Joined: Mon Mar 19, 2012 1:24 am
Contact:

Re: Newbie question about SQLite3

Post 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

Post Reply