5 ms·
SQLite-Web: Web-based SQLite database browser written in Python
- joewils 3y agoMy favorite web-based SQL editor and browser: https://www.adminer.org https://www.adminer.org Single PHP file. Super simple setup and configuration.
- jokoon 3y agoI don't understand, what's the point of writing this in python?
- LVB 3y agoAs opposed to? FWIW the author has many Python tools, including a popular ORM (https://github.com/coleifer/peewee https://github.com/coleifer/peewee)
- IshKebab 3y agoI guess if you need a web-based solution this looks nice. Otherwise SQLiteStudio is definitely better.
- 0x073 3y agoSad story, database could be native in browsers. Only because every browser adapt the same technology sqlite and w3c said no....
- makapuf 3y agoStrange because if every browser adopts sqlite why not let people use it ? W3c will not prevent people using some tech ? Ofc it won't be standard, until it is? Soon, sqlite implementations may even fork and then we would need standardising.
- maxxk 3y agoI think that the ultimate result (sqlite-wasm) is better than what Web SQL database could provide. Today you can bundle your own version with your own set of native extensions. In case of standard Web SQL you would be forced to check the version and figure out, is it finally possible to use RETURNING in queries.
- SeriousM 3y agoThat looks slick! May I express my feedback: the "content" tab should show the data as grid and maybe have an inline editor. Grid is the ultimate display of table data, at least for me. Thanks for sharing!
- dartharva 3y agoNon-IT guy here, can someone explain to me how good/bad of an idea using this simple setup of SQLite + this interface as the core DBMS in a commercial setting would be? The interfaces I have used in my experience were built in-house over Apache Spark and Microsoft SQL, and always felt overengineered and more complicated than it needed to be. For the record I have learnt data retrieval and analysis only on the job and not from any formal training, apologies if I am missing something fundamental.
- virtue3 3y agoif it's built in house it's probably got some business logic / rules built into it. This tool wont necessarily know about any specifics about how the database relates to your business.
- ocdtrekkie 3y agoSQLite can start to show weaknesses when you need a bunch of people or processes writing to it at the same time. For small applications or applications where you can tightly control what is talking to it at any given time, SQLite is great. Enterprise products tend to target larger organizations where a more overengineered solution is likely commonly available anyways. Generally though, I want developers to justify why SQLite isn't good enough for their app before they build on something else. In a lot of cases SQLite absolutely is good enough, and it removes an insane amount of complexity, especially from things like database backups.
- willsmith72 3y agoi tend to lean the other way. postgres is just so easy. with managed db services, you dont have to think about backups, version upgrades, all the rest. you never have to worry about running into a rough edge or missing feature. the maturity and huge community make it hard to go wrong
- tracker1 3y agoAgreed... As soon as you need shared access to multiple systems, PG it is, usually in Docker though if it doesn't need a dedicated instance. Though I have used Firebird when I needed to scale it support local and remote data before. I don't think Figured gets nearly enough attention.
- rcarmo 3y agoThis uses peewee, which is probably the nicest ORM I’ve ever used anywhere.
- deleted 3y ago[deleted]
- koffiezet 3y agoThis is something I was actually looking for a while ago and settled for a linuxserver's docker image running vnc and sqlitebrowser to inspect some databases on my homelab, which felt like an unsatisfying solution - this looks a like a much nicer, better and more lightweight solution.
- ceeam 3y agoAny advantages over phpliteadmin, for example?
- reacweb 3y agohello, at work, I am not admin. I have developed a small flask site using sqlite. Always using commandline was painful. I have considered phpliteadmin, but this requires many tasks for installation. My boss would not understand that I spend half a day on this. I have discovered SQLite-web today. It took me less than a minute to use it. This is exactly what I was looking for.
- tracker1 3y agoI'd suggest spending a little time with Docker and compose.. even in small, single server applications it helps a lot to smooth out application deployments. It will reduce friction in practice.
- lgxz 3y agoSuggestion: toggle to show/hide the sidebar (the table list) to give more space for table contents.
- creatonez 3y agoHere's one that works entirely clientside via Webassembly - https://sqliteviewer.app/ https://sqliteviewer.app/ Upload your bloated firefox `places.sqlite` and select `moz_places` and it loads it without a hitch... if you trust the website not to steal your browsing history. Unfortunately sqliteviewer.app is not open source. This one (https://inloop.github.io/sqlite-viewer/ https://inloop.github.io/sqlite-viewer/) is, though. But it uses a JS reimplementation of sqlite rather than true sqlite in WASM.
- hiccuphippo 3y agoSince it's webassembly, I wonder if it can be made to work completely on the client with something like Orca (https://orca-app.dev/ https://orca-app.dev/) so you don't even need to trust the website.
- Snapstromegon 3y agoIt already works completely clientside. The page makes no requests to the server after putting your DB into it.
- hiccuphippo 3y agoI meant without the browser as its own client. How can you be sure the page won't change and upload your db the next time you use it?
- qwtel 3y agoYou can't, but as the author I can assure you that I'm very trustworthy lol I've been thinking about a standalone version for a while, but haven't gotten around to it. You could use the vscode/codium extension and disable auto updating for a similar effect.
- throwaway4aday 3y agoWhat about the official project? https://sqlite.org/wasm/doc/trunk/index.md https://sqlite.org/wasm/doc/trunk/index.md
- AriedK 3y agoAnother great browser for SQLite - DB Browser for SQLite (DB4S) project (https://github.com/sqlitebrowser/sqlitebrowser https://github.com/sqlitebrowser/sqlitebrowser). An amazing piece of software for interacting with SQLite databases. Supports inspecting and modifying data, full query support, integrated plotting functions.
- dkatz23238 3y agoI think something like this for Duckb would also be amazing!
- deleted 3y ago[deleted]
- adius 3y agoIf you’re interested in hosting your SQLite databases online for sharing, collaboration, and as the backbone of your apps, please check out https://airsequel.com https://airsequel.com. We’ve been working on it for the last 2 years and our next release is going to be the 1.0! Let me know what you think
- zellyn 3y agoI usually just spin up datasette (hi, simonw) for this, although this looks prettier in a “they just used bootstrap“ kinda way (not that I'm denigrating that… it made all our internal tools at work look really nice for years!). datasette's origin story orients it towards readonly access, and it is strictly and overwhelmingly more powerful in that regard, due to the 139 and growing plugins. The 46 (according to the website) associated tools that datasette has should work equally well with any sqlite-related tooling. Also, datasette's completely automatic faceting (if your data is sane-ish) is really nice. Hmmm. They're both Python… maybe they should unite, Voltron style! :-)
- deleted 3y ago[deleted]
- CyberDildonics 3y agoI understand why people want to write in python, but I don't understand why anyone wants to use software written in python if it might be sensitive to latency, performance or interactivity.
- rmorey 3y agoSeems similar to Datasette: https://datasette.io https://datasette.io https://github.com/simonw/datasette/ https://github.com/simonw/datasette/