Hacker News

Article URL: https://chatgpt.com/share/673d5043-cf90-800e-98f0-1ef4963c6baf

Comments URL: https://news.ycombinator.com/item?id=42190468

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/news/articles/cy4g193qezno

Comments URL: https://news.ycombinator.com/item?id=42190456

Points: 1

# Comments: 0

Demo: http://www.sqltab.com/static/average_earning.gif

Try it here: https://www.sqltab.com/demo

Main features:

- AI-powered SQL assistant. Allows (one-click) execution and undo/redo of SQL generated by the AI.

- GUI to rename, remove, and reorder columns in SQLite tables.

- Undo/redo support using SQLite's savepoints [1].

- JSON data expansion: https://www.sqltab.com/static/json_expand.gif

- The pivot table extension [2] is loaded and available for use. The AI is also aware of it.

Privacy & Data:

- Databases are stored locally in the browser using OPFS.

- Database schema is sent to OpenAI as part of the chat session's context window. If the chat session contains results of data querying, then that will also be sent to OpenAI with the next message.

Tech stack:

- WASM build of SQLite (using a custom fork of the official repo [3]).

- React + Mantine for the UI.

- esbuild to build the frontend (invoked from Go). So much faster than the alternatives.

- Hosted on Cloudflare Pages, deployed via wrangler CLI.

- Single API endpoint just to proxy OpenAI calls in order to hide my API key. Hosted on Cloudflare Pages Functions (very practical but only for simple things).

Technical notes:

- The entire application is a static website except for the OpenAI proxy. Planning to support user-supplied API keys to (optionally) get rid of this.

- OPFS storage comes with some limitations (e.g., no incognito mode on mobile, same DB can't be opened in multiple tabs).

- gpt-4o is used for the LLM. Might switch to gpt-4o-mini to save costs.

Why not DuckDB?

- I got some out-of-memory errors when expanding JSON data. SQLite worked fine on the same data.

- No OPFS support yet. PRs have been pending for a year now.

If you want to reset the demo, just delete the IMDB.sqlite database (disk icon in the top-left corner -> "Delete DB") and load the demo URL again in the browser.

Please let me know if you have ideas about how to make this more useful.

[1] https://www.sqlite.org/lang_savepoint.html

[2] https://github.com/jakethaw/pivot_vtab

[3] https://sqlite.org/wasm/doc/trunk/about.md

Comments URL: https://news.ycombinator.com/item?id=42190445

Points: 1

# Comments: 0

Article URL: https://www.wsj.com/science/space-astronomy/nasa-to-assign-delivery-missions-to-spacex-blue-origin-as-part-of-artemis-lunar-exploration-campaign-70bc94d1

Comments URL: https://news.ycombinator.com/item?id=42190443

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/future/article/20241118-how-new-yorkers-are-reclaiming-their-harbours-heritage

Comments URL: https://news.ycombinator.com/item?id=42190436

Points: 2

# Comments: 0

Article URL: https://www.servethehome.com/lenovo-has-a-cxl-memory-monster-astera-labs-intel-xeon/

Comments URL: https://news.ycombinator.com/item?id=42190434

Points: 1

# Comments: 0

Article URL: https://apnews.com/article/arthur-frommer-died-7293814296854079a3a10f05d02faf44

Comments URL: https://news.ycombinator.com/item?id=42190427

Points: 1

# Comments: 1

Article URL: https://finance.yahoo.com/news/novo-erases-2024-gain-wiping-124742884.html

Comments URL: https://news.ycombinator.com/item?id=42190422

Points: 1

# Comments: 0

Article URL: https://welltypedwitch.bearblog.dev/nominal-for-storing-structural-for-manipulating/

Comments URL: https://news.ycombinator.com/item?id=42190418

Points: 2

# Comments: 1

Article URL: https://github.com/leaningtech/webvm

Comments URL: https://news.ycombinator.com/item?id=42190395

Points: 11

# Comments: 1

Article URL: https://github.com/bluesky-social/atproto/discussions/3049

Comments URL: https://news.ycombinator.com/item?id=42190379

Points: 11

# Comments: 1

Article URL: https://www.theverge.com/2024/11/19/24301056/strava-api-ai-data-sharing-policy-change-fitness-tracking

Comments URL: https://news.ycombinator.com/item?id=42190341

Points: 3

# Comments: 0

Article URL: https://www.cnbc.com/2024/11/19/hr-block-intuit-stocks-fall-following-trump-tax-filing-app-report.html

Comments URL: https://news.ycombinator.com/item?id=42190318

Points: 5

# Comments: 2

Article URL: https://www.ft.com/content/894669d6-d69d-4515-a18f-569afbf710e8

Comments URL: https://news.ycombinator.com/item?id=42190305

Points: 1

# Comments: 0

Article URL: https://www.youtube.com/watch?v=gEVYQ9lJCFE

Comments URL: https://news.ycombinator.com/item?id=42190237

Points: 1

# Comments: 0

Article URL: https://publichealthpolicyjournal.com/a-systematic-review-of-autopsy-findings-in-deaths-after-covid-19-vaccination/

Comments URL: https://news.ycombinator.com/item?id=42190236

Points: 1

# Comments: 0

Article URL: https://mitpress.mit.edu/9780262038836/model-checking/

Comments URL: https://news.ycombinator.com/item?id=42190215

Points: 1

# Comments: 0

Comments URL: https://news.ycombinator.com/item?id=42190213

Points: 1

# Comments: 1

Article URL: https://www.shopify.com/news/david-heinemeier-hansson-board

Comments URL: https://news.ycombinator.com/item?id=42190205

Points: 1

# Comments: 0

Article URL: https://nickelinstitute.org/media/lxxh1zwr/2023-nickelplatinghandbooka5_printablepdf.pdf

Comments URL: https://news.ycombinator.com/item?id=42190199

Points: 1

# Comments: 0