Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
johnthescott
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
7 ms
·
61.
▲
by
johnthescott
1y ago
in the example plain posix code seems more clear than modernish.
62.
▲
by
johnthescott
1y ago
code-map.com timing out. appears to be a nice start, from video. does code-map requires license from major model provider? also, is code-map open source? how are new languages added?
63.
▲
by
johnthescott
1y ago
In PostgreSQL i tend to use NATURAL JOINs in the FROM clause to whittle down the distracting joins in the more relavent WHERE clause.
64.
▲
by
johnthescott
1y ago
old problem. in postgresql many ways already exist to keep deleted data hanging around, not the least of which is explicity archiving the delete transaction in an archive table. for legacy code that can not be changed: triggers, row level
65.
▲
by
johnthescott
2y ago
for text search we use the "rum" extension from postgrespro. search terabytes of pdfs < 1sec. a talk here https://github.com/jmscott/talk/blob/master/pgday-austin-20161112.pdf
66.
▲
by
johnthescott
2y ago
amen. get the schema correct and the gui will follow.
67.
▲
by
johnthescott
2y ago
cool. an interactive version of the knights and knaves book by ray Smullyan would be cool, as well. nice work.
68.
▲
by
johnthescott
2y ago
a surprising number of academic pdfs do not have the Title element set in the dictionary. seems like a jobs for "ai".
69.
▲
by
johnthescott
2y ago
brilliant. you have created a genre.
70.
▲
by
johnthescott
2y ago
why not start by analyzing the entire arxiv paper from the url. the image cut-n-paste is confusing.
71.
▲
by
johnthescott
2y ago
why would the whole site be taken offline?
72.
▲
by
johnthescott
2y ago
i have cooked for years with ratchet mill.
73.
▲
by
johnthescott
2y ago
brings back memories. my first exposure to unix was coherent and 4bsd. fond memories studying the source.
74.
▲
by
johnthescott
2y ago
> SQL is the FORTRAN of relational programming languages and what is an alternative to sql ... quel?
75.
▲
by
johnthescott
2y ago
in postgresql syntax for data types is stored in the database. how would this tool parse gis expressions, for example?
76.
▲
by
johnthescott
2y ago
i assume this go code runs in the client since pg does not support golang server side. why would a client side ordering be faster than doing in the database?
77.
▲
by
johnthescott
2y ago
recently i was asked to read RFR. Alinsky writes well.
78.
▲
by
johnthescott
2y ago
Lives of a Cell, Lewis Thomas.
79.
▲
by
johnthescott
2y ago
hmm ... postgresql extension?
80.
▲
by
johnthescott
2y ago
my bs detector smells a non-elephant animal.
81.
▲
by
johnthescott
2y ago
my father was born and raised in river oaks, houston before ac. summers were hellish, with little sleep at night.
82.
▲
by
johnthescott
2y ago
xslt failed due to an international shortage of greater-less than characters. apologies to SKB.
83.
▲
by
johnthescott
2y ago
back in the day, long before linux/gnu existed, i learned quite a bit on the unix philosophy from "The Unix Programming Environment" by Rob Pike and Brian Kernighan.
84.
▲
by
johnthescott
2y ago
i met waits briefly in a bar in occidental california during late 1990s. he was behind the piano, playing away. looked healthier than i expected.
85.
▲
by
johnthescott
2y ago
entropy of a bit string may be another way to view the bitwise derivative. paper here for analyzing primes: https://arxiv.org/abs/1305.0954 [BiEntropy - The Approximate Entropy of a Finite Binary String]
86.
▲
by
johnthescott
2y ago
> so I wouldn't count on it surviving intact. why?
87.
▲
by
johnthescott
2y ago
could you elaborate? i was under the impression the text search config and dictionaries did support such remappings. we only query in english or literal, so my knowledge is limited.
88.
▲
by
johnthescott
2y ago
"who was and wasn't involved" pretty big set of folks.
89.
▲
by
johnthescott
2y ago
a significant number of hospitals in usa do use american messaging, everyday: https://americanmessaging.net/
90.
▲
by
johnthescott
2y ago
aes128 pagers are the most secure side-channel on the planet. also a kept secret in telcoms. add payload addressing per message and you can speak oneway to an unbounded number of pagers/devices, for only a few bucks a month. try doin
More ›