Accessing TapForms DB from outside of TapForms

[Tom Reiter]

I have been searching hard for a nice user friendly DB manager for my Mac. Similar to MS Access on old PC. I think I have found it in TapForms!!! I am currently using the Trial version, with intent (and hopes) to purchase it. I have been experimenting with it for a couple days now and I am really liking it! I am so happy!

However, I think I have run into one VERY BIG PROBLEM. I am wanting to design and create databases that I can use and access from outside of TapForms (I am learning to use XOJO). All of the information that I found and read before trying the trial version indicated that TapForms stored its data in sqlite databases. That was great as that meant I would be able to access the data from other sqlite compatible software.

Well, apparently all those things I read might have been old messages??? The best I can tell now, is that TapForms is not storing the data in sqlite files.

Please tell me that I am wrong, and there is some way around this problem! Is there any way I can access the TapForms databases from XOJO or other sqlite compatible software? I sure hope there is.

If not, are there any recommendations for other user friendly (GUI) db management software I can use? This is just for my own personal use – not any kind of business or anything – so spending $400 on Filemake Pro is not a great solution for me.

I want something user friendly, that includes report building capabilities. In short, I want TapForms! (But it has to create SQLITE files.)

Thanks for ANY help you can provide!!!

[Brendan]

Hi Tom,

I moved your question out of the Template Exchange forum and put it into the Using Tap Forms forum. The Template Exchange forum is where you go to share and find templates submitted by other Tap Forms customers.

As for your question, I replied to your email with my answer, but the short answer is that Tap Forms does use SQLite, but it uses a structure defined by CouchbaseLite, which is as NoSQL structure using JSON document structures to store the content.

You could read the db.sqlite file using an SQLite Manager type app, but the database schema might be very straight forward to understand.

Thanks!

Brendan

[Author]

Posts