Database as part of Standalone app

dalkin · Post by **dalkin** » Tue Jul 10, 2007 3:20 am

If I build a standalone app. can it be bundled with aMySql database available to the user through localhost? I'm looking for a way to save text changes and retrieve images for use in a stack and db seems to be the only solution that will meet this need. True?

Janschenkel · Post by **Janschenkel** » Tue Jul 10, 2007 6:34 am

Hi Dalkin,

MySQLrequires a setup to run, and this may get messy. If the database is single-user and local, you might be better off using the SQLite driver that comes with Revolution 2.8.1

Hope this helped,

Jan Schenkel.

asawyer13 · Post by **asawyer13** » Tue Jul 10, 2007 8:29 pm

There is a version of MYSQL that is portable that might work.
It can be setup to start via a command line, and I suspect could be made to work.
I think it's from xampp.
Alan

cyoung_mi · Post by **cyoung_mi** » Mon Jun 02, 2008 3:17 pm

Can RunRev work with some other form of database file?
Like Microsoft Access or something that doesn't need a server?

BvG · Post by **BvG** » Mon Jun 02, 2008 3:58 pm

Valentina and SQLite don't need a server installation (Though Valentina has it as an option).

Janschenkel · Post by **Janschenkel** » Mon Jun 02, 2008 6:01 pm

Just for completeness: you can use ODBC drivers to connect to Access databases; however, while Windows ships with an Access driver, MacOSX does not, and I'm not sure about the Linux situation.
There are also some limitations when connecting with ODBC databases: not all databases will return table names and some may only support forward-only result sets.
So your best choices are SQLite (free) or Valentina (commercial).

Jan Schenkel.