2 questions about sqlite

igrishaev · June 2012

Hi!
I have 2 questions about sqlite support in Gideros.

1) Is sqlite available on Android? If not what I need to store relational data?
2) Couild you show me code with sqlite example? I'm trying to do:

db = sqlite3.open("test.db")

but take error: "attempt to index global 'sqlite3' (a nil value)"
Wha'ts wrong? My OS is Windows 7 64 bit, Gideros 2012.2.2.1.

Regards,
Ivan

TokyoDan · June 2012

Yeah. I'd sure like to see an example too. I've seen tutorials on how to create plugins. But I can't find any info on how to use the plugins.

evs · June 2012

I haven't used it but you need to require it to use it

require("lsqlite3")
db = sqlite3.open("test.db")
print(db)

output: sqlite database (0x10883ce08)

cheers

evs

igrishaev · June 2012

@evs
Great thanks,it works!
So, second question is solved.
Now, what about Android support with sqlite?

Michal · August 2012

Yes please! +1 for sqlite for android.

talis · August 2012

Yeah +1 for sqllite android support.

Nascode · August 2012

+1 for sqlite android support

*squeak squeak*

ar2rsawseen · August 2012

Here is an example for sqlite:
http://giderosmobile.com/forum/discussion/comment/9750#Comment_9750

And android platform is not yet supported. I'd say because there wasn't much of requests for it. Maybe now things will change

petec · August 2012

+1 for sqlite android support from me too!

jojobarcream · December 2012

+1 for sqlite android

I 've implement a game using sqlite in ios.
But when I try to port to android. It lack sqlite feature.

BigWinston · February 2013

+1 for sqlite porting to Android.

I'd say it's a must for Gideros going forwards. I have a complicated data structure for my game and storing in text files or XML isn't going to cut it.

PLEASE make this happen!

norc · February 2013

+1 for Android sqlite support.

hasanalperen · February 2013

+1 for Android

Cyberience · March 2013

Heres an odd Question.

Storage has 2 places, one is application assets and is read only, can not modify or write files into this location, second is the temp storage cache location, when deploying, do I need to copy the sqlite db into the working area before I open it, or can it remain in the deployed location?

atilim · March 2013

I've added sqlite plugin for Android. But please read the limitation http://giderosmobile.com/documentation/reference_manual.html#sqlite3 before using it.

talis · March 2013

@atilim thank you very much for hearing our request for sql in android platform.

you rock ^:)^

BBurgess66 · September 2013

@atilim:
the link is not working .. but past this neither is 'db:first_row' from the LuaSqlite docs

ar2rsawseen · September 2013

Hello,
the correct link is: http://docs.giderosmobile.com/reference/plugin/sqlite3#sqlite3

And I don't seem to see 'db:first_row' here: http://lua.sqlite.org/index.cgi/doc/tip/doc/lsqlite3.wiki

Howdy, Stranger!

Categories

In this Discussion

Top Posters

2 questions about sqlite

Comments

Howdy, Stranger!

Quick Links

Categories

In this Discussion

Top Posters

2 questions about sqlite

Comments