Looks promising, but I need to access structured data stores, i.e. SQLite. Is there support (I cant see in the docs so far)? If not, is it planned, and if so when?
Thanks [import]uid: 1736 topic_id: 99 reply_id: 300099[/import]
Yeah, this is a definite must [import]uid: 1440 topic_id: 99 reply_id: 56[/import]
Ditto — I have a couple of “reference work” types of apps to develop, and would like to try Corona. If there’s not a persistence API, then a pointer to a design pattern for using existing libraries (if possible) would be great. [import]uid: 1778 topic_id: 99 reply_id: 61[/import]
We will be adding SQL Lite support.
We expect that to be available in the second half of August
Here is a link you could look at http://luasqlite.luaforge.net/
or http://lua-users.org/wiki/LuaSqlite
Ansca [import]uid: 24 topic_id: 99 reply_id: 63[/import]
One more thing, we have file i/o support. If you need to write to a file …
Also we have luasocket support (we have not documented it fully as we are still working on some features for it).
Ansca [import]uid: 24 topic_id: 99 reply_id: 64[/import]
Hi Corona Team,
Can you make a sample project using LuaSqlite? I need this badly.
Thanks!
Jon [import]uid: 3544 topic_id: 99 reply_id: 771[/import]
we are looking into luasqllite 
and will provide sample
c [import]uid: 24 topic_id: 99 reply_id: 775[/import]
Hi, thanks for looking into it. I’d also appreciate a summary of how a simple traditional iPhone app would be structured in Corona: For example, a dictionary app that’d make use of the typical navigation and text display elements. I couldn’t find that in the Sample Code area. [import]uid: 1778 topic_id: 99 reply_id: 784[/import]
Hi Carlos,
When can we expect the sample project for the sqlite? Or can you point me to the right direction if I’m going to figure out this on my own?
I’m halfway through my word game and I cannot continue building unless I can start verifying words against the dictionary database.
Many thanks!
Jon [import]uid: 3544 topic_id: 99 reply_id: 787[/import]
Any updates? [import]uid: 3544 topic_id: 99 reply_id: 810[/import]
We are looking into doing the sql bindings and we may have to push that until 1.2 update. I will keep you posted.
http://lua-users.org/wiki/LuaSqlite
Carlos
[import]uid: 24 topic_id: 99 reply_id: 816[/import]
I’d second (or fifth) that request for sqlite. I have an project in mind that I think would otherwise be a good fit for development with Corona, but it has a database component (about 8000 to 50,000 records). Being new to the SDK (I’ve only played with it for a few hours now) is there some other database-like solution in Corona / Lua that I should be looking at for working with that number of records. Or is is possible to mix Objective-C and Corona in the same project, so that I could front the sqllite access with an Objective-C module? Thanks. [import]uid: 5143 topic_id: 99 reply_id: 1036[/import]
is the 8,000 to 50,000 records on the web? or with the app when the app installs?
we don’t allow you mix lua and objective-c
we plan on sql lite for 1.2 but looks like we may get this feature before as it is getting a lot of request.
who would be interested in helping us test it?
Carlos [import]uid: 24 topic_id: 99 reply_id: 1049[/import]
Count me in Carlos. Thanks!
Jon [import]uid: 3544 topic_id: 99 reply_id: 1050[/import]
The records would be local (with the app when the app installs). Each record would be small though (less than 300 - 500 bytes) so I think the total size will be reasonable.
Wow, talk about responsiveness. I’ve only been using the product for several hours and already you are willing to add a major feature outside of the planned release cycle! Seriously though, count me in as well to help test. [import]uid: 5143 topic_id: 99 reply_id: 1053[/import]
I will ‘sixth’ the request for SQL Lite. I am considering getting a Corona license, but database support is a real necessity for the project I have in mind.
Anyway, I’ve downloaded the current SDK and I’ll see what I can do. Congratulations on the great product! [import]uid: 5330 topic_id: 99 reply_id: 1054[/import]
Any update on SQLite?
http://lua-users.org/wiki/LuaSqlite
Is this a temporary solution then? Can I just require the luasqlite library and put my sqlite database file in the project directory, or will it not build that way? [import]uid: 4621 topic_id: 99 reply_id: 1369[/import]
Any update on SQLite?
http://lua-users.org/wiki/LuaSqlite
Is this a temporary solution then? Can I just require the luasqlite library and put my sqlite database file in the project directory, or will it not build that way? [import]uid: 4621 topic_id: 99 reply_id: 1726[/import]
LiveToCollect, have you had success with the LuaSQLite? Can you share your experiences? I need to develop an app who will require a small database and it would be nice to have it in a real DB than a text file.
Thanks,
Alex [import]uid: 4883 topic_id: 99 reply_id: 1765[/import]
Luasqlite won’t work with Corona today. [import]uid: 54 topic_id: 99 reply_id: 1806[/import]