Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
polyrand
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
151.
▲
by
polyrand
3y ago
Hi! Author here. I've looked into pydoit multiple times and I would love to try it. There are a few reasons that make me go back to make (no pun intended!). * It comes pre-installed on most UNIX operating systems. Yes, macOS ships an o
152.
▲
Correlated Subqueries in SQL
(duckdb.org)
5 points
by
polyrand
3y ago
|
1 comments
153.
▲
by
polyrand
3y ago
I was tinkering with a similar approach to this, using Python objects to generate the YAML. I'm not working in it right now, but I'd love to see other tools use this approach.
154.
▲
Named parameters in shell scripts and Makefiles
(ricardoanderegg.com)
1 points
by
polyrand
3y ago
|
0 comments
155.
▲
Makefile Tricks for Python Projects
(ricardoanderegg.com)
3 points
by
polyrand
3y ago
|
0 comments
156.
▲
by
polyrand
3y ago
Another cool new feature that's not mentioned in the blog post is function chaining: https://github.com/duckdb/duckdb/pull/6725 I've been using DuckDB for filtering and post-processing data, special
157.
▲
The Mojo Programming Language
(docs.modular.com)
2 points
by
polyrand
3y ago
|
0 comments
158.
▲
by
polyrand
3y ago
I have mixed feelings about using stored procedures and triggers. I was once working on a Postgres app and started storing some logic in the DB. I had some triggers that would automatically set values when a user state changed (e.g: when th
159.
▲
We Built Rill with DuckDB
(rilldata.com)
16 points
by
polyrand
3y ago
|
0 comments
160.
▲
Using SQLite for Rate Limiting
(summarity.com)
3 points
by
polyrand
3y ago
|
0 comments
161.
▲
by
polyrand
3y ago
wal2 mode is not part of the main development branch of SQLite, you need to compile SQLite yourself from that branch. Same with BEGIN CONCURRENT [0] [0]: https://www.sqlite.org/src/doc/begin-concurrent/doc
162.
▲
by
polyrand
3y ago
This sounds cool! I would be happy to read a blog post about it if you ever write one.
163.
▲
by
polyrand
3y ago
I've been thinking about using BM25 as a retrieval method to enhance LLMs, I'm happy to see it mentioned here. It can complement vector search, but if it turns out to be useful on its own (maybe with query expansion and other tric
164.
▲
Designing a programming language to speedrun Advent of Code
(blog.vero.site)
4 points
by
polyrand
3y ago
|
0 comments
165.
▲
by
polyrand
3y ago
SQLite is missing some features like `SELECT FOR UPDATE`, but you can work around some issues with a few extra queries. I wrote litequeue[0] with this specific purpose. I haven't been able to use it a lot, so I don't have real-wor
166.
▲
Online gradient descent with SQL
(jordivillar.com)
4 points
by
polyrand
3y ago
|
0 comments
167.
▲
by
polyrand
4y ago
PEP 684 is now accepted [0]. Once the Python stdlib includes a module to start a new interpreter (without having to use the C API), it could open the door to some cool stuff. [0]: https://twitter.com/ericsnowcrntly/stat
168.
▲
Python: A Per-Interpreter GIL
(peps.python.org)
2 points
by
polyrand
4y ago
|
1 comments
169.
▲
Reflections on 10k Hours of DevOps
(matt-rickard.com)
84 points
by
polyrand
4y ago
|
42 comments
170.
▲
Tonic: Lightweight Wrapper for Web Components
(tonicframework.dev)
1 points
by
polyrand
4y ago
|
0 comments
171.
▲
A library for creating SQLite indexes at breakneck speeds
(github.com)
5 points
by
polyrand
4y ago
|
0 comments
172.
▲
by
polyrand
4y ago
Hey! I remember reading your blog post a few months ago, and it inspired me to try to create a CMS using Apple Notes + the IMAP syncing features[0]. But everything felt like a hack all the time. Many features are not supported when syncing
173.
▲
by
polyrand
4y ago
Yes, the IMAP sync protocol was one of my discoveries when trying to turn Apple Notes into a CMS[0]. But like you said, many features are missing. I could do without the collaboration features, but I found that tables didn't work eithe
174.
▲
by
polyrand
4y ago
Commit fixing the bug: https://github.com/redis/redis-py/commit/66a4d6b2a493dd3a20c...
175.
▲
Now You Have Three Problems
(github.com)
2 points
by
polyrand
4y ago
|
0 comments
176.
▲
Using MMAP to share data between processes
(ricardoanderegg.com)
1 points
by
polyrand
4y ago
|
0 comments
177.
▲
Load LLaMA Models Instantly
(twitter.com)
208 points
by
polyrand
4y ago
|
55 comments
178.
▲
by
polyrand
4y ago
I completely agree with this. During the past few months I started writing a lot more, first in Apple Notes, then in Obsidian. I used to write some blog posts, but then I started writing down everything I learn, cool code snippets I come up
179.
▲
Using Apple Notes as a CMS
(ricardoanderegg.com)
3 points
by
polyrand
4y ago
|
2 comments
180.
▲
Using SQLite for logging and ad-hoc profiling
(ricardoanderegg.com)
1 points
by
polyrand
4y ago
|
0 comments
More ›