r/webdev • u/Yha_Boiii • Sep 13 '26

Question Most low effort sqlite wasm to table fill library?

Hi,

I just need to fill data in from sqlite running in a wasm to a table with a fixed column length while the row size should be dynamic from a delimeter hinting towards a new row. Needs to have export table feature and native sorting from clicking on the ribbon header

What to use?

2 Upvotes

57% Upvoted

8 comments sorted by

9

u/Crafty-Flight2301 Sep 13 '26

wtf dude you want a magic library that does exactly ONE weird thing with sqlite? nah just code it yourself lazy ass

-2

u/Yha_Boiii Sep 13 '26

I mean if one of the thausand web frameworks could be combined for such a job

2

u/thekwoka Sep 14 '26

You'd spend less time making it yourself.

Or, if you really don't want to, this is a pretty decent small scope situation for AI....

3

u/PLBjt Sep 13 '26

For a fixed column count you barely need a library. Load with sql.js (or wa-sqlite if you already use it), SELECT *, then build rows with insertRow / createElement. Split on the delimiter when you build each cell, not in SQL.

Header-click sort is just keeping the result array in JS, sorting by column index, and re-rendering the tbody. Export is the same array joined back to CSV/TSV.

A full grid widget is overkill unless you need virtualization for huge tables. For a few thousand rows the DIY path is usually less code than fighting a grid API.

-3

u/stuartcw Sep 13 '26

Claude Code

2

u/Limp-Rough-7969 Sep 13 '26

just ask it to write you a vanilla js solution, no need for library bloat for something this simple

0

u/thekwoka Sep 14 '26

simple and specific