fforflo

11 ms·

121.
by fforflo 2y ago
I have zero ties to the industry. Am I right to assume there's a lot of DoD-driven echo chamber? Material being produced for the big clients and contracts ?
122.
by fforflo 2y ago
What's the best way/resource to get an honest/pragmatic view of where things stand with the "robots market" in general and how much and fast things are really progressing? I remember seeing prototypes from Toshiba w
123.
Setup.py and Makefile: A just good enough build tool(tselai.com)
3 points by fforflo 2y ago|0 comments
124.
by fforflo 2y ago
The convenient thing about this is that it's written in vanilla Pl/PgSQL. It can be tempting to copy the `index_advisor(text)`function in a session and start hard-coding stuff and heuristics :D . Most meaningful extensions need to
125.
by fforflo 2y ago
I just returned from our daily walk around the streets the article mentioned and opened HN. > Beneath the seductive surface of the present... Unfortunately, this surface has become less and less seductive, and history is being buried dee
126.
by fforflo 2y ago
Actually I knew that and I did spot the hallucination, but I was fine with it as long as it answered the core of the question.
127.
by fforflo 2y ago
20 mins video for this? The battle for attention has reached new levels (and I pay YouTube premium) I asked ChatGPT: - Why doesn't Facebook use git? In 5 lines - Facebook doesn't use Git primarily because of the scale of their cod
128.
by fforflo 2y ago
Scripts get complicated when people start worrying about "portability," like we were in 1991 so we have to use "sh". It's 2024 and you're not developing the next vim or Postgres. Use bash.
129.
by fforflo 2y ago
For those unfamiliar, MIC measures the strength of the linear or non-linear association between two variables. One can brute-force between every pair of course. You can run a `select mic(col1, col2) from my_table` between any arbitrary pair
130.
Postgres Extension to Calculate the Maximal Information Coefficient (MIC)(github.com)
1 points by fforflo 2y ago|1 comments
131.
by fforflo 2y ago
People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean . It's a worthy effort.
132.
by fforflo 3y ago
pgrx has indeed been a turning point; hadn't noticed it went under a new roof though. The community owns a lot to the ZomboDB people.
133.
by fforflo 3y ago
I'm not sure what regulated means (eventual consensus?), but I think *from inside the Postgres toolchain* is important. For context, there are a few efforts in progress. I'm sure there are more. - https://pgxman.com -
134.
by fforflo 3y ago
I've been writing Postgres extensions for a few years now (mostly in C and Python), and I have to say that an important contribution from companies like Tembo and Omnigres is in the area of tooling and boilerplate. From workflows to Do
135.
Show HN: PgJQ: Use Jq in Postgres(github.com)
39 points by fforflo 3y ago|0 comments
136.
by fforflo 3y ago
I'm not so sure about having bin/lib in the project dir. I've found it more helpful to have a PREFIX=$(pwd)/build or even PREFIX=$HOME/.local as an installation destination. And have a .env add PATH=$PREFIX/bin
137.
by fforflo 3y ago
I'm not so sure with having bin/lib in the project dir. I've found it more helpful to have a PREFIX=$(pwd)/build or even PREFIX=$HOME/.local as an installation destination. And have a .env add PATH=$PREFIX/bin:
138.
Wes McKinney – Leveling Up the Data Stack: Thoughts on the Last 15 Years(youtube.com)
2 points by fforflo 3y ago|0 comments
139.
by fforflo 3y ago
Google and Meta auth, both down at the same time? Oooh. Conspiracy theories (or not) incoming...
140.
liteJq: Bringing Jq to SQLite for More Powerful Analytics(tselai.com)
2 points by fforflo 3y ago|0 comments
141.
by fforflo 3y ago
Any input passed to jq(text,text) is directly passed through to jq's internal compiler, so it's a job left for that. Now, can jq be used for SQL injection in an SQLite context? That's interesting in theory, but I'd assum
142.
by fforflo 3y ago
Yes, they are. Beyond the core database offering, I'd also like to underline the quality of their software engineering work. There are not many Python-powered databases out there; their codebase has some real gems from the setup.py to
143.
by fforflo 3y ago
Nice work. A few months back, I experimented with having a DSL like PRQL in Postgres, but back then, I found the language a bit cumbersome; however, it was great as an idea. IMHO, the best "data transformation" language is jq and
144.
Variables in psql, how to use them?(depesz.com)
2 points by fforflo 3y ago|0 comments
145.
by fforflo 3y ago
I just came here to post that. I'd like to know if others have setup pipelines using pgcopydb. From the looks of it, I'm a bit surprised it's not more popular in the PG universe.
146.
Show HN: Cookiecutter for Postgres Extensions(github.com)
1 points by fforflo 3y ago|0 comments
147.
by fforflo 3y ago
Pandoc is a great cli tool in terms of its UI and code quality. An interesting fact is that its creator is John MacFarlane, a Philosopher [0] https://en.m.wikipedia.org/wiki/John_MacFarlane_(philosopher...
148.
by fforflo 3y ago
> - Why not use SQLite? https://github.com/Florents-Tselai/WarcDB
149.
Sputnik Launched an Era of Technological Fragility(theatlantic.com)
2 points by fforflo 3y ago|0 comments
150.
We Need More DSLs in the Database(tselai.com)
1 points by fforflo 3y ago|0 comments

More ›