remywang

9 ms·

91.
Tell HN: Get a dying iPhone 12 mini in 2026
28 points by remywang 10mo ago|25 comments
92.
by remywang 10mo ago
Not to be confused with SQLite studio, which is open source and actively maintained for nearly 20 years https://sqlitestudio.pl/
93.
by remywang 10mo ago
“Made by a single developer” is only a selling point if it is someone with a strong track record to maintain the software, otherwise it’s just saying the bus factor is 1.
94.
Pragmatic Bitmap Filters in Microsoft SQL Server [pdf](vldb.org)
3 points by remywang 10mo ago|1 comments
95.
by remywang 10mo ago
From CIDR 2026: https://www.vldb.org/cidrdb/2026/index.html
96.
TreeTracker Join: Simple, Optimal, Fast(dl.acm.org)
2 points by remywang 10mo ago|0 comments
97.
Show HN: Browser in C and Lua for the Playdate Console(github.com)
1 points by remywang 10mo ago|0 comments
98.
How to Improve a Perfect Join Algorithm(remy.wang)
12 points by remywang 10mo ago|0 comments
99.
by remywang 10mo ago
Was hoping for a self aware roast: one weird trick to keep sending your LLM slop to top of HN (/s, I enjoyed it very much)
100.
A Perfect Join Algorithm(remy.wang)
1 points by remywang 10mo ago|0 comments
101.
by remywang 11mo ago
A bidirectional formula is also known as an integrity constraint in databases (plus some triggers for restoring the constraint upon updates)!
102.
by remywang 11mo ago
I also made some fonts for playdate based on unifont: https://github.com/remysucre/cuniform
103.
GNU Unifont(unifoundry.com)
347 points by remywang 11mo ago|79 comments
104.
Show HN: md0 - Simple Markdown Subset(md0.fyi)
2 points by remywang 11mo ago|1 comments
105.
by remywang 11mo ago
I needed some format that's easy to parse and render for an embedded browser, so I pulled out a very simple subset of markdown's syntax. As soon as it's done I realized I just wrote a spec for HN comments :) If you know the [
106.
Show HN: Read Kagi News on Playdate(github.com)
20 points by remywang 1y ago|0 comments
107.
by remywang 2y ago
> the word UNKNOWN itself isn't used in SQL That leads to an even more confusing point, that some systems (at least SQLite) overloads NULL to mean UNKNOWN, for example `SELECT 1 WHERE NULL = (NULL = NULL)`. And the dangerous thing a
108.
by remywang 2y ago
Except that NULL is not the same as UNKNOWN! NULL is a data value (like integers) that can appear in data expressions (like NULL + 1) and comparisons (like NULL = 1) whereas UNKNOWN is a truth value that can appear in boolean/logical
109.
by remywang 2y ago
This is fantastic! I’ve been looking for something like this to take on my runs forever, as I hate bringing my phone while running. Also for people who want to replace their phone with a smartwatch, the only thing missing is this.
110.
SQL Reunion: People, Projects, and Politics (1997) [pdf](mcjones.org)
2 points by remywang 3y ago|0 comments
111.
Ask HN: Who's writing recursive queries / Datalog?
8 points by remywang 3y ago|1 comments
112.
The Entropic Framework for Cardinality Bounds(remy.wang)
1 points by remywang 3y ago|0 comments
113.
by remywang 3y ago
grading homework
114.
by remywang 3y ago
My guess is that t1 = t2 seems cheap but is actually expensive, so you might accidentally write very slow queries if it were built into the language.
115.
by remywang 3y ago
Author here! This was mostly intended for entertainment, and partly to demonstrate the idea of "relations as vectors" and "queries as polynomials". But I guess I'll indulge myself a bit more: > Just use sqldiff s
116.
How to check if two SQL tables are the same(github.com)
272 points by remywang 3y ago|120 comments
117.
Filter every mail: a cure for email addiction(github.com)
1 points by remywang 3y ago|0 comments