Alembic not updating db properly

[elmaisbuscado]

Alembic not updating db properly

[doomedraven]

don't use sqlite3! that is dev database format for testing, there is warning for that, use proper database like postgres, we spoke with Kevin, i won't support that crap which is just for dev, use proper things and enjoy performance or write alembic for sqlite3 :P

here you have how to install it
https://github.com/doomedraven/Tools/blob/master/Cuckoo/cuckoo.sh#L426
and here how to create db
https://github.com/doomedraven/Tools/blob/master/Cuckoo/cuckoo.sh#L473

then just change connection like showed here
https://github.com/doomedraven/Tools/blob/master/Cuckoo/cuckoo.sh#L596

[kevoreilly]

Yeah I was caught out by this but have managed to switch to psql without too much trouble. Although I just started with a fresh database, saving an existing one might not be so easy...

[doomedraven]

to get everything back to work, modify lib/cuckoo/core/database.py set schema to 36926b59dfbb and then in options size back to 255 from 1024, but you will start getting luck of some features which required that upgrade

[elmaisbuscado]

Ok, is solved using Postgres. Maybe should remove sqlite3 support¿? This will breaks for everyone using sqlite3...

[doomedraven]

we spoke about to remove that, but no, people should read warnings when no connection is set, sqlite3 is useful for quick test of cape, or in some dev where you don't need db, you just want to make feature and forget

we have another alembic upgrade which we "postponed" due to that sqlite3 problem