Gary Thompson wrote: > Chris, > I hope you have success in completing a migration to GNU / > Linux based systems. >> Is there any reason to choose one database engine rather than >> another? It's only a single user application, no complex locking >> requirements. I've got both mySql and postgresql databases already >> on my system. >> > If you're looking for an engine "similar" to access (in terms of light > weight), I prefer SQLite. The reason is that It's a very simple engine, > is file based (that's probably the only similarity) and you don't really > need to administer a database server (MySQL and PostgreSQL are > examples). However, if the databases are there and available already > then there's no reason not to use them. Another PRO in the SQLite > direction is that it's probably quite easy to migrate between different > machines since a file copy will do the job, as opposed to an export / > import operation for an SQL Server. > > Gary.
Yes, if you don't plan to use you app in a multiuser environment, sqlite would offer the easiest route. If you later want to deploy to multiuser also, you should consider Firebird as your database backend. This would offer both embedded and scalable multiuser environments without big efforts. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
