2 questions about sqlite

Comments

• TokyoDan Member

  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.

  Dan Huffman, Creator of The Octagon Theory
  http://TheOctagonTheory.com

  +1 -1Share on Facebook
• evs Member

  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

  +1 -1Share on Facebook
• igrishaev Member

  June 2012

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

  +1 -1Share on Facebook
• Michal Member

  August 2012

  Yes please! +1 for sqlite for android.

  Likes: hosamred, SinisterSoft, norc

  +1 -1 (+3 / -0 )Share on Facebook
• talis Guru

  August 2012

  Yeah +1 for sqllite android support.

  Likes: SinisterSoft, norc

  +1 -1 (+2 / -0 )Share on Facebook
• Nascode Guru

  August 2012

  +1 for sqlite android support
  
  *squeak squeak*

  Likes: SinisterSoft, norc

  have fun with our games~
  http://www.nightspade.com

  +1 -1 (+2 / -0 )Share on Facebook
• ar2rsawseen Maintainer

  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

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook
• petec Member

  August 2012

  +1 for sqlite android support from me too!

  Likes: SinisterSoft, norc

  +1 -1 (+2 / -0 )Share on Facebook
• jojobarcream Member

  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.
  
  

  Likes: SinisterSoft, norc

  +1 -1 (+2 / -0 )Share on Facebook
• BigWinston Member

  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!

  Likes: SinisterSoft, norc

  +1 -1 (+2 / -0 )Share on Facebook
• norc Member

  February 2013

  +1 for Android sqlite support.

  Likes: norc

  +1 -1 (+1 / -0 )Share on Facebook
• hasanalperen Member

  February 2013

  +1 for Android

  +1 -1Share on Facebook
• Cyberience Member

  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?

  REAL programmers type copy con filename.exe
  ---------------------------------------

  +1 -1Share on Facebook
• atilim Maintainer

  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.
  

  Likes: talis

  http://en.wikipedia.org/wiki/Cytorus

  +1 -1 (+1 / -0 )Share on Facebook
• talis Guru

  March 2013 edited March 2013

  @atilim thank you very much for hearing our request for sql in android platform.
  
  you rock ^:)^

  +1 -1Share on Facebook
• BBurgess66 Member

  September 2013

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

  +1 -1Share on Facebook
• ar2rsawseen Maintainer

  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

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook