Skip to content
Sign upLog in
← Back to Community

Issues with sqlite

Profile icon
Chas2002

I've been working on a python code for several weeks. Sqlite was working fine until about 4 days ago, now when sqlite is accessed if malforms.

I've back out to known working versions of the code.
I've checked package version to ensure updates haven't caused it.
Everything is the same as it has been for weeks.

Did Replit make any changes from 4 days ago that would effect sqlite?

Voters
Profile icon
AlexRodriguez1
Profile icon
Chas2002
Comments
hotnewtop
Profile icon
NoelB33

Ok so, SQLite doesn't work on repl.it Because of the way repls reset data, a lot of your data will get cleared every time it runs. Id recommend using the built in database API or a cloud storage one such as mongoDB.

Profile icon
Chas2002

@NoelB33
Thanks for the reply. But just to reiterate, SQLite worked fine for weeks and it's not about data being lost, if I do a select only statement -- the database becomes malformed.

Profile icon
NoelB33

Yeah, that’s because your running it in your own account.

@Chas2002

If you go into the external terminal or if you run it outside of the IDE everything will break in your database. For your issue, I have no clue, but seriously, don’t use sql on repl.it.

Profile icon
AlexRodriguez1

Yeah it seems to be a repl.it issue I was going mad trying to figure out what I was doing wrong with my code lmao. I literally just saved the changes to my github and re-opened the same repository on my ubuntu vm and it literally worked fine.