lovasoa

6 ms·

31.
by lovasoa 2y ago
If the electricity were generated by thousands of volunteers pedalling in their basement, then yes, I would expect the utility company not to be too greedy.
32.
by lovasoa 2y ago
I tried passing just the plot to several models: ChatGPT (4o): Noticed "a pattern" Le Chat (Mistral): Noticed a "cartoonish figure" DeepSeek (R1): Completely missed it Claude: Comp
33.
by lovasoa 2y ago
This resonates with me. I used to love tinkering with "underdog" tech. I did frontends in svelte before it was cool. But for new projects, I now always default to react+tailwind, because that's what Claude knows best. And fo
34.
by lovasoa 2y ago
And since the gold supply is limited, fewer shovels would indeed be required.
35.
by lovasoa 2y ago
Law enforcement could probably just ask cloudflare for the exact IP address that retrieved the attachment.
36.
by lovasoa 2y ago
The principle of the software seems to be that the original data is never altered. It is a postgres extension that "masks" the data for certain postgres users. You can always connect as the root user and see everything when you ne
37.
by lovasoa 2y ago
Does anyone here know more about the unreliability of Google's sub claim? I am using it, and have never had issues with it, but this post seems to just dismiss it without more details. When does Google change the subject of a token for
38.
by lovasoa 2y ago
Dashes in API keys are really annoying. Double-clicking doesn’t select the full key, which just adds extra hassle. It would be much better if they used a continuous string without any separators. Makes copying and pasting way easier, and do
39.
by lovasoa 2y ago
I have never heard of anyone in the developed world who would be afraid to criticize Al-Qaeda or the Taliban or Isis. Actually I have never heard anyone NOT criticize them when talking about them.
40.
by lovasoa 2y ago
Making a good user interface is definitely not easy. Yet it's orders of magnitude easier than writing ffmpeg. That said, there is nothing wrong with a paid wrapper around a large and complex open source library. Distributing their work
41.
by lovasoa 2y ago
The best solution, that the LLM did not find, is def find_difference(nums): try: nums.index(3999), nums.index(99930) except ValueError: raise Exception("the numbers are not random") return 99930 -
42.
by lovasoa 2y ago
Starting with a Google Sheet is perfectly fine, but for building a non tabular user interface, or having a few thousand records, I would directly switch to something like SQLPage with a SQLite database.
43.
by lovasoa 2y ago
The researchers leverage existing language Chain-of-Thought data, where each sample consists of a question, reasoning steps, and the final answer. At stage 0, the model does not generate any thought tokens, and is just trained to yield the
44.
by lovasoa 2y ago
All I want for Christmas is a good LSP for SQL ! Ideally one that would be customizable enough to allow SQLPage functions and parameters.
45.
by lovasoa 2y ago
ccp is the Chinese version of c++. Or maybe they meant ссср, the Soviet version.
46.
by lovasoa 2y ago
I would love to see it succeed! They mention testing that bytecode generation generates the exact same results as SQLite... Does this exclude writing new optimization passes that are not in sqlite?
47.
by lovasoa 2y ago
doesn't this apply to most websites on the web?
48.
by lovasoa 2y ago
But aren't these folks already served well by PocketBase ? And by the time they get a million user, they will probably not be hosting on a single "tiny box" anyway. At what point do you think : okay, I need PocketBase, but te
49.
by lovasoa 2y ago
The project looks great ! But I wonder who the audience is... The website says "serve millions of customers from a tiny box". Who does this appeal to ? Solo developers who have million of users, need very low latency, yet are happ
50.
by lovasoa 2y ago
This is a cool approach to integrating SQL with static site generation! If you're into SQL-powered tooling, you might find something like https://sql-page.com interesting as a comparison point. It flips the model by letting
51.
by lovasoa 2y ago
From a practical standpoint, for anyone who needs to parse SQL today, I can recommend datafusion's sqlparser-rs. This is what we use in http://sql-page.com , and I regularly contribute to it. I don't know anything else
52.
by lovasoa 2y ago
An interesting topic is how to fight Hyrum's law. A possibility is to add randomness in things you don't want people to rely on. If I remember well, this is what the QUIC protocol does. Some fields are unused in the current versio
53.
by lovasoa 2y ago
Optimizing out static expressions can be done in linear time at best. So if the number of clauses in WHERE is huge and the size of the underlying table is tiny (such as in the examples shown in the article we are commenting on), it will be
54.
by lovasoa 2y ago
The topic of huge queries on tiny databases makes me think of this recent discussion on the SQLite forum: https://sqlite.org/forum/forumpost/0d18320369 Someone had an issue because SQLite failed to optimize the fo
55.
by lovasoa 2y ago
This sounds like a cool project! Does anyone here knows how it compares to univerjs ? I currently use univerjs to power the open source sql spreadsheet component I work on ( https://github.com/sqlpage/sqlpage-spreadsheet
56.
Unearthing the Past with PostgreSQL; Open Source in Digital Archaeology [video](youtube.com)
1 points by lovasoa 2y ago|0 comments
57.
by lovasoa 2y ago
> $ sqlite3 whois-log-copy.db "select source from queries"|sort|uniq|wc -l Oh cool they saved the logs in a database ! Wait... |sort|uniq|wc -l ?? But why ?
58.
by lovasoa 2y ago
I think getting support requests from users who don't know what they are doing is actually a great problem to have. I have a project that allows building web applications out of SQL queries [1]. When I started receiving support request
59.
by lovasoa 2y ago
It's strange to call CTEs a "postgres feature". It's standard SQL, it's in all databases.
60.
by lovasoa 2y ago
Thank you! I'd love to get your feedback if you use it.

More ›