hans_castorp

9 ms·

91.
by hans_castorp 3y ago
> I could see some users preferring Google Docs/Sheets/Slides over LibreOffice Google Doc always stores the files on the Google server, correct? In that case that is most likely an absolute show stopper for a German state auth
92.
by hans_castorp 3y ago
Fun fact: in Postgres, 'cat\n' matches 'cat$' when the so called "weird" newline matching is enabled :) https://www.postgresql.org/docs/current/functions-matching.h...
93.
by hans_castorp 3y ago
> Plans themselves suffer from this since they are in memory data structures not designed to be shared amongst different processes. Oracle uses a process-per-connection model as well (at least on Linux), and they are able to share execut
94.
by hans_castorp 3y ago
From the "Roadmap" section of the README: > more source dialects : mysql, mssql, sybase, etc. https://gitlab.com/dalibo/transqlate#roadmap
95.
by hans_castorp 3y ago
Not sure how drastic it was to be honest. Under Windows, multi-threading was always the only option. So in theory, they already had code for that.
96.
by hans_castorp 3y ago
> Some ancient design decisions have aged poorly, such as its one connection per process model Oracle uses the same model by default on Linux. Since 19 (or maybe earlier) it is configurable though, but the default is still one process pe
97.
by hans_castorp 3y ago
> I played with postgresql a while ago to implement search. It's not horrible. But it's nowhere near Elasticsearch in terms of its capabilities. The article is referring to the ParadeDB extension, not the built-in full text sea
98.
by hans_castorp 3y ago
d.m.y is used in several country across Europe (most certainly in Germany, Austria, Switzerland)
99.
by hans_castorp 3y ago
I wrote that comment on 14.03.2024 at 14:55:00
100.
by hans_castorp 3y ago
Today is 14.03. where I live....
101.
by hans_castorp 3y ago
Further down is an example using "minus (now (), toIntervalDay (1))" which is also non-standard SQL. I have no idea which DBMS they are targeting.
102.
by hans_castorp 3y ago
What target database is that in the examples? like ("email", 'gmail') minus (now (), toIntervalDay (1)) are non-standard functions/conditions
103.
by hans_castorp 3y ago
There is no download link, so how can this be self-hosted?
104.
by hans_castorp 3y ago
The PRQL extension discussed here is for Postgres, so my solution was Postgres specific. Since when is QUALIFY part of the SQL standard? So far I have only seen it as a proprietary feature in Terradata.
105.
by hans_castorp 3y ago
The question was "the longest track per album", so I'd expect one row per album as the result (which is what my query does). But adding a LIMIT would not do that. It might be that the question was "the longest track acro
106.
by hans_castorp 3y ago
> How long would it take you to write the SQL for that? select distinct on (album_id) * from tracks order by album_id, milliseconds desc;
107.
by hans_castorp 3y ago
> Seriously, it's your computer, just use whatever setup you prefer The problem is that many websites simply turn on dark mode without checking what my OS/browser is configured for. That is really annoying.
108.
by hans_castorp 3y ago
I think Oracle style hints are not a good thing to have - especially because you have to change the query itself which sometimes isn't possible in a production environment. Additionally, for me they quite frequently made things worse a
109.
by hans_castorp 3y ago
I wonder why the size of the table with uuid7 is smaller than the one with uuid4? Both are using the uuid data type.
110.
by hans_castorp 3y ago
pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others https://github.com/okbob/pspg
111.
by hans_castorp 3y ago
Many people mistake the Windows command line as being "DOS"
112.
by hans_castorp 3y ago
There are many alternative clients: https://wiki.postgresql.org/wiki/PostgreSQL_Clients
113.
by hans_castorp 3y ago
Not directly related (or is it?): I just hate sites where all I see is some fancy wallpaper image and a slogan (if at all). Then I have to scroll down on my 27" monitor to be able to actually read anything on that site. That is stupid
114.
by hans_castorp 3y ago
This can be controlled when use the "Advanced Options". It opens a config file where you can set: RememberOpenedFiles = false https://www.sumatrapdfreader.org/settings/settings3-4-6
115.
by hans_castorp 3y ago
Ah, thanks. The tip at the end seems to fix this on TB 115.
116.
by hans_castorp 3y ago
I am seeing this problem with Thunderbird as well since upgrading to Thunderbird 115 - I hope they are a bit quicker than the Firefox devs.
117.
by hans_castorp 3y ago
> Vespa has been around for a LONG time True. I bought my first Vespa in 1984
118.
by hans_castorp 3y ago
LATERAL is part of the SQL standard (since 1999 if I'm not mistaken)
119.
by hans_castorp 3y ago
I typically use 1e8 instead 100000000 when writing large (integer) numbers
120.
by hans_castorp 3y ago
But you need to know in advance which keys/paths you want to index. Postgres can index the entire JSON document (or parts of it) and they can support unknown query condition (e.g. using a JSON path). This isn't as fast as a proper

More ›