Lovasoa
LightNews LightNews
banner
ophir.dev
Lovasoa
@ophir.dev
86 followers 200 following 53 posts
Author of https://sql-page.com
Posts Replies Media Videos
ophir.dev
The screenshot

en.wikipedia.org/wiki/User:Lo...
March 27, 2025 at 2:19 PM
ophir.dev
The $200/month GPT-4.5 is "expected to hallucinate less". But even the handpicked examples they give contain hallucinations.
renowned for its luminous depiction of fire The_Trojan_Women_Set_Fire_to_their_Fleet
February 28, 2025 at 1:50 PM
ophir.dev
🚀 Just released SQLPage v0.33... Build a JSON REST API in a single SQL query! 🔥🔗

github.com/sqlpage/SQLP...
INSERT INTO users (name, email) VALUES ( json(sqlpage.request_body())->>'name', json(sqlpage.request_body())->>'email' );
February 15, 2025 at 1:46 PM
ophir.dev
I love python !
dumbdumb and Jedi use SQL
December 30, 2024 at 5:57 PM
ophir.dev
I released a new SQLPage (SQL-to-website tool) for Christmas 🎄

In the update: new features, bugfixes, config options requested by power users.

The new "article" option renders long-form text nicely.

sql-page.com
github.com/sqlpage/SQLP...
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
December 30, 2024 at 9:28 AM
ophir.dev
Today at work...
December 5, 2024 at 11:40 AM
ophir.dev
Live USB
live usb key
December 3, 2024 at 1:33 PM
ophir.dev
Installing software on Linux...
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!
December 1, 2024 at 10:29 AM
ophir.dev
How I feel when I tell database administrators and data scientists about SQLPage
December 1, 2024 at 12:27 AM
ophir.dev
Except for SQL server :
squeel server
November 27, 2024 at 8:32 PM
ophir.dev
Pushed a PR to the 1app5stacks repo that builds the entire app in 135 lines using only SQL and Handlebars — no frameworks, just pure SQLite. Sometimes, less is more. Thanks @t3.gg! 🚀 github.com/t3dotgg/1app... #webdev #sql #js
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.
November 26, 2024 at 5:02 PM