michelpp

29 ms·

271.
by michelpp 7y ago
Only a CROSS join is a Cartesian product which is rarely used.
272.
by michelpp 7y ago
> I used to have a copy of "SQL for Dummies" at hand whenever I, with dread in my heart, needed to write some SQL, especially if there was any funky stuff like joins and such going on. SQL isn't so much a programming langu
273.
by michelpp 7y ago
There is a Python library that uses SKIP LOCKED https://github.com/malthe/pq
274.
by michelpp 7y ago
Thanks for the pointers, I like Essential Craftsman too, a bit of philosophy with some great technique and history thrown in.
275.
by michelpp 7y ago
It seems like something they could easily verify: they know the exact location of the truck when the package is marked delivered. If it doesn't correlate with the delivery address then something is up. Another clue would be a bunch o
276.
by michelpp 7y ago
Your upstream tooling is going to have to compile something into that data structure you propose, and then you're going to want to do ad hoc queries easily as a human, and end up inventing something worse. Side note with postgres you c
277.
by michelpp 7y ago
They're superficially easy to understand, but end up moving the complications of concurrency, transactions, and statistical query planning up into the application. Those are much harder problems to solve correctly than just learning S
278.
Increasing Velocity with GraphQL and PostgreSQL(youtube.com)
2 points by michelpp 7y ago|0 comments
279.
by michelpp 7y ago
> I lost count of how many different libs/frameworks i saw that exposed CRUD through HTTP, all failed miserably, because it is actually very dumb idea. The whole point of HTTP is CRUD (Create Read Update Delete). PostgREST maps t
280.
by michelpp 7y ago
In case, like me, the headline makes you think it's related, this is not the same as Pieter Hintjen's C4 development process, the "Collective Code Construction Contract": https://rfc.zeromq.org/spec:42&#x
281.
Show HN: PostgreSQL Extension for Libsodium(github.com)
7 points by michelpp 7y ago|0 comments
282.
by michelpp 7y ago
The audio in the link appears to only be a 5 minute excerpt, not the full 50 minute lecture.
283.
by michelpp 7y ago
If you can find it an audio recording of this lecture is also available and it is one of the best lectures in the series. Feynman really brings forward the "soul" of algebra and the illustrates how powerful the art of abstraction
284.
by michelpp 7y ago
https://en.wikipedia.org/wiki/Amdahl%27s_law
285.
by michelpp 7y ago
It doesn't help much for people visiting here in the US, but when I travel outside the country I use this handy rhyme: 30 is hot 20 is nice 10 is cold 0 is ice
286.
PostgreSQL Wins 2019 O'Reilly Lifetime Achievement Award
56 points by michelpp 7y ago|2 comments
287.
by michelpp 7y ago
Thanks espeed! I'll give this a read.
288.
by michelpp 7y ago
> Does this work in blocking or non-blocking mode? Naively I imagine there might be more opportunity for the GraphBLAS implementation to optimize execution in non-blocking mode. Non blocking mode. > Is there a way to efficiently store
289.
by michelpp 7y ago
pygraphblas author here. scipy.sparse and graphblas are superficially similar in that they provide a sparse matrix type, but scipy.sparse is oriented more toward mathematical matrix computation and provides a wonderful and huge bag of tool
290.
Show HN: Graph Processing with Python and GraphBLAS(github.com)
122 points by michelpp 7y ago|19 comments
291.
Python and GraphBLAS(github.com)
5 points by michelpp 7y ago|0 comments
292.
by michelpp 7y ago
THe process is similar, you would convert to csv and then use the \copy command to bulk insert the data. In pg 12, the copy command has grown a lot of very useful features like WHERE filtering, so if you get the chance go for 12: https:&#
293.
by michelpp 7y ago
I agree with this big time. One of my favorite Feynman quotes is that science is an "expanding frontier of ignorance". There is always somewhere to go and something on the other side, that may change everything and invalidate de
294.
by michelpp 7y ago
TEXT, like all Postgres varlena types, is limited to 1GB. Which for many people is effectively without limit.
295.
by michelpp 7y ago
The Book of Why, by Judea Pearl. http://bayes.cs.ucla.edu/WHY/
296.
by michelpp 7y ago
Oregon cities are constrained by an Urban Growth Boundary. https://www.oregonmetro.gov/urban-growth-boundary I agree with your sprawl argument in general, but specifically for this article it does not apply.
297.
by michelpp 7y ago
As others have pointed out there are some features considered essential in this space that would be good additions to the code: Stemming: (removing prefix/suffixes walked, walking, walker -> walk) The snowball library contains many
298.
How to Be More Productive(youtube.com)
2 points by michelpp 7y ago|0 comments
299.
by michelpp 7y ago
Postgraphile is fantastic, as is PostgREST and I support them both on Patreon because they have changed my life for the good immensely. They both delegate the application entirely to Postgres, which can do everything all other GraphQL/
300.
by michelpp 7y ago
Perhaps one of the best videos on YouTube "Don't talk to the Police": https://www.youtube.com/watch?v=d-7o9xYp7eE

More ›