The Lightbulb went off with SQLlite

Solar2D General Questions/Discussion
#1

I’ve always had a major issue with SQLlite and Corona Apps and that’s a lack of feedback on the queries and the inability to look into the database…

Well I thought there had to be a command line tool like MySQL that lets me run queries against the database, so off to Google to find out and much to my surprise…

Mac OSX already has a built in sqllite3 command line tool.

Within minutes of that discovery, the problems with my Corona SDK SQL queries was solved and I see my database behaving as I expected.

I’m a happy developer with this discovery… I may actually start using SQLite more often now.

[import]uid: 19626 topic_id: 31937 reply_id: 331937[/import]

#2

I am on Mac and using a “Database manager” called “Base” - it is great tool and one of the best I have tried. You can do whatever you want, execute queries, export, import data, etc. I have tried all GUI available and this is one of the best :wink:

Joakim [import]uid: 81188 topic_id: 31937 reply_id: 127377[/import]

#3

If you are on windows, here a free nice administration gui.

http://sqliteadmin.orbmu2k.de

Joakim [import]uid: 81188 topic_id: 31937 reply_id: 127380[/import]

#4

I am on Mac and using a “Database manager” called “Base” - it is great tool and one of the best I have tried. You can do whatever you want, execute queries, export, import data, etc. I have tried all GUI available and this is one of the best :wink:

Joakim [import]uid: 81188 topic_id: 31937 reply_id: 127377[/import]

#5

If you are on windows, here a free nice administration gui.

http://sqliteadmin.orbmu2k.de

Joakim [import]uid: 81188 topic_id: 31937 reply_id: 127380[/import]