fforflo

16 ms·

151.
PgJQ: Use Jq in Postgres SQL(github.com)
8 points by fforflo 3y ago|1 comments
152.
by fforflo 3y ago
I recently ported some rather complex JQ programs to jsonb & jsonpath queries. After a while, it became too cumbersome, so I paused for a few days and developed this Postgres extension. pgJQ embeds the standard jq compiler and brings th
153.
Show HN: vasco: discover hidden correlations in your Postgres data(github.com)
1 points by fforflo 3y ago|0 comments
154.
When did Postgres become cool?(crunchydata.com)
232 points by fforflo 3y ago|177 comments
155.
Pg_fts_Greek: Postgres FTS Improvements for Greek(github.com)
1 points by fforflo 3y ago|0 comments
156.
Show HN: Diofanti.org Tracking government decisions in Greece(diofanti.org)
3 points by fforflo 3y ago|1 comments
157.
Show HN: Diofanti.org Tracking government decisions in Greece
2 points by fforflo 3y ago|1 comments
158.
PostgreSQL 14 Internals Book is Completed [pdf](edu.postgrespro.com)
2 points by fforflo 4y ago|0 comments
159.
A Greek Scandal Reverberates as Eavesdropping Expands in Europe(nytimes.com)
3 points by fforflo 4y ago|0 comments
160.
Europe’s last summer before the Russian winter(politico.eu)
6 points by fforflo 4y ago|3 comments
161.
by fforflo 4y ago
Then again, do you need virtual tables? The .warc structure won't change, so the tables won't change. But you can have SQL views defined instead for common queries.
162.
by fforflo 4y ago
Good point. Actually CommonCrawl provides Parquet files for their archives too. And there's this vtable for Parquet extension. https://github.com/cldellow/sqlite-parquet-vtable But for my use case virtual would b
163.
by fforflo 4y ago
> What is the advantage of moving around .sqlite-files, over just loading the (compressed) WARCs into sqlite databases when you need them? The .warc spec is ideal. I'm not saying we replace it (ref. xkcd: standards). On top of what
164.
by fforflo 4y ago
The web archiving community is surprisingly small and fragmented (in terms of tools) given its impact. Thankfully the .warc format looks pretty powerful and standard for the web we have so far (which is a lot! ). Now with the new protocols
165.
by fforflo 4y ago
I built this as a small utility within a larger project I'm working on these days. (contact me if you're curious or want to support). The WARC format is extremely simple and yet so powerful. Most importantly though, there are alre
166.
Show HN: WarcDB: Web crawl data as SQLite databases(github.com)
171 points by fforflo 4y ago|30 comments
167.
Russian Flag in Readme(github.com)
8 points by fforflo 5y ago|7 comments
168.
by fforflo 5y ago
This popped in my GitHub feed. There's an "awesome web-scraping" repo with ~5K stars. A few days ago the maintainer added the Russian flag at the top of README.md Someone raised this as an issue [0] "Just a suggestion, h
169.
by fforflo 5y ago
> PostgreSQL 14 with extensibility patches, can you elaborate on these patches? Have you worked on any parser-level hooks? I'm building an extension on PG, and have been trying to extend the parser without touching PG's tree, b
170.
What's Behind the N26 Exodus?(sifted.eu)
1 points by fforflo 5y ago|0 comments
171.
by fforflo 5y ago
A friend of mine who is actively involved in refugee issues posted this [1] on his FB profile. In the last month, more than 60 people have drowned in the Aegean Sea. Most of them during Christmas. The last week of December was tragic [2]. M
172.
by fforflo 5y ago
I live a 10' min walking distance from the museum the mechanism is displayed. Reading this makes me a bit ashamed for not spending hours just looking at it.
173.
by fforflo 5y ago
You're not being hurtful. :) I'll send you an email too, but because others are raising this: Good point and it's a potential trap of tools built from developers for developers. There's this fine line between finding it
174.
by fforflo 5y ago
Am I falling in love with the code? I'd say we're on the 2nd date .... I may even get lucky. But it's enough to make me hang up on recruiters (respectfully). Good point though. Bootstrapping is a viable option too, but fundr
175.
by fforflo 5y ago
Having recently worked for a hedge fund I noticed that too - although my idea predated that engagement . That's probably my first go-to market (if anyone has leads send me end email) . Hedge funds actually call this "alternative
176.
by fforflo 5y ago
I like these two questions! They can crystallise things. Wasn't aware of the Ticketmaster v. Tickets.com case. Will have to print it along the SCOTUS LinkedIn v. hiQ ruling.
177.
by fforflo 5y ago
> keeping the web truly machine readable. There's tremendous value in restoring some of it. :-)
178.
by fforflo 5y ago
Thanks a lot for your comment. You're exactly right on the tricky relationship between developers as internal ambassadors to businesses - customers. I think it somehow applies to almost any developer-facing tool. Your recommendation to
179.
Ask HN: Can web scraping be the basis of a viable business model?
171 points by fforflo 5y ago|111 comments
180.
Talking about the PostgreSQL Optimizer(rhaas.blogspot.com)
4 points by fforflo 5y ago|1 comments

More ›