fforflo

10 ms·

91.
by fforflo 2y ago
Yes, you're right. I felt the gif wasn't polished but was too lazy to re-run. I removed it for now. Simplified the README a bit too. Hope is better now. Thanks!
92.
Show HN: Tsellm: Interactive SQLite shell with LLM support(github.com)
8 points by fforflo 2y ago|3 comments
93.
by fforflo 2y ago
Well it's not:D Sure there are 4-5 fundamental classes in python libs but they're just fundamental ones. They don't impose an OOP approach all the way. What you're alluding to is people coming from Java to Python in 201
94.
by fforflo 2y ago
OOP is Java, and Java is OOP, right? My point is to follow a dogmatic OOP approach (think all the nouns like Agent, Prompt, etc.) to model something rather sequential.
95.
by fforflo 2y ago
I'll bite: "More artists than engineers": yes and no. I've been working with Pandas and Scikit-learn since 2012, and I haven't even put any "LLM/AI" keywords on my LinkedIn/CV, although I'v
96.
by fforflo 2y ago
Ah didn't know that. IIRC I first heard this analogy with regards to Java Spring framework, which had the "longest java class name" somewhere in its JavaDocs. It should have been something like 150+ chars long. You know... Ab
97.
by fforflo 2y ago
LLM frameworks like LangChain are causing a java-fication or Python . Do you want a banana? You should first create the universe and the jungle and use dependency injection to provide every tree one at a time, then create the monkey that wi
98.
by fforflo 2y ago
It's a library written by some devs who thought it might be useful to others, too, and/or are proud enough to share their work. It's not that they'll publish it in an SEC filing. For every n-th solution in the market, n-
99.
by fforflo 2y ago
if you want complex subcommands and a truly fluent CLI interface, go with a click. https://click.palletsprojects.com/ else: argparse is more than enough https://docs.python.org/3/library/argparse.h
100.
by fforflo 2y ago
My favorite and probably most useful? `python3 -m venv ./venv` Honestly, forget about conda, poetry, virtualenvwrapper etc and just use that one.
101.
by fforflo 2y ago
I don't share the "oh my, why bash, why not English then?" sentiment in the comments. I've done a bunch of DSLs (CLI with some elaborate syntax really) that compile to bash as a target. It just works for me. Bash is alwa
102.
by fforflo 2y ago
I had done a SQL-like ->Bash "language," and the reason was that I wanted to have access to CLI tools as-is, in my case, curl programs. Had I chosen Python as a target, I'd have to use requests/urllib, which would be
103.
by fforflo 2y ago
I agree with your points, but as a side note, I've noticed that French companies have never been too excited about offshoring and remote work in particular. I've been freelancing remote/hybrid in Europe for years now, and on
104.
Exploring Stock Correlations in Postgres(github.com)
1 points by fforflo 2y ago|0 comments
105.
by fforflo 2y ago
Exactly. Especially around UPDATE [0] and MERGE [1]. A lot of "data engineering" complexity and data pipelines are necessary because of the lack of more-than-superficial knowledge of SQL. Inexperienced developers talk about DAGs o
106.
by fforflo 2y ago
A different approach to backups is an important aspect here. Also, writing-heavy things can get trickier with concurrency and locks. BLOBs usually have a more archive nature. In a scenario where I had a 5-10MB pdf document (BLOB) for each
107.
by fforflo 2y ago
I guess you're referring to this ? https://github.com/aspiers/stow/issues/65
108.
by fforflo 2y ago
> There’s so many projects that just seem to call out to the OpenAI api even though they say something silly like “99% local.” That used to be the case for lots of business-facing products that wanted to capitalize on the hype quickly a
109.
by fforflo 2y ago
It's the other way around actually: standard jq but with AI capabilities.
110.
by fforflo 2y ago
Not all LLM models are remote. You can do just fine with local ones.
111.
by fforflo 2y ago
Yes, that's extremely important. I've had great success, but replacing Airflow, Luigi, and friends with a cron-ed Makefile target refreshing some database tables (usually Materialized views). I've then used this tool to visua
112.
by fforflo 2y ago
That's an ongoing discussion in the Postgres community [0], primarily because Postgres is 100% written in C. As for the future, I don't know. Not many companies can maintain full forks. I've noticed, however, from my professi
113.
by fforflo 2y ago
Development-wise they're completely different. Extensions are much easier / more isolated. Developing a pg extension is all about compiling some C code into a .so object and dynamically using a templated Makefile to load it into
114.
by fforflo 2y ago
That's what happens when you're freed from "SEO-optimized content". It's also a culture thing I'd probably put under military philosophy. I've worked with ex-military engineers, and you can tell from how t
115.
by fforflo 2y ago
Unix-inspired so it's entirely text oriented.
116.
by fforflo 2y ago
I'm working on a small Unix-inspired DSL for LLM pipelines.
117.
The PostgreSQL community debates ALTER SYSTEM(lwn.net)
160 points by fforflo 2y ago|82 comments
118.
by fforflo 2y ago
Unfortunately, EU research money nowadays is free money for private companies. How this works: a 3-year research project with a consortium of academia+industry of 2-3 universities (1M/each) and 4-5 private companies(50k-200k). With thi
119.
by fforflo 2y ago
Not really. In this context they're a hint to the optimizer to evaluate the CTE result store=materialize it somewhere and use that snapshot when the CTE is queried subsequently. The alternative means the CTE is copy-pasted essentially
120.
by fforflo 2y ago
Do they list Sora as a potential competitor?

More ›