Lovasoa
banner
ophir.dev
Lovasoa
@ophir.dev
I needed it, so I built it: a visual json schema editor.

json.ophir.dev
JSONJoy Builder - Visual JSON Schema Editor
Visual JSON Schema editor for creating and manipulating JSON Schema definitions. Open source at https://github.com/lovasoa/jsonjoy-builder
json.ophir.dev
March 30, 2025 at 10:04 AM
Reposted by Lovasoa
the computer should be allowed to get up and walk around, to help it think.

like a roomba but for general purpose computation.
March 27, 2025 at 7:27 PM
March 27, 2025 at 2:19 PM
The $200/month GPT-4.5 is "expected to hallucinate less". But even the handpicked examples they give contain hallucinations.
February 28, 2025 at 1:50 PM
🚀 Just released SQLPage v0.33... Build a JSON REST API in a single SQL query! 🔥🔗

github.com/sqlpage/SQLP...
February 15, 2025 at 1:46 PM
Reposted by Lovasoa
That would create legal risk. When I was part of the VeriSign practices group, we pushed to get attempts to crack keys that are in use criminalized in various countries. Not sure how far we succeeded.

I was always a defense in depth guy: use every possible control.
January 5, 2025 at 4:45 PM
I love python !
December 30, 2024 at 5:57 PM
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...
December 30, 2024 at 9:28 AM
Today at work...
December 5, 2024 at 11:40 AM
I am rewriting SQLPage's documentation.

Now components have a detailed description with examples and a better overview of available parameters.

sql-page.com/component.sq...
sql-page.com
December 3, 2024 at 10:05 PM
Reposted by Lovasoa
adventofsql.com

Not Advent of Code in SQL, but actually Advent of SQL.
Advent of SQL 2024
Try the advent of SQL 2024 and finally master SQL!
adventofsql.com
December 2, 2024 at 7:28 AM
Installing software on Linux...
December 1, 2024 at 10:29 AM
Just learned you could bridge Mastodon and Bluesky accounts. Pretty cool!

fed.brid.gy
Bridgy Fed
fed.brid.gy
December 1, 2024 at 10:24 AM
The screenshot suggests poor JSON support in SQL databases, but it only reflects the standard JSON_TABLE function!

Most DBs have non-standard equivalents: json_each (SQLite), json_array_elements_text (Postgres), openjson (Microsoft SQL Server), etc.

About that:
sql-page.com/blog.sql?pos...
December 1, 2024 at 9:54 AM
Reposted by Lovasoa
JSON support in SQL is not about storing JSON documents¹.

While storing JSON in SQL tables is possible and sometimes quite useful, the true power of JSON in SQL comes from the ability to *process* JSON within SQL.
November 29, 2024 at 10:22 AM
How I feel when I tell database administrators and data scientists about SQLPage
December 1, 2024 at 12:27 AM
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
November 26, 2024 at 5:02 PM