Lovasoa

@ophir.dev

88 Followers 201 Following

Author of https://sql-page.com

renowned for its luminous depiction of fire
INSERT INTO users (name, email) VALUES ( json(sqlpage.request_body())->>'name', json(sqlpage.request_body())->>'email' );
dumbdumb and Jedi use SQL
This is a screenshot from an article rendered by SQLPage. Taken from https://sql-page.com/blog.sql?post=JSON%20in%20SQL%3A%20A%20Comprehensive%20Guide
live usb key
Terence Eden @Edent > I really loathe tutorials which say: > "Install XYZ in the normal way." > WHAT'S THE NORMAL WAY?!?!?!?! > Lovasoa @lovasoa@mastodon.social > @Edent the normal way: > * Check if it's in your package manager. (It's not.) > * Add a random PPA. (Breaks everything.) > * Compile from source. (Requires 12 libraries you don't have.) > * Sacrifice a goat. > * Reboot. (Doesn't work anyway.) > Normal. > Let me know if you need anything else!
squeel server
A horizontal bar chart comparing the primary and secondary lines of code (LOC) across different tech stacks used in the "1app5stacks" project. The chart displays both the primary language LOC (shown in sky blue) and total lines of code, which include secondary files (shown in light coral), for each stack. Ruby on Rails: 509 primary lines and 1,014 total lines. Elixir + Phoenix: 991 primary lines and 1,395 total lines. Elixir + Phoenix (without turbo): 832 primary lines and 1,236 total lines. Go + GraphQL + React: 440 primary lines (TypeScript) + 423 (Go), totaling 940 lines. OG T3 Stack: 443 primary lines (TypeScript) and 585 total lines. RSC version: 427 primary lines (TypeScript) and 453 total lines. RSC version (without turbo): 334 primary lines (TypeScript) and 360 total lines. SQL + Handlebars: 42 primary lines (SQL) and 148 total lines. Analysis: The chart illustrates a stark contrast between complex, full-stack frameworks and minimalistic approaches like SQL + Handlebars. While traditional stacks such as Ruby on Rails and Elixir + Phoenix involve hundreds or even thousands of lines of code, the SQL + Handlebars solution stands out with just 42 lines of SQL and 93 lines of Handlebars, totaling only 148 lines. This shows the efficiency of using simpler, more direct technologies to achieve the same app functionality. The Go + GraphQL + React and T3 Stack are somewhere in the middle, with moderate complexity but still far fewer lines than the Ruby on Rails and Elixir solutions. The chart highlights the trade-off between simplicity (fewer lines of code) and the richness of functionality and tools provided by more complex frameworks.