SigmundA

15 ms·

181.
by SigmundA 2y ago
"The 4th of July" is more formal sounding, so it makes sense for the holiday, but many just say "July 4th" more informally when referring to the holiday. Again grammatically is easier and shorter to say month day vs the
182.
by SigmundA 2y ago
To me its sounds better and more correct to say: February 12th, 2025 Rather than: 12 February 2025 And is easier to say than: The 12th of February 2025 So it's always been natural to write the numeric form the same way, but I am Americ
183.
by SigmundA 2y ago
My preference would have been for PG to have a hierarchal data type that supported all of its normal data types and then built JSON support on top of that.
184.
by SigmundA 2y ago
Since it uses BSON it support more datatypes like date, binary, decimal, etc. Looks like it supports background indexing too. Date and Binary are ones I wish JSONB supported most often.
185.
by SigmundA 2y ago
25hz is part of the "around 30hz" I mentioned. It was a compromise for the Niagra falls turbines between 16.7hz which was good for large motors at the time and flickering lights for which Westinghouse wanted at least 33.3hz.
186.
by SigmundA 2y ago
My Tl;dr would be a little longer - early systems used both higher (around 130 hz) which caused issues with resonance and difficulties making induction motors, and lower (around 30hz) which caused light flicker. 50-60 hz solved these issues
187.
by SigmundA 2y ago
Parameterized sql is a good thing regardless of plan caching, but it also helps with systems that do plan caching. That the client must explicitly prepare the statement and the preparation is tied to the connection is pretty clunky and stil
188.
by SigmundA 2y ago
The mRNA vaccine tells your cells to create the spike protein that was isolated from the original virus for about 48 hours at levels much lower than the virus itself. mRNA is used up by this process which is why your cells stop producing th
189.
by SigmundA 2y ago
I mentioned this down thread, MSSQL and Oracle cache query plans allow their optimizers to take their time which I imagine helps with doing more sophisticated optimization. PG always re optimizes on every call unless you manually prepare th
190.
by SigmundA 2y ago
One significant difference between PG and MSSQL is MSSQL caches query plans allowing its optimizer to be much more sophisticated and slower. PG re-optmizes every query over and over unless you manually do a prepared statement and that only
191.
by SigmundA 2y ago
Yes the 45 Tesla magnet in Tallahassee can levitate small non ferrous things like a strawberry in a little tube and draws 56 megawatts about 7% of the cities power grid.
192.
by SigmundA 2y ago
protobuf doesn't have key names without the schema right? Wouldn't it just decode to 1,type,value 2,type,value without the schema no names? Human readable key names is a big part of what makes a self describing format useful but a
193.
by SigmundA 2y ago
>NULL is not a value. I do not agree it is most certainly a value that is stored in the database. >NULL is a statement that a value is not available or unspecified reasons. Again I disagree, it is a value that denotes its value is of
194.
by SigmundA 2y ago
Sentinel values suck especially when the language already has a perfectly good one built in. Is 0 for a temp measurement unknown sentinel or an actual measurement, how about 2,147,483,647 great probably not a measurement now its always incl
195.
by SigmundA 2y ago
If it is not recognizably different than it is the same in that context correct? Two measurements of 25C are not recognizably different therefore they are equal, correct, regardless if the actual temperatures are not the same? Two measure
196.
by SigmundA 2y ago
Whether two measurements of 25C are the same is unknown, these are just values recorded in a database. 25 is a value, null is a value. The values in the db are the same in both cases which is what I would like my db language to deal with an
197.
by SigmundA 2y ago
>Yes, the measurements are the same. By the logic two unknown (null) measurements are the same regardless of the actual value which I agree with.
198.
by SigmundA 2y ago
>That's because "different" and "distinct" don't mean the same thing. The literal definition distinct is: >recognizably different in nature from something else of a similar type. If you want to get down
199.
by SigmundA 2y ago
Here is an example straight out of the MS access 1.0 introduction to programming from 1992, page 100, brings back some memories: > You can also create a Dynaset variable using an SQL string instead of the name of an existing table or que
200.
by SigmundA 2y ago
The Access database engine used SQL, it's how I got started using the language in the mid 90's. It wasn't just used by MS Access, its was used from VB and other languages because it was just an ODBC/OLEDB driver. https:
201.
by SigmundA 2y ago
> So DRH asked the question: what if the database just worked without any server? This was an innovative idea back then. Strange my recollection of the time was file based databases were much more popular. FoxPro, Access (jet) and Dbas
202.
by SigmundA 2y ago
I started professionally programming using VB back in the 90's, I remember how amazing it was at the time to use an IDE with autocomplete and a visual debugger coming from just doing basic on say the Commodore. I was never a C or assem
203.
by SigmundA 2y ago
Would be interesting to see what a unified memory setup can do like say an Apple M-series since this is the argument for unified memory, zero copy memory access between CPU and GPU.
204.
by SigmundA 2y ago
Mapbox Vector Tiles are not SVG, its is similar to geoJSON but encoded in protobuf. The renderer is going to typically be WebGL based in the browser written in javascript. https://wiki.openstreetmap.org/wiki/Vector_tile
205.
by SigmundA 2y ago
The only reason I know and have used this api is because it helps prevent the tab from going to sleep if you hold on to the lock: https://techcommunity.microsoft.com/discussions/edgeinsidera...
206.
by SigmundA 2y ago
The bug states that it works in the browser just not in PWA's. So random websites can actually do this, but not websites the users specifically installs as a PWA, which is kinda the opposite of what you would expect.
207.
by SigmundA 2y ago
Which interestingly enough is used to make PrinceXML [1] one of the only "browsers" to fully support CSS print media. 1. https://www.princexml.com
208.
by SigmundA 2y ago
I feel the same way sometimes, it definitely closer to the same loop of plan execute refactor then many games. I do find my self getting wrapped up into then backing off because it does feel like work. But I like the fact that I can see it
209.
by SigmundA 2y ago
Would help if it worked with JSON by default.
210.
by SigmundA 2y ago
I use Xfinity with a gigabit plan, no fan of them for various reasons, but my "signaling rate" exceeds 1gbps at the physical layer in the cable modem and since I am using the 2.5 Gbps ethernet port on the modem my speed test sligh

More ›