SQLite Playground
Dev tools
sql playground
SHOW HN2021
SQLite Playground
What I've always lacked is something similar to JSFiddle / CodePen, but for SQLite.
sqlime.orgHow HN took it
8 positive, 10 neutral or asking, 0 mixed, 3 critical, out of 21 comments about the project. Thread score +0.20.
Idea: 3 for, 2 againstExecution: 1 for, 1 againstPrivacy: 1 for, 0 againstDesign: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Runs fully in the browser with no server, so data stays private
From 1 comment
really nice that you've used wasm and no server. This seems really secure to test. I was thinking at first: Hey, this might be kinda dangerous, imagine iterating in a tool and…
nicolasmelo12 on HN
Useful and clean, good for learning and prototyping
From 2 comments
Very cool. What better way to learn than to test and play and iterate. Thanks for making this! And beautiful it is, too.
leobg on HNFive of the six points the OP mentions are relevant, specially #5: > — The latest version of SQLite. And minimalism is certainly appreciated also!
severine on HN
Objections
Unclear what it offers beyond the sqlite command line
From 1 comment
I'm afraid I don't see the point of this at all. What does it offer that running sqlite from my command line does not?
nemoniac on HN
Loads whole database into memory, so large databases are a problem
From 1 comment
Good work, always happy to see new tools related to SQLite and Wasm! As I see, currently you're loading whole DB into the memory, so large databases might become a problem. Did…
shekhirin on HN
Query results are not escaped
From 1 comment
query results are not escaped. haha https://sqlime.org/#gist:d31fd00895d34821797ccde8f94169fe
citrus on HN
Requests
Support for opening files directly via the File System Access API
From 1 comment
Good work, always happy to see new tools related to SQLite and Wasm! As I see, currently you're loading whole DB into the memory, so large databases might become a problem. Did…
shekhirin on HN
Include FTS5 module and more extensions
From 2 comments
How does this compare to phiresky's work? Can you include the FTS5 module?
Scaevolus on HNLooks good, only thing I'd like to see added is the wholenumber extension. It's surprisingly useful for creating mock data for tests.
banana_giraffe on HN
Add more example datasets
From 1 comment
Love it! It'd be nice to have a couple more example datasets, and I'd promote them to the top level (rather than in 'more'). I think the first thing many users will want to do is…
RobinL on HN
Questions
How does it differ from sqlfiddle and db-fiddle
From 2 comments
How does it differ from http://sqlfiddle.com/ ?
lixtra on HNI have been using https://www.db-fiddle.com/
nerdponx on HN
Missing .tables command
From 1 comment
no .tables command?
pugworthy on HN
Alternatives named
SQL Fiddle
From 1 comment
How does it differ from http://sqlfiddle.com/ ?
lixtra on HN
DB Fiddle
From 1 comment
I have been using https://www.db-fiddle.com/
nerdponx on HN
phiresky's sqlite-in-browser work
From 1 comment
How does this compare to phiresky's work? Can you include the FTS5 module?
Scaevolus on HN
sqlforever and csvee
From 2 comments
Looks great! I created something similar at http://sqlforever.com/
paperwork on HNThis is great! Very useful - great work on getting it up and running. Coincidentally I threw together something very similar recently to run sqlite over csv files. It's very WIP…
failingGrace on HN