Lovasoa's Avatar

Lovasoa

@ophir.dev

Author of https://sql-page.com

85
Followers
198
Following
54
Posts
25.11.2024
Joined
Posts Following

Latest posts by Lovasoa @ophir.dev

Post image

Gemini 3, the smartest model in the world :)

26.11.2025 10:01 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
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

I needed it, so I built it: a visual json schema editor.

json.ophir.dev

30.03.2025 10:04 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

the computer should be allowed to get up and walk around, to help it think.

like a roomba but for general purpose computation.

27.03.2025 19:27 ๐Ÿ‘ 272 ๐Ÿ” 18 ๐Ÿ’ฌ 24 ๐Ÿ“Œ 2
Post image

The screenshot

en.wikipedia.org/wiki/User:Lo...

27.03.2025 14:19 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
renowned for its luminous depiction of fire

renowned for its luminous depiction of fire

The_Trojan_Women_Set_Fire_to_their_Fleet

The_Trojan_Women_Set_Fire_to_their_Fleet

The $200/month GPT-4.5 is "expected to hallucinate less". But even the handpicked examples they give contain hallucinations.

28.02.2025 13:49 ๐Ÿ‘ 1 ๐Ÿ” 1 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
INSERT INTO users (name, email)
VALUES (
  json(sqlpage.request_body())->>'name',
  json(sqlpage.request_body())->>'email'
);

INSERT INTO users (name, email) VALUES ( json(sqlpage.request_body())->>'name', json(sqlpage.request_body())->>'email' );

๐Ÿš€ Just released SQLPage v0.33... Build a JSON REST API in a single SQL query! ๐Ÿ”ฅ๐Ÿ”—

github.com/sqlpage/SQLP...

15.02.2025 13:46 ๐Ÿ‘ 1 ๐Ÿ” 1 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

๐Ÿ‘ต

17.01.2025 17:49 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

What are babushka dolls ? Old matryoshka dolls ? ๐Ÿช†

17.01.2025 17:48 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

This is very cool! But wouldn't that amplify echo chambers? I fear such a system would encourage me never to change my mind about anything. The things I'm "interested in" are the things I think are important in the world. And maybe I'm wrong about what really is important.

06.01.2025 17:36 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Interesting! What are you using it for?

06.01.2025 14:59 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

console.log("Is js fun? ", [1] != '1');

06.01.2025 14:50 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

You won't miss any of these security incidents when you switch to another language that does not require "polyfills" ๐Ÿ˜

06.01.2025 14:33 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

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.

05.01.2025 16:45 ๐Ÿ‘ 2 ๐Ÿ” 1 ๐Ÿ’ฌ 3 ๐Ÿ“Œ 0

Scary! I hope these attempts never succeeded anywhere!

That sounds shortsighted, and a good way to ensure black hats will always have an edge over white hats.

05.01.2025 19:50 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
Preview
Netgear TLS Private Key Disclosure through Device Firmware Images Netgear TLS Private Key Disclosure through Device Firmware Images - netgear-private-key-disclosure.md

No, I don't think this has ever happened to a root certificate.
Root certs have been compromised before, but never leaked publicly, to my knowledge.

But individual TLS certs for valuable domains have of course leaked before, such as gist.github.com/nstarke/a611...

05.01.2025 15:05 ๐Ÿ‘ 10 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

okay, I understand what you meant. signing request is indeed more secure, but it's also a pain in the ass to use when you don't want to go through a custom third party library to make HTTP requests

02.01.2025 17:40 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Session tokens (access tokens) are more likely to get stolen because they are actively transmitted over the network with each API request. They could leak in logs or in a MITM attack. The attacker would not be able to persist their impersonation because they do not have the refresh token.

02.01.2025 17:34 ๐Ÿ‘ 5 ๐Ÿ” 0 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 0

I'm not sure I follow... Session and refresh tokens do use public key cryptography already. The tokens are signed with the identity provider's private key and verified by applications using the provider's public key. What are you suggesting to use instead?

02.01.2025 17:29 ๐Ÿ‘ 3 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
dumbdumb and Jedi use SQL

dumbdumb and Jedi use SQL

I love python !

30.12.2024 17:57 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
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

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

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...

30.12.2024 09:28 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

The rust one should probably return an iterator of options ;)

20.12.2024 19:05 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

I don't know go but is seems like it doesn't do the same thing as the rust and python examples? If there is an odd number of items, the go version returns a tuple with (last, nil) in the end, right?

20.12.2024 18:54 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

That's more like 20 years ago...

09.12.2024 13:43 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Post image

Today at work...

05.12.2024 11:40 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

composable, not compostable, obviously ๐Ÿ˜

04.12.2024 20:54 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Preview
a close up of a man with the words it 's so true below him ALT: a close up of a man with the words it 's so true below him

This! This is why I think nocode tools cannot be the future. We need simple code that anyone can understand, and edit visually, but that is still searchable, versionable, compostable, and copy-pastable like true code.

04.12.2024 20:51 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

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...

03.12.2024 22:05 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
live usb key

live usb key

Live USB

03.12.2024 13:33 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Live CD ? What decade is this ? ๐Ÿ˜…

03.12.2024 13:10 ๐Ÿ‘ 3 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

I would like you to find whoever threw it away, quiz them about SQL, and if they don't remember everything, force them to take the book back. Please.

02.12.2024 19:45 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0