lovasoa

11 ms·

91.
by lovasoa 3y ago
Hey! It's me on the video. Indeed, making this really 100% SQL-only had very interesting and unexpected consequences. I see people who were initially far away from programming circles creating GitHub accounts just to post on the discus
92.
by lovasoa 3y ago
I am currently looking for a solution to run automated tests on a sql website generator I am working on ( https://sql.ophir.dev ) I wanted to use hurl ( https://hurl.dev/ ), but Bruno's UI seems to be useful
93.
by lovasoa 3y ago
- Hey ChatGTP ! What it 69* 94 ? - The result of 69* 94 is 6466.
94.
by lovasoa 3y ago
I like to think of AI as the physical CPU my programs run on. I have no idea how to build a modern CPU, and building one would be way out of my reach anyway, but it is general-purpose enough and interchangeable enough for me to be able to b
95.
by lovasoa 3y ago
Navalny didn't go back to Russia because Trump told him to.
96.
by lovasoa 3y ago
Maybe that's an opportunity for a pull request to the dart protobuf library?
97.
by lovasoa 3y ago
The result of clip.[...].call(...) is already a buffer, isn't it? You just have not to touch it at all. And on the cpp side, remove the json encoding and just return a raw buffer.
98.
by lovasoa 3y ago
Looking at the rest of your code, it looks like you are doing a lot of unnecessary processing on these embeddings. They even seem to be doubly json encoded at some point: https://github.com/ente-io/clip-ggml/blob&#
99.
by lovasoa 3y ago
SQLite supports raw binary BLOBs, and I would store embeddings as a simple 512*4 = 2048 bytes blob representing just the float32 embeddings. Then you can access the data from the buffer directly in dart: https://api.dart.dev&#x2
100.
by lovasoa 3y ago
> This feature reminded me of the MySpace worm in ~2005 (heck, I wasn't even alive then!) I instantly felt old.
101.
by lovasoa 3y ago
I make a SQL-only website builder (SQLPage) that could be qualified as low code. I think all the points mentioned are valid, but some of them are easy to work around: > They wanted truly custom functionality that the low-code solution co
102.
by lovasoa 3y ago
I feel obligated to add a shameless plug here. The idea is very close to a project I presented at pgconf.eu last week: SQLPage https://sql.ophir.dev/ SQLPage has the same goal as postgrest+htmx, but is a little bit higher l
103.
by lovasoa 3y ago
You can make 1 query per second to it for free, including large queries that contain images ? This is crazy ! I will happily let google buy me for that price. https://ai.google.dev/pricing
104.
by lovasoa 3y ago
I initially thought this would be about the mold linker ( https://github.com/rui314/mold )
105.
by lovasoa 3y ago
> If you're just using SQLite to write and read full JSON blobs, the JSON datatype will be the best pick. There is no json data type ! If you are just storing json blobs, then the BLOB or TEXT data types will be the best picks.
106.
by lovasoa 3y ago
As the maintainer of sql.js and SQLPage, I am very excited about this: - json is used a lot by sql.js users to interact with JavaScript. - to generate more sophisticated web pages in SQLPage, json is crucial I can't wait for the next r
107.
by lovasoa 3y ago
This mullvad thing is just another "what is my ip" service. His site lets you download the entire database locally, for free, and without registration.
108.
by lovasoa 3y ago
I agree with the reasoning. However, an important point to note is that libraries are much harder to monetize than services.
109.
by lovasoa 3y ago
No, there is just one definition, and it's his son's: https://en.m.wikipedia.org/wiki/Absolute_value#Complex_numbe...
110.
by lovasoa 3y ago
Maybe you would see these comments if github actually innovated fast. They could make a search that finds what you are looking for, for instance.
111.
by lovasoa 3y ago
I use replit to give people a quick way to play with my open source projects online without installing anything on their computers ( https://replit.com/@pimaj62145/SQLPage ). But I have always been on the free plan. Thei
112.
by lovasoa 3y ago
Really? In my experience, it's worse than chatgpt 3.5. I had it answer me things like "this model, which costs 38k€ is cheaper than this other one, which costs 29k€". I've never seen ChatGPT make such basic mistakes.
113.
by lovasoa 3y ago
It would be great if someone could open a github issue with reproduction steps and maybe a screenshot: https://github.com/lovasoa/SQLpage/issues The worst I'm able to get when manually disabling the cache and
114.
by lovasoa 3y ago
thanks for the feedback ! I cannot replicate that on my computer with any browser, and all seems normal to google pagespeed insights as well: https://pagespeed.web.dev/analysis/https-sql-ophir-dev/4o7q6... Which b
115.
by lovasoa 3y ago
I have been thinking about that a lot recently. Where I work, we spend a very small fraction of our time on building things that are unique to our business. Maybe we are doing something very wrong, but I am under the impression that most of
116.
by lovasoa 3y ago
I just tried it and you are right. Ran docker run --cpus 0.1 --rm -it progrium/stress --cpu 16 and the machine's cpu sits idle.
117.
by lovasoa 3y ago
According to the article, this is not true. The limits become active only when the host cpu is under pressure.
118.
by lovasoa 3y ago
Hey, that's a good question, and the tools do have some overlap. Here is my (totally biased) comparison: - datasette builds one single website and API, which you cannot customize, on top of a SQLite database. It is a little bit ugly, b
119.
by lovasoa 3y ago
Yes, he is definitely guilty. But he had never said "it's ok to steal if you give to charities". Not does anyone in effective altruism, I think.
120.
by lovasoa 3y ago
He denies being a fraudster to this day.

More ›