Skip to content
← Back to Community
SQLite Browser
Profile icon
mrletts

I am teaching SQL to my students and we are using SQLite and Python.

It would be great if there was a built-in SQLite browser so students could see their database tables/entries.

Voters
Profile icon
SaxonHays
Profile icon
ItsTato
Profile icon
aloisFLEURY
Profile icon
rzapata2
Profile icon
RonaldSchildge
Profile icon
PaoloAmoroso
Profile icon
mrletts
Comments
hotnewtop
Profile icon
21natzil

Great idea, I would advise you to put this on https://repl.it/feedback for a quick response. Keep in mind, as of now, repl.it does a lot of things that can corrupt sqlite files. I would suggest using :memory: as the file path when teaching SQLite. This way it will create a database in memory and not write to a file.

Profile icon
PaoloAmoroso

@21natzil Can you elaborate on what are the things Repl.it can do to corrupt SQLite files?

Profile icon
CrispyPotato

@PaoloAmoroso

Hey sorry for the 3 year long wait! However, with my time using it, any sql update function will corrupt it. I've been using SQlite for a while doing my own thing and that's just what I've found. I haven't found any other way to avoid corruption with the SQlite file.

However, for a note: While the SQltie file IS corrupted, your Replit can still read it, but not the browser. Replit will be able to make updates, insert, select, fetch, all of the above.

Profile icon
PaoloAmoroso

@CrispyPotato Thanks for the information. Replit changed a lot over the past few years. If it still corrupts files, it should be reported as a bug.

Profile icon
CrispyPotato

@PaoloAmoroso Hey so good news! I just now found out that if you download the whole Repl as a zip file then extract it and use that sqlite file, it will work just fine!

Profile icon
PaoloAmoroso

@CrispyPotato Interesting, thanks.