4 ms·
Sqlime: Online SQLite Playground
- Whiteshadow12 3y agoThis is really pretty.
- fuzztester 3y agoI tried it a little. It did work a few times, but it did not or was quite slow at other times. Good idea though.
- mritchie712 3y agohere's a duckdb-wasm version[0] (not open-source, but author said they were working towards that in another thread) 0 - https://sql-workbench.com/ https://sql-workbench.com/
- beppler 3y agoVery cool, I'll try it later.
- fforflo 3y agoPeople should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean https://github.com/nalgeon/sqlean. It's a worthy effort.
- 101008 3y agoOfftopic: Does anyone know a quick way (that does not require manual work) to convert a simple mysql db into sqlite?
- jitl 3y agoDump a CSV, import to SQLite. All your columns will be type TEXT and your nulls will be “” (empty string) but hey at least you didn’t do any manual work
- hiAndrewQuinn 3y agoSimone's csvs-to-sqlite would be the next level up, I think it does actual type conversions.
- jitl 3y agoNice, I needed to do this task recently for large CSVs (15gb) and didn’t come across this tool. Under the hood it manipulates the CSV using pandas data frames, then finally dumps the data frame into sqlite using `dataframe.to_sql(sqlite_conn)`. I wonder how fast this is, if it has to take each row from the data frame through Python it can’t be that quick but maybe there’s something smart happening under the hood that can punch a native-to-native pathway through the Python abstractions. I ended up writing my own in Golang since the ones I found in C and other languages didn’t use threads or did too much memory copying.
- hiAndrewQuinn 3y agoHa, yes, Go is probably going to be at least an order of magnitude speedup from Simon's Python based tool. I'd be curious to give your tool a test run if the code is up anywhere.
- rcaught 3y agoAlso see: https://github.com/simonw/datasette-lite https://github.com/simonw/datasette-lite
- deleted 3y ago[deleted]
- maxloh 3y agoThis is incredible work. However, the project doesn't follow best practices in the JavaScript ecosystem. The included WebAssembly (wasm) file should be fetched from npm on build time, instead of being uploaded to the project. https://github.com/nalgeon/sqlime/blob/0bb684c/js/sqlite/sqlite3.wasm https://github.com/nalgeon/sqlime/blob/0bb684c/js/sqlite/sql...
- neerajdotname2 3y agoThis is a side note. I built "Learn SQL" using SQLite. https://courses.bigbinaryacademy.com/learn-sql/ https://courses.bigbinaryacademy.com/learn-sql/