Hacker News new | ask | show | jobs
by sametmax 3525 days ago
But does this mean your migrations are limited to only one type of DB ? So if you switch from sqlite to oracle, you loose all your migrations?

In that case, I'll stick with my ORM solution.

2 comments

If you switch you vendor, you will probably have to fix manually many things, be it migrations, code, etc. An ORM-based solution is a thing, but then you lose the ability to use vendor-specific behavior, unless your ORM have specific extension for those, and then you're back at square one.
The site clearly says: A simple and language-independent SQL schema migration tool and that it has first-party drivers for SQLite, MySQL and Postgres. I'm guessing it uses the lowest common denominator (the ANSI SQL standard), so any crazy FFI C extensions you wrote might be left in the lurch.