michelpp

33 ms·

331.
by michelpp 8y ago
Quoting Andreas Freund from the mailing list: """ Btw, the xp_cmdshell thing the author references several times? It can be enabled via tsql if you have a privileged account. https://docs.microsoft.com/en-us&#
332.
by michelpp 8y ago
COPY TO/FROM PROGRAM is not a bad feature. It is in fact an amazing and wonderful thing that makes ETL with Postgres much more powerful. Almost all language runtimes can spawn subprocesses. What is your rational for declaring it &qu
333.
by michelpp 8y ago
The State of Oregon tried to claim copyright on state law: https://www.washingtontimes.com/news/2008/apr/19/oregon-clai... but they decided "not to enforce any" after word got out: https:&#x2F
334.
by michelpp 8y ago
sounds like a pretty cool idea!
335.
by michelpp 8y ago
Here are are a couple good introductions to semirings: https://www.youtube.com/watch?v=Gd_VT_Nj8Xw https://www.youtube.com/watch?v=dluPFbuq6zs Dr. Jeremy Kepner's paper is a good follow up read after t
336.
by michelpp 8y ago
Ah you're right, i got them confused in my memory. I did not write nancy so i'm not entirely familiar with it's guts, but found it VERY useful for replaying workloads while messing with indexes to find the best performance.
337.
by michelpp 8y ago
> When faced with a technical problem it’s often better to use an existing tool than jump into writing one yourself. Having benchmarked Postgres clusters before, I was already familiar with a tool called pgreplay that I thought could do
338.
by michelpp 8y ago
Thank for the context, this is great! I'm looking into this now to see if I can use it with my project pggraphblas, i was hoping to make an FDW where each column is backed by a matrix, making essentially a "property graph" t
339.
by michelpp 8y ago
> I think the GP is saying it's low level in the frame of reference of the data and relationships, which is true because you have to explicitly join everything together 'by hand' even though you could imagine abstractions
340.
by michelpp 8y ago
Encapsulate your joins in a view: https://www.postgresql.org/docs/current/sql-createview.html
341.
When a vulnerability is not a vulnerability(blog.hagander.net)
3 points by michelpp 8y ago|0 comments
342.
by michelpp 8y ago
pandas.read_sql('select first_name, last_name, email from users', conn) this approach avoids the full data copy calling '.all()' materializes.
343.
by michelpp 8y ago
A great book on this idea is "Human Behavior and the Principle of Least Effort" by George Kingsley Zipf. "The entire behavior of an individual is at all times motivated by the urge to minimize effort" -Zipf
344.
by michelpp 8y ago
That's not equivalent. All 737 MAXs have the failed design. Instead it's like all cars like yours have their stock automated emergency braking system malfunction, didn't illuminate the "check engine" light (that&#x
345.
by michelpp 8y ago
There is an interesting tool called nancy that runs automated experiments with different postgres setups, allowing you to compare them against each other. It can run workloads derived from log files or pgbench (disclaimer, I wrote the pgbe
346.
by michelpp 8y ago
The * operator can be overloaded, and it is already done s so for the mxm, mxv and vxm combinations. The catch is, all these AxB functions have more arguments than just their operands (mask, accumulator, semiring, descriptors). So you can
347.
by michelpp 8y ago
Matrices are constructed from arrays of rows, columns, and values. The simplest way to pivot a table into a matrix is to use array_agg() select matrix(array_agg(row), array_agg(col), array_agg(val))) from table; For the inverse oper
348.
by michelpp 8y ago
Good idea! Hopefully I can put something together.
349.
by michelpp 8y ago
There is work being done by a standards committee on a common high level Cypher like language: https://www.gqlstandards.org Long term that's maybe a promising target. That's out of scope of pggraphblas now, but like R
350.
by michelpp 8y ago
Yes, I have only reviewed ComBLAS's documentation, but would eventually like to dig into it deeper. A thought I had for distributed graphs would be something like support on top of a distributed store like citus, where shards hold sub
351.
Show HN: Graph Processing with Postgres and GraphBLAS(github.com)
106 points by michelpp 8y ago|12 comments
352.
by michelpp 8y ago
You nailed it. Anyone who thinks they're out in front of this industry just because they believe with all their heart their abstract word-salad mission statement belongs to a cult.
353.
by michelpp 8y ago
It's true. I look forward to seeing more language bindings, like Python, Javascript, etc. I expect it will be soon. For my own GraphBLAS education I have been working on a PostgreSQL extension: https://github.com/mich
354.
by michelpp 8y ago
There is an API formalizing this style of matrix/graph computation called GraphBLAS, coming soon to a language and database near you. Here is an easy to read but math focused introduction to the topic by Dr Jeremy Kepner Head and Found
355.
by michelpp 8y ago
There is also GPU support for PostgreSQL using an extension called pg-strom https://github.com/heterodb/pg-strom Not sure how it compares to this tool, but it uses a GPU to do both high density analytics, by loading da
356.
by michelpp 8y ago
I've tried Hasura and really liked it, but there were a few quirks that led me to another tool, but in general, the whole idea that tools like Hasura, PostgREST, pREST and PostGraphile are trying to solve are the future. Server side fr
357.
by michelpp 8y ago
Xapian has a long history starting in the early 80s: https://xapian.org/history I've used Xapian extensively, but not this new Xapiand tool, so I can only speak to the actual library. Xapian is a C++ library that acce
358.
by michelpp 8y ago
Views are the abstraction layer: https://www.postgresql.org/docs/current/tutorial-views.html Your application layer "security system" is just row level security done outside the db.
359.
by michelpp 8y ago
Traditional web frameworks typically have far higher security risks, for example, Django executes all queries as the same superuser . Once someone cracks your django, the database is toast. With an RLS based system like both PostgREST
360.
by michelpp 8y ago
Postgraphile is fantastic, in particular the function/row binding stuff that any python programmer would instantly recognize as implicit first argument self binding. We create graphql apis in minutes with it. No rolls, no restarts.

More ›