Sqlime: Online SQLite Playground | Hacker News Reader

Sqlime: Online SQLite Playground

github.com

138 pointsthunderbong13 comments

Open articleView on HN

People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean. It's a worthy effort.

here'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/

This is a side note. I built "Learn SQL" using SQLite. https://courses.bigbinaryacademy.com/learn-sql/

Also see: https://github.com/simonw/datasette-lite

This 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/sql...

I tried it a little.

It did work a few times, but it did not or was quite slow at other times.

Good idea though.

Offtopic: Does anyone know a quick way (that does not require manual work) to convert a simple mysql db into sqlite?

Dump 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

Simone's csvs-to-sqlite would be the next level up, I think it does actual type conversions.

Nice, 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.

Ha, 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.

This is really pretty.

Very cool, I'll try it later.

Reply on news.ycombinator.com