fforflo

12 ms·

61.
PgPDF: Pdf Type and Functions for Postgres(github.com)
97 points by fforflo 2y ago|55 comments
62.
Show HN: pgQR: Postgres Extension to Generate QR Codes(github.com)
1 points by fforflo 2y ago|0 comments
63.
by fforflo 2y ago
Whenever I find myself needing /tmp, it's usually as a form of IPC shared memory, in which case I use /dev/shm directly.
64.
by fforflo 2y ago
I have a couple of read-heavy >2TB Postgres instances, document-oriented too. You're right that bulk updates can be too slow. Too many times I end up doing the updates incremental (in batches) or even use COPY.
65.
by fforflo 2y ago
Yeah, I've been keeping an eye on the pgsql-hackers discussions. Alexander+team are doing great work.
66.
by fforflo 2y ago
OrioleDB was supposed to tackle this problem with a new storage engine . https://github.com/orioledb/orioledb
67.
Full Text Search on PDFs with Postgres(tselai.com)
1 points by fforflo 2y ago|0 comments
68.
by fforflo 2y ago
I'll write a follow up about this, But the tl;dr is that you'll have to use more generous params when running the model. There's also the problem of input data quality which isn't really great
69.
by fforflo 2y ago
I can see myself using this as alternative to foreign data wrappers and/or pg_dump even.
70.
by fforflo 2y ago
Well, we know we'll have reached AGI when LLM says "this chat has been marked as duplicate"
71.
by fforflo 2y ago
Of course.
72.
by fforflo 2y ago
Metoo kind of... Write right-handed, fork on the right, but knife on the left. Throw with the left hand, kick with the left. Mouse on the right. Also wished the gas pedal was on the left :D
73.
by fforflo 2y ago
Looked nice so I automatically did git clone && cd postgres_dba && make all install installcheck... and failed :D Creatures of habit... any plans to make this an extension?
74.
by fforflo 2y ago
I guess you mean the .gguf examples, not Llamafile, right? What command did you use? Maybe you're using an old llama.cpp ?
75.
by fforflo 2y ago
Paraphrasing Spencer: Those who don't understand SQL are doomed to reinvent it, poorly
76.
by fforflo 2y ago
For starters, I didn't choose the name, but rather those who trained it. Second, what's the point of training lang-specific LLMs and giving it a name using a word nobody uses in practice? Unless you want to make it sound more huma
77.
by fforflo 2y ago
I love the idea of pushing JQ and other DSLs close to the database. I've written jq extensions for SQLite [0] and Postgres [1], but my approach involves basically embedding=pushing the jq compiler into the db. So you can do `select jq(
78.
Llamafile for Meltemi: The First LLM for Greek(tselai.com)
48 points by fforflo 2y ago|22 comments
79.
by fforflo 2y ago
Something I don't see being mentioned in the comments: What's a really frustrating part of working with the C API? Setting up the compile/link flags! The python3-config works generally well but is only available at the OS le
80.
Show HN: PgPDF: Postgres extension to read PDFs(github.com)
3 points by fforflo 2y ago|0 comments
81.
by fforflo 2y ago
What is the go-to place to browse/find catalogued satellite image data?
82.
by fforflo 2y ago
While we're here: what happened to the GitHub explore newsletter? I really enjoyed this, but I've stopped receiving it for a few months now. And I don't think I unsubscribed.
83.
by fforflo 2y ago
The C extensions API is a big big very big thing. As someone who routinely write small PG extensions, I'd love to be able to kinda use the same code for multiple backend DBs. And I guess lots of inspiration has come from all the effort
84.
Show HN: Jsonb_apply: apply functions to Postgres JSON, like it's Lisp(github.com)
3 points by fforflo 2y ago|0 comments
85.
by fforflo 2y ago
Ah, was planning to post this as a Show HN in a few days (marketing material needs some polishing) but lmk if anyone tried installing/using this and is having trouble.
86.
by fforflo 2y ago
I did some mentorships there (as a mentor) a few years back. My experience was "meh." Most of the mentees were last-minute students looking for help with their assignments. But their SEO must be excellent. I still get web traffic
87.
by fforflo 2y ago
ChatGPT says The documentary he's referring to is likely "Farewell, Etaoin Shrdlu," released in 1980. It chronicles the last day of hot metal typesetting at The New York Times before they transitioned to newer technology.
88.
Limits to running speed in dogs, horses and human(journals.biologists.com)
67 points by fforflo 2y ago|62 comments
89.
by fforflo 2y ago
I'd suggest bringing more code snippets from the test cases to documentation as examples. Nice work though.
90.
by fforflo 2y ago
I got a feeling that this may be a cultural aspect there too: Backgammon is not considered "sophisticated," I think. I'm from Greece (I don't play backgammon myself, though), and backgammon (tavli) is extremely popular

More ›