michelpp

19 ms·

151.
by michelpp 5y ago
Michel van Biezen has an excellent video series on Kalman filters: https://www.youtube.com/watch?v=CaCcOwJPytQ He walks you though all the way from the rationale, to a simple algebraic example, to the full blown Linear Alge
152.
by michelpp 5y ago
My go-to approach is to insert jobs into a queue table, and then have backend workers that consume items from the queue. This has a number of advantages: 1. Faster user experience, the user isn't waiting for the business logic to comp
153.
by michelpp 5y ago
This is my personal experience with using PostgREST (I haven't had the full supabase experience yet): > What does devops look like? I usually spin PostgREST workers up in some kind of managed container service, like Google Compute
154.
by michelpp 5y ago
> * For the simple case, they seem like they are as good as a simple backend service, albeit easier to set up. Agreed. > * For more complex cases (e.g. external dependencies, complex business logic), they seem so much more difficult t
155.
by michelpp 5y ago
> then all those production systems do it wrong. I agree! Let's put aside that being the OWNER of a database object means that by default is granted all privileges to it, and that owners aren't (typically) filtered by Row Level
156.
by michelpp 5y ago
Another approach would be to use a lazy property: https://pypi.org/project/lazy-property/
157.
by michelpp 5y ago
There are a couple of key features that PostgREST provides that I have not seen in other web frameworks. That's not to say others don't exist, but there are some definitely modeling and security anti-patterns that have become unf
158.
by michelpp 5y ago
> 1) what is the cost of a mistake (what if I misconfigure row-based policy vs. misconfigure in the traditional backend) Good question. Ok let's do a thought experiment between PostgREST and Django. Every single Django production
159.
by michelpp 5y ago
> Maybe you're referring to the underlying concept rather than the implementation, but wasn't row-level security added to Postgres in 2016? Yes you are correct my statement was too vague, I was referring to Postgres' role
160.
by michelpp 5y ago
My point was your anecdote has nothing to do with PostgREST. It's a foggy hand wave that could be laid over just about anything with an HTTP socket on one end and a database on the other.
161.
by michelpp 5y ago
> It certainly feels like PostgREST and systems like it are dancing close to the fire here, since there's a lot less in between you and an attacker. There are definitely fewer buffered copies of your responses, yes. This is one adva
162.
by michelpp 5y ago
I'm not sure why you're getting downvoted, this is a fine question. One approach is to use Point In Time Recovery. When you run your migration, you take note of the LSN (the point in the WAL stream) just before you make your chan
163.
by michelpp 5y ago
You insert a job into a work queue, and process it asynchronously.
164.
by michelpp 5y ago
I heard there was this one website that released software with a bug in it once that leaked data.
165.
by michelpp 5y ago
Seems like this would be a good use case for a "TV Honeypot" that would intercept phone-homes, recognize the model, imitate whatever jank rpc is needed to keep the unit happy, and dump all telemetry to /dev/null.
166.
The Fundamentals of Heavy Tails: Properties, Emergence, & Estimation(adamwierman.com)
3 points by michelpp 5y ago|0 comments
167.
Show HN: Pgexpanded an example “expanded” C data type for Postgres(github.com)
2 points by michelpp 5y ago|0 comments
168.
by michelpp 5y ago
No one here is hyping Forth, they're conversing about and in some cases expressing admiration for what is an amazing and fun little language. Some FORTH systems can fit into less than 10 kilobytes of memory. FORTH was invented in 1968
169.
by michelpp 5y ago
Sarkar addresses this other evidence in this interview: https://youtu.be/JJzU9hDjiRk?t=819 In summary, there is a strong selection bias in cosmology toward the standard model which induces "predictions" that confi
170.
by michelpp 5y ago
There is a logarithmic semiring: https://en.wikipedia.org/wiki/Log_semiring which can be used to multiply two sparse matrices with the GraphBLAS. here is an example in Python: https://github.com/Graphe
171.
by michelpp 5y ago
Clearly a a shot across the bow for Cerebras and another excellent target for the GraphBLAS. Dense numeric processing for image recognition is a key foundation for what Tesla is trying to do, but that tagging of the object is just the begin
172.
by michelpp 5y ago
Doh, repo was set to private. Fixed. Thank you!
173.
Show HN: Install a local PostgreSQL Server with pip(github.com)
2 points by michelpp 5y ago|2 comments
174.
by michelpp 5y ago
I should have been more specific, I was referring to CM-Lisp as shown in the paper not *Lisp with the !! syntax.
175.
by michelpp 5y ago
The book "The Connection Machine" by Danny Hillis is a fantastic account of the philosophy of the CM design. When I was in high school, I didn't have a computer, I only had computer books from the library, and TCM was a huge
176.
by michelpp 5y ago
Great list, another one I would add is "The Misbehavior of Markets" by Benoit Mandelbrot: https://www.amazon.com/Misbehavior-Markets-Fractal-Financial...
177.
by michelpp 5y ago
Using Linear Algebra to solve Graph problems, in particular, algebra over Tropical Semirings. Here's a great, but not graph specific, introduction to the advanced math behind the subject by Madeline Brandt: https://www.yout
178.
Show HN: A new Triangle Graph Centrality algorithm(github.com)
2 points by michelpp 5y ago|0 comments
179.
by michelpp 5y ago
Yes this is an important distinction between and extension for Postgres vs a fork of . The short-sightedness of forking boggles my mind every time. Oh, you don't want a team of hundreds of literally the best Postgres programmers in
180.
by michelpp 5y ago
That's something that I think can be put into context with a short preface. I think propaganda is some of the most interesting parts of history.

More ›