Usually more a problem of people using "features" of a db over another, and when migration to the "other" finding their dbi code doesn't work against it. 

I've this this trying to adapt with a blunt object code to work with postgres vs. mysql.  They used some math function in mysql or the perl dbi for it that I'd have had to rewrite in a function outside to do.  I just ended up having to run both db's for some network monitoring suites that liked one or the other sadly.

Use of an abstraction layer like sqlalchemy helps that, but i am not a dba or developer to extol virtues (or detractors) beyond that.

-mb


On 05/28/2015 08:25 AM, Mark Phillips wrote:
Are there easy ways to migrate from SQLite to MySQL if I find I have under estimated what I need for a database?

Mark

On Thu, May 28, 2015 at 8:01 AM, Michael Butash <michael@butash.net> wrote:
Consider also the redundancy aspect, expect drives to fail and things like that.  Do you want a production website down while you restore the os, reinstall everything, and presume to have an up to date backup of the db right before it died?  Rather have a copy on a partner replication slave a cluster can start feeding clients when the first dies.

Also consider if you're ever going to need to scale the website outside a monolithic single server, say with haproxy, dedicated hardware load-balancers, etc in front of mulitiple app servers. You need a way to scale data horizontally, maybe replicating between regions, replicating state of an in-use transaction (think shopping carts), etc.

SQLite is usually for a down/dirty local install of something that needs a db regardless of a real one or not, or used as local scratch for performance reasons.

-mb


On 05/28/2015 03:17 AM, Joseph Sinclair wrote:
It really is a matter of preference most of the time, but there are still some situations where one or the other has a significant advantage.

As one example:
PostgreSQL (and it's forks) has some high availability clustering support that isn't available currently for MySQL (and it's forks).
MySQL has some sharding support that isn't yet matched in the Postgres world.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss