lovasoa

13 ms·

121.
by lovasoa 3y ago
This is correct, and my initial comment was naive.
122.
by lovasoa 3y ago
> most would rather save their own child’s life than a million random children The idea of effective altruism is that this is immoral, and that our instinctive behavior of being so indifferent to the sufferings of those we don't fee
123.
by lovasoa 3y ago
Is this a reference to Sam Bankman-Fried ? He was a promoter of effective altruism and also a fraudster. But I'm not sure why that should prevent non-fraudsters to also promote effective altruism.
124.
by lovasoa 3y ago
You are right. I'll update the website !
125.
by lovasoa 3y ago
These things always make me uneasy. On the one hand, I understand they are in a very hard situation. On the other hand, donating to research into rare neurological diseases will literally save hundreds of times fewer lives than donating to
126.
by lovasoa 3y ago
I'm not sure I understand this comment. The parent asked whether SQLPage could be used to update data in the database after inserting it. I answered that yes, it could. The update form would look something like this: select &#x27
127.
by lovasoa 3y ago
The official website for SQLPage ( https://sql.ophir.dev/ ) is written in SQLPage. The sql source code for it is here: https://github.com/lovasoa/SQLpage/tree/main/examples/offici...
128.
by lovasoa 3y ago
You write the SQL yourself, so you can do anything you want, including UPDATE parties SET name=:name, date=:date WHERE id=:id;
129.
by lovasoa 3y ago
For your next app backend, you should try SQLPage [1][2] It makes creating a small web form to feed your database as easy as SELECT 'form' AS component; SELECT name, label, type FROM form_fields; INSERT INTO parties
130.
by lovasoa 3y ago
You are replying to someone who builds C programs for 6 OS and 2 architectures without an #if ;)
131.
by lovasoa 3y ago
Yes ! Maybe I'm old-fashioned, but I do still think that SQL is a better interface to databases than excel formulas, and classical spreadsheet UIs are a better interface for, well, spreadsheets. I am building an open-source tool that a
132.
by lovasoa 3y ago
postgREST is a traditional web service that opens tcp connections to the database. Omnigres allows you to run your own custom http request handling code inside the database.
133.
by lovasoa 3y ago
I think they were talking about syntax like INSERT INTO t(a,b,c) VALUES (1,2,3) I agree that something like INSERT INTO t VALUES a=1, b=2, c=3 would be much more readable.
134.
by lovasoa 3y ago
These are good points, but I'd like to nuance some of them. Disclaimer: I work on an SQL web application builder [1] that shares a lot of the philosophy behind Omnigres. - about scaling: you have to get very far before saturating a sin
135.
by lovasoa 3y ago
Nice to see Omnigres trending on hn; congratulations Yurii! The project is interesting, and thought provoking, because it goes against the often recommended "good practice" of separating storage and compute. Doing the exact opposi
136.
by lovasoa 3y ago
So... what is the optimal percentage of memes ?
137.
by lovasoa 3y ago
Interesting. Since the tool I'm presenting is something that lets you write websites in SQL, "code deep dives" referred more to code that you can write as a user of the tool than things going on "under the hood". I
138.
by lovasoa 3y ago
Thanks for the advice ! I'll try speak slowly, and not to overload the presentation. I was thinking that maybe, instead of the support being slides, it could be a website written in SQLPage itself... Or do you think it's too much
139.
Ask HN: What do you like to see in tech talks?
15 points by lovasoa 3y ago|15 comments
140.
by lovasoa 3y ago
When I come across this scenario, I often ponder whether it's part of the business strategy for those who offer open-source software for free alongside a paid hosted version. There seems to be a conflict of interest at play here: the m
141.
by lovasoa 3y ago
This looks like the perfect usecase to extract the data to sqlite, and slap a quick SQLPage UI on it !
142.
by lovasoa 3y ago
The question was: in what context do people need to answer a question like "which geographical points are close to X and similar to X"? I don't understand who the target audience is and what this can be used for.
143.
by lovasoa 3y ago
the second error is because you need to add a `-csv` argument to sqlite
144.
by lovasoa 3y ago
I am skeptical about the "observe any quota" part. Bandwidth is not free.
145.
by lovasoa 3y ago
> curl -s https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip | gunzip | sqlite3 ':memory:' '.import /dev/stdin stdin' "select Date from stdin order by USD as
146.
by lovasoa 3y ago
I remember seeing a blog post by Mozilla explaining how the new css engine, which is measurably faster, would never have been implemented in C++ because the engineers were not confident they could handle the tricky concurrency issues in tha
147.
by lovasoa 3y ago
Wow, this comment is very rude and completely out of place.
148.
by lovasoa 3y ago
The tech is very impressive but the results are not. I searched "pointy building in Paris", and got : Tourism in Paris, Bourse de commerce (Paris), Grands Projets of François Mitterrand, List of tallest buildings and structures in
149.
by lovasoa 3y ago
How big does the database need to be for large BLOBs to become a problem ? "big" and "small" are quite subjective terms. How many BLOBs does one need to have, and how often to we need to touch them for this solution to b
150.
by lovasoa 3y ago
Isn't it harder when you have to later report to management that actually, your 45TB of production data do not fit on the 50TB tape ? I suppose compression ratios vary a lot between users of these things, right ? And if you are backing

More ›