Hacker News Reader

rickbergfalkon The asteroid currently hitting front end web development

> Meanwhile, Cursor and Viget have blogged about migrating their codebases from Solid and Lit, respectively, to React.

That was maddening to read. Here I was thinking we should all be migrating to better performing frontend solutions. Does it really take an agent that many more tokens to write Lit or regular HTML and HTMX?

rickbergfalkon Vite 3.0

Yes. Currently using it in production and couldn't be happier.

The individual modules are only served during development, but even then startup/load is faster than our previous webpack setup by an order of magnitude. When you build for production, you still end up with a bundle like you had previously.

rickbergfalkon Why old-school PostgreSQL is so hip again

Proper queuing in RDBMSs can be tricky.

2ndQuadrant has a good write up of what is required to make sure you don't fall into any traps: https://blog.2ndquadrant.com/what-is-select-skip-locked-for-...

Now if we're just talking about persisting data to somewhere - postgres COPY is pretty amazing.

rickbergfalkon Show HN: SqlPad – Run SQL in browser and chart results

Hi HN - SqlPad has shown up here a couple times before but I've never taken the opportunity to do a a Show HN on it yet, so I'm doing that now :)

I recently took a sabbatical of sorts to clean it up a bit, as well as catch up with modern javascript developments.

I just published 2.0.0 to npm. No crazy new features from 1.x or anything, more of a front-end rewrite and polish of user experience while trying to keep the application simple and focused.

rickbergfalkon SqlPad: Run SQL in your browser and chart the results

Thanks! I'd love to hear your thoughts. feel free to send them to me via email or github issue

rickbergfalkon SqlPad: Run SQL in your browser and chart the results

TauCharts has been an amazing library to work with. Its API fits so well with the mental model of how the SQL results map to visualizations. I can't recommend this charting library enough. It's like a mini tableau built on top of d3.

rickbergfalkon SqlPad: Run SQL in your browser and chart the results

Thanks troels! It doesn't but it's something we could keep in mind. Feel free to open an issue on GitHub to make the request. Do you have any examples of what you have in mind?

rickbergfalkon SqlPad: Run SQL in your browser and chart the results

Hi Hacker News! So this is where the extra activity is from :) honored to be posted.

SqlPad was something I built to scratch my own itch and was sort of a self-challenge. I haven't done much with it lately, but a few users have contributed some additions back and have been helping with the project.

Just a heads up if you explore the code - I'm not a Node.js developer by trade and this is sort of a hobby for me as a SQL Server developer/DBA.

I'm flattered by the comments here. Really inspiring to get back to work on this.

Also wanted to add - If SqlPad isn't quite what you're looking for but want to visualize SQL results check out these other projects and solutions:

Metabase (http://www.metabase.com/)

Redash (https://github.com/getredash/redash)

Wagon (https://www.wagonhq.com/)

Periscope Data (https://www.periscopedata.com/)

Mode Analytics (https://modeanalytics.com/)