Access to a database (SOLVED)

Questions
#1

Is it possible to access a database (sqlite for example) saved into the app?

#2

How is it saved into the app and what are your options to access it? (driver, web service, etc.) Sorry for the poor support, I haven’t really worked with databases since 12 years ago, I bet a lot has changed. :slight_smile:

#3

There is a wrapper for SQLite. http://lua.sqlite.org/index.cgi/index

But it has to be wrapped as an extension for Defold.

1 Like
#4

The db would be saved into the game app as a file (.db or .sqlite); I would need to open it, execute a query, and close it (I need a database for a words game)

#5

Could I add autonomously this extension to Defold or has it to be deployed by Defold’s Development Team?

#6

As a workaround, you can store all your data in JSON or plain Lua tables. And when you need to perform a search, perform either a direct for loop over the tables or turn them into dictionaries, eg

local words = {one = true, two = true, burger = true}
#7

This manual describes how to add native code (aka native extensions).

#8

I wouldn’t even call this a workaround. This is the way to go. If you have a database such as sqlite, then write a script that reads the content and stores it as json or a Lua table instead.

Have you created the database or someone else? Can you chose to store the data in some other format (such as JSON as suggested above)?

#9

Ok, for me my problem is solved.
Thanks.