Get SQLite Working

[z3ugma]

I love what you're doing here with this pattern. What are the big barriers to getting SQLite working?

[keredson]

thanks!

sqlite is tricky, as it doesn't support a number of the normal schema modification SQL commands. (and often requires created a new table, copying data, and deleting the old.) but i've already been through it the the django version of this tool, so prob. can pull out a lot of my old notes, and it'd be mostly rote work + testing.

are you using sqlite in production somewhere? i could be pretty easily talked into implementing it, if you're serious about using it, and would be willing to help test and whatnot.

[faisalraja]

I support this feature. We use sqlite for local and PostgreSQL on production.

[JosXa]

Hi, SQLite is still not listed in the supported dbs a year later. Is this still on your roadmap? :)

[metalcamp]

@faisalraja why would you even think of doing that? Development must match production. Unless you develop on production. :>

[faisalraja]

@metalcamp we did switch to postgresql on local but still kept bunch of our integration tests on sqlite. I actually made an auto migration also with sqlite support since I used the peewee way of adding columns but it's in that closed source project.

[z3ugma]

For what it’s worth, I am using SQLite in both dev and production.

[leosok]

Your tool is amazing. And works like a charm with MySql. Sqlite would be so great - your migration tool should not be the reason to change DB :-) How could we help?

[Nixellion]

2 years later still hoping for sqlite. I do use it in production quite a bit. Its great for websites and small to medium deployments. Portability is also quite useful in a lot of cases.

[crossmax]

I'm here because I was thinking library support SQLite. I hope the feature too.