fforflo

7 ms·

31.
by fforflo 2y ago
Here's a small patch that addresses a very common question in Postgres: "How do I remove nulls from a jsonb array?"
32.
by fforflo 2y ago
Of course, there are, but I guess this relies on the various System views (pg_*), like most monitoring tools, which have fine-grained control access if you create appropriate roles.
33.
Constraint Programming in Action: Optimizing Postgres Index Selection(pganalyze.com)
2 points by fforflo 2y ago|0 comments
34.
Waiting for PostgreSQL 18 – Virtual generated columns(depesz.com)
3 points by fforflo 2y ago|1 comments
35.
by fforflo 2y ago
Apart from the usual advice to "start working on a patch to learn the internals," which is not as easy to do because it's a mature product and most of the low-hanging fruits have been reaped, I'd also suggest checking th
36.
by fforflo 2y ago
Parent probably means that email clients don't send the attachments (patches) with the appropriate content type (i.e. text/x-patch or text/x-diff) but use application/octet-stream.
37.
by fforflo 2y ago
Does converting to HTML first and then to PDF help?
38.
EDB Says It Tops Oracle, Other Databases in Benchmarks(bigdatawire.com)
1 points by fforflo 2y ago|0 comments
39.
by fforflo 2y ago
I'm all for such an approach, but I also like Firebolt's approach with Lambda functions focusing on arrays. [0] [0] https://www.firebolt.io/blog/sql-thinking-in-lambdas
40.
The big fat Greek plot to defraud the EU(politico.eu)
2 points by fforflo 2y ago|1 comments
41.
by fforflo 2y ago
That's not that easy to enforce in a system like Postgres. If you ship something you have to stay with it for many years. Thus, all possible angles have to be taken into consideration.
42.
by fforflo 2y ago
In the EU, we need some social contracts for those things. Multiple EU-funded projects are launched, consortiums between Unis and Private sector companies are created, deliverables are delivered, and grants are allocated, but the cumulative
43.
by fforflo 2y ago
pgxicor is a Postgres extension that exposes a SELECT xicor(X, Y) aggregate function. XI can detect functional relationships between X and Y. You can use it as a more powerful alternative to standard corr(X, Y) which works best on linear re
44.
Xi (ξ) Correlation Coefficient in Postgres(github.com)
1 points by fforflo 2y ago|1 comments
45.
by fforflo 2y ago
Another Albanian thing worth mentioning is an extensive list of oil wells dispersed across residential areas see [0]. Family legend has it that my father almost drowned in one [1] when he was a kid, and a relative had to pull him by his nos
46.
by fforflo 2y ago
Shameless plug (who would have thought): I've played hide and seek in Albania and used a bunker as a hideout. AMA :D That's one of the few experiences I remember when I was 3-5yo.
47.
AI Tech at Europe's Borders Threatens People Seeking Refuge(wearesolomon.com)
1 points by fforflo 2y ago|0 comments
48.
Accurate predictions on small data with a tabular foundation model(nature.com)
2 points by fforflo 2y ago|0 comments
49.
by fforflo 2y ago
I've been working on something Redis-y over the holidays, and it has reinforced my view that it's the epitome of a 20%- 80% tool. I've always used the 20%, but anything beyond that sounds useless unless you've encounter
50.
by fforflo 2y ago
People living in central/western Europe: You have no idea how fortunate you are to be able to hop on a train and ride to another major city in a few hours. We mortals of the southeastern Europe feel detached from the rest of the world.
51.
Show HN: Pure C Implementation of the Chatarjee – Xi Correlation Coefficient(github.com)
2 points by fforflo 2y ago|0 comments
52.
Show HN: Maximal Information Coefficient (Mic) Extension for Postgres(github.com)
2 points by fforflo 2y ago|0 comments
53.
by fforflo 2y ago
Congrats on your PhD at Stanford, but some humility has to be part of the scientific process for sure. It looks like a lot of folks called "programmers" agree with the points in the post. If it's such a common experience that
54.
Hash tables in ClickHouse and C++ Zero-cost Abstractions(clickhouse.com)
3 points by fforflo 2y ago|0 comments
55.
by fforflo 2y ago
Haha,that, or it's a validation of the blowup.
56.
by fforflo 2y ago
Plug: Now that you know how they work, you can use them in your SQL queries too https://github.com/Florents-Tselai/pgQR
57.
by fforflo 2y ago
Good catch, the whole PDF parsing ecosystem is kinda grey on those things. I tried to be extra-careful and I relied on poppler's official statement: "Note that Poppler is licensed under the GPL, not the LGPL, so programs which cal
58.
by fforflo 2y ago
I'm missing something I think. Currently the `pdf` type is indeed a blob of bytes. Read from disk, but not parsed. The type is created with storage=extended to avoid the typical 8KB tuple size limit. In practice though, a PDF for mos
59.
by fforflo 2y ago
Interesting: I posted this a few days back, and certainly not "10 hours ago". Who was kind enough to re-surface this? Thanks :) Some clarifications on a few comments I see downstream: The motivating example was to easily support F
60.
by fforflo 2y ago
The first iteration of this was actually FTS only https://tselai.com/full-text-search-pdf-postgres In the second pass I made `pdf` a type.

More ›