taffer

26 ms·

301.
by taffer 7y ago
I have no idea how to argue against this nonsense. Basically, these are the same anti-scientific arguments that climate sceptics put forward against climate science or anti-vaxers against medicine. One simply claims that a science is in rea
302.
by taffer 7y ago
This is why laws have exceptions, e.g. one has the right to require that information about oneself be deleted, unless there is another law that requires the retention of the information.
303.
by taffer 7y ago
The table is the relation. A join is just an operation that combines two relations to a superrelation.
304.
by taffer 7y ago
> Relational databases get their name from the fact that relationships can be defined between tables. This is a widespread misconception. Relational databases get their name from relations in the mathematical sense[1], i.e. sets of tuple
305.
by taffer 7y ago
I don't know what you're trying to say. PostgreSQL makes no distinction between primary and secondary indexes. MySQL, which only knows clustered indexes (see "Unreasonable Defaults" [1]) has to make such a distinction, s
306.
The Use Method for analyzing the performance of any system(brendangregg.com)
1 points by taffer 7y ago|0 comments
307.
by taffer 7y ago
I wonder what the advantages / disadvantages were compared to CRT projectors that came out in the 1950s.
308.
by taffer 7y ago
> I believe the poster is talking about deserializing and validating json from REST requests and serializing json for REST responses using the mapping defined for the ORM. These are also things that the json functionality of Postgres can
309.
by taffer 7y ago
> What ORM do people use that influences the structure of their database? Hibernate and JPA encourage designing your domain classes first and then generate the DDL from that. > Also, the ORM allows me to specify models that are not on
310.
by taffer 7y ago
The point was not that the comparison was not perfect, but that it was utterly wrong. SQL is not at a lower level of abstraction than procedural code, but at a higher level. Abstraction should make complex things easier, not harder.
311.
by taffer 7y ago
Have you checked out MyBatis or JOOQ? They sound pretty much like what you're describing.
312.
by taffer 7y ago
The basic idea of the relational model was actually data independence , i.e. optimization for flexibility. If you are interested you can have a look at the original paper from 1970: https://www.seas.upenn.edu/~zives/03
313.
by taffer 7y ago
> Advocating for the use of SQL over an ORM in every case is like advocating for the use of Assembly over C in every case. Comparing SQL to Assembly is probably one of the worst comparisons you can make. SQL is a very high-level and powe
314.
by taffer 7y ago
I always like to link these articles when the topic comes up: https://sivers.org/pg https://www.vertabelo.com/blog/business-logic-in-the-databas... https://www.martinfowler.com/articles
315.
by taffer 7y ago
> [...] services run isolated as their own users [...] provides for a clear and simple mental model [...] How is that a clear and simple model? Are email or printing users ? I think the whole discussion is futile without having a common
316.
by taffer 7y ago
The benchmark [1] that Neo4j uses in its advertising [2] is from 2014, so not much newer either. [1]: https://github.com/opencredo/neo4j-in-action [2]: https://neo4j.com/business-edge/connected-dat
317.
by taffer 7y ago
There is also this [1] paper claiming that > [...] solutions using relational database technology [...] can offer performance superior to that of the dedicated graph databases. [1] https://event.cwi.nl/grades2013/07-
318.
by taffer 7y ago
> More recently the major RDBMS vendors have complemented SQL with directives that address the storage and handling of hierarchical data Oracle could do that 30 years ago, and recursive CTEs are part of SQL:1999.
319.
by taffer 7y ago
> ...not saying it's a good way to do this It really depends. If you do these kinds of queries all the time, it's a good idea to use a graph DB, but if these queries are rare, it often doesn't make sense to add a new techn
320.
by taffer 7y ago
> Is there a caniuse.com for SQL? Not exactly the same, but: https://modern-sql.com/
321.
by taffer 7y ago
My argument was that we should separate the distribution aspects of the tax system from the revenue-generating aspects. > I want to distribute discouragement, i.e. everybody to be equally discouraged from taking a flight regardless of th
322.
by taffer 7y ago
Although the Federal Reserve formally is privately owned, it is a government entity. It was established through a law and is controlled by the Board of Governors, appointed by the US President and approved by the US Senate.
323.
by taffer 7y ago
The Sakila DVD rental database is available for a number of RDMS including Postgres: https://github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/Sakil... There is also the more idiomatic Pagila database
324.
by taffer 7y ago
In software engineering, there is something called separation of concerns, and you should look at taxes in the same way. It is not the concern of VAT, tobacco tax, fuel tax, alcohol tax or salt tax to do redistribution. Instead, we must
325.
by taffer 7y ago
The quote refers to the land itself, not to the structures built on it. In other words, it is an argument for a land tax, not for the confiscation of buildings.
326.
by taffer 7y ago
> Why should we support a system where people can own many properties, each feeding them 1/2 of someone else's paycheck? That doesn't make much sense to me. 1/2 of the paycheck is only true for a few places with limit
327.
by taffer 7y ago
I don't like this idea of "free car rides" at all, I believe it would actually make things worse. There is a cost vs. convenience trade off between public transport and cars, i. e. public transport is much cheaper, but you ha
328.
by taffer 7y ago
> he language I use has a perfectly nice native, iterable data type for returned database records (kind of like an array of dictionaries) What language are you using for that?
329.
by taffer 7y ago
DRM has won. Steam has DRM, Playstation has DRM, Netflix has DRM, Spotify has DRM, practically all browsers support DRM.
330.
by taffer 7y ago
Window functions can be used to compute the median: select percentile_disc(0.5) within group (order by things.value) from things

More ›