I'd always used NexusDB for local dB apps in Delphi, but these days everything I write seems to be freeware anyway, and as I've never written a local dB for an Oxygene app I thought I'd ask here to see what others might be doing.
Currently the application I'm writing will only need Table 1: w/1 Integer, 1 String, and 1 Image. Table 2: w/3 Integers, 9 Strings, and 1 Image. That's it, with a total number of records to be saved being less than 100! I had thought about using XML for this too, but I figured now would be a good time to get up to speed with a more extensible product as long as I'm at it.
What does anyone think about SQLLite? I'm so impatient! <g> And since I did not receive any answers I decided to install MS SQL Express with the Tools, and the small embeddable local dB. This way I'm using a system that integrates into VS, and that will grow as needed for future applications.
Still though, should anyone have any comments or thoughts on this dB or any other, please do not hesitate to let me know. I'm interested in ALL possibilities! Hello.
Sorry for the belated response.
In your case I can suggest to use SQLite. It is quite simple to integrate SQLite support into existing small application. Also please take a look at PostgreSQL and MySQL for big complex projects.
Thanks.
+1 for SQLite, I use it with a .NET 4.0 Oxygene application and it is great!
I wanted it to be clear I was joking about being impatient so I added a <g>, but of course it didn't take...Sorry about that.
As to SQLite, I read quite a lot about it and it seems nearly perfect, but of course it doesn't provide for visual development nor does it integrate into VS 2012. Microsoft's SQL Express provides both when you want them and has a local only version within it that can be used much like SQLite. And this means that I can use the minimal needed for an app like this while not having to re-learn it all if I need something better. But of course, not having ever used either of these before, I will still need to run them both before reaching any conclusions.
For me I found it important that the DB run in-process so SQLite is great, and I never use visual DB designers, I just use ADO.net and LINQ to talk to the SQLite DB
Firebird fan here.
From Delphi time, i m was Firebird fan, but SQLite is crossplatform and works on iOS too! So, imho - FB or SQLite!
I think that Sql Server 2012 actually INCLUDES some local database support (without a server running).
SQL Server Express includes a local dB requiring no server. I haven’t looked at it yet but if it allows visual creation I’m all for it. I’ve never had reason to use plain SQL yet but if I have to I will.
Oh, you’ll be doing some SQL all right… No TADOTable or TQuery for you 
The good news is that once you query the data and build a list of objects filled in, you can just bind a datagrid (or whatever) the list and work away. No need for a TMembtable type thing anymore.
I haven’t used the local db of Sql Server in code, but I assume you still have to write the sql code to access it. Could be wrong though.
You might also want to look into Code First. I haven’t played with either much, so can’t say if these are good suggestions or not, just suggestions.
Firebird, PostgreSQL or SQLite