taffer

7 ms·

31.
by taffer 1y ago
AFAIK relational algebra and relational calculus are based on FOL (first-order logic) which predicates atomic elements. For nested elements you would need HOL (higher-order logic) which is mathematically hard to optimize. As FOL is as power
32.
by taffer 1y ago
There are many people defending relational databases, and rightly so, but I have never heard anyone defend the syntax of SQL. It's just that everyone standardised on it as the language of relational databases in the 1980s. Its inertia
33.
by taffer 1y ago
> With a bit of client-side logic, it's easy to transform that into this [example here] without the need to use json as a middleman. The result in your example looks exactly like JSON. Am I missing something? Also, what is the point
34.
by taffer 1y ago
Putting business logic in the database: https://sive.rs/pg Example code: https://github.com/sivers/store This talk is more Oracle specific but with some minor changes you can apply the same ideas to po
35.
by taffer 1y ago
This is also the conclusion of the article. The author then shows an example of how to get hierarchical json out of your relational database.
36.
by taffer 1y ago
I don't know where you are from (I'm really curious though), but where I live there are more than two political parties and more than a few mega corporations to buy or rent from. You seem to have an extremely distorted idea of wha
37.
by taffer 1y ago
> One of the ironies of this kind of advice is that it's best for people who already have a lot of experience and have the judgement to apply it. For instance, how do you know what the "simplest thing" is? I think the auth
38.
by taffer 2y ago
The university I studied at was in a brutalist building. I loved it and every time I see a brutalist building, it reminds me of my time there.
39.
by taffer 2y ago
Germany is the only Western European country with an Eastern European capital. As a result, Berlin was poorer than the rest of the country, but this is no longer the case. Since reunification, Berlin has had the fastest growing economy in G
40.
by taffer 2y ago
In practice, it is even less. Current state-of-the-art algorithms compress the English Wikipedia using just 0.8 bits per character: https://www.mattmahoney.net/dc/text.html
41.
by taffer 2y ago
> I.e., The string "I'v_" provides way more context than "con_" because you're much more likely to get I'm typing "I've" instead of "contraception" Yes the entropy of the next l
42.
by taffer 2y ago
Have you had a look at the bytea[1] type? It allows you to store binary objects up to 1GB and it's dumped transparently just like a string. [1] https://www.postgresql.org/docs/current/datatype-binary.html
43.
by taffer 2y ago
Here are some articles from 2022 and 2023. Btrfs database performance is still a disaster. [1] https://www.enterprisedb.com/blog/postgres-vs-file-systems-p... [2] https://www.phoronix.com/review/bc
44.
by taffer 2y ago
That's poor advice. Use a database with checksums enabled like DB2, Oracle, Postgres, SQL Server or SQLite with the Checksum VFS Shim. TFA recommends the latter for good reason. Running a database on ZFS results in reduced throughput,
45.
by taffer 2y ago
The most commonly used filesystems on Linux, etx4 and XFS don't do checksums.
46.
by taffer 2y ago
Db2, Oracle, Postgres and SQL Server do checksums.
47.
by taffer 2y ago
Yes, otherwise for ticket owners who are not sure if they will make it to the concert, waiting until the last minute to request a refund becomes a dominant strategy.
48.
by taffer 2y ago
According to a study by the HTW Berlin, Germany collects €50 billion in road taxes and duties, but spends €30 billion on road maintenance and €30 billion on traffic police and road accident victims. Add to this an estimated €10-30 billion i
49.
by taffer 2y ago
The EU should create a standardised system for tickets in Europe, similar to the New Distribution Capability for flights or SEPA for payments. There should also be a unified system for passengers to claim their money back if their train is
50.
by taffer 2y ago
I couldn't disagree more. You can say a lot of bad things about Deutsche Bahn, but of all the travel apps I have used, DB Navigator and bahn.de were the best. SNCF Connect, on the other hand, not only had a terrible UX, but also crashe
51.
by taffer 2y ago
> it's precisely because he was the pioneer, things like Java, microservices, json, APIs, have evolved from Kay's ideas. Not to mention Excel, which uses cells, a concept invented by Alan Kay. He also invented OOP which in 1964
52.
by taffer 2y ago
> I wish I could buy back my own mortgage at a discount given how much interest rates have risen But why would you want to do that? If you take out a fixed-rate loan and interest rates rise, you are already making a profit. Financially,
53.
by taffer 3y ago
As a counterexample, Azure Cosmos or Amazon DynamoDb are marketed as specific solutions for specific problems. Other RDBMS like SqlServer or Postgres are marketed as general purpose solutions because they are in fact general purpose solut
54.
by taffer 3y ago
So what is a good use case for Mongodb? I have never seen an application where a "document database" would have been a good choice. In every project where I have seen Mongodb, it has turned out to be the wrong choice. Even for pro
55.
by taffer 3y ago
Postgres really took off when Heroku became popular in the late 00s.
56.
by taffer 3y ago
Why Fly.io if you want to build a monolith? Compared to Heroku or Render, to me Fly.io seems to be more aimed at edge computing.
57.
by taffer 3y ago
I have no idea what you want to say. Is this what you mean when you talk about riding the personal responsibility bicycle, only this time it is the jargon bicycle?
58.
by taffer 3y ago
> difficult to cancel subscriptions should not be allowed In the European Union, you can cancel any subscription by email.
59.
by taffer 3y ago
In the European Union, you can cancel any subscription by email. There is no need to make a phone call or visit a scummy website.
60.
by taffer 3y ago
> What's wrong with asking businesses to simply not charge you if you don't use the service Pay-per-view services exist. Customers seem to prefer subscriptions. Any subscription model works by amortising costs over a large popu

More ›