dagss

19 ms·

211.
by dagss 2y ago
I use Jetbrains and there is at least full coverage for MSSQL in my experience, which is a huge dialect -- not only syntax highlighting but full IDE features like autocompletion and target name refactoring etc. And 10 other dialects are lis
212.
by dagss 2y ago
Because US and European countries very directly supports Israel in this case. In the other cases you refer to they are conflicts independent of western countries or at least the western influences are more indirect.
213.
by dagss 2y ago
Why do you not make that argument for "if" and "else" in Go/Java/...? Editors highlight syntax.
214.
by dagss 2y ago
Sort of related in this space I'd like to plug a related tool "sqlcode" that is a different approach to how to deploy stored procedures. Could be a nice partner to sqlc I think. Focused on mssql support so far though, and sti
215.
by dagss 2y ago
Yes, using unpoly, I conclused the way updates work in unpoly to be easier to work with, less need for lots of special endpoints for every kind of interaction than in htmx. But haven't really tried htmx much.
216.
by dagss 2y ago
Not really disagreeing with you, but "staying up for months" isn't a serious bar to clear, it really provides no information in 2024 everything you can install should clear that bar.
217.
by dagss 2y ago
I cannot zoom this page on mobile, very annoying...what is causing it? Anyway seems like a poor recommendation assuming the page is practicing what it is preaching here.
218.
by dagss 2y ago
>> Age and ability are not correlated > ... cognitive decline.. I know this is not the age groups you thought about, but on the topic: I think they ARE correlated, but the other way: At 40 I have had time to get to know so ridiculo
219.
by dagss 2y ago
You say win-win but what is the win of having a seperate internal ID specifically? It is possible to do as you say ofc but what is the advantage?
220.
by dagss 2y ago
That sounds a bit theoretical in this context, I am sure auto makers would love to save the costs of external speakers, so the incentive is there to drop them if the sounds were not mandated.
221.
by dagss 2y ago
Research / development project? The karma system in a community that downvotes AI comments provides quite good (and free) feedback about whether comments are perceived to be written by an AI, or not..
222.
by dagss 2y ago
When CMB anisotropies are studied, one question is to see the the universe is isotropic or anisotropic -- these are two different uses of the word isotropic, on completely different scales. The current prevailing science is saying that the
223.
by dagss 2y ago
JSON numbers have such huge issues that I would question that JSON has types either.. I have seen real life examples of some developers putting money as a decimal in JSON, then other developers using some default parsing into float and fina
224.
by dagss 2y ago
For systems with many services that need 99.9..% uptime, the ways to do ANY change is things like expand-contract. In most such cases you have several instances of your backend running in parallel for scaling and redundancy and when making
225.
by dagss 2y ago
Same, until I read "C library accessed through Python"
226.
by dagss 2y ago
Something I have done for secrets is use a syntax in environment variables to tell the process to go a key vault for the secret. So we can have FOOPW=pw1 when testing locally, but FOOPW="{vault1:secret1}" in production. Env vars a
227.
by dagss 2y ago
Not about SVG as such, but the XML nature of SVG. I see JSON these days for everything including, for instance, savefiles for documents; templates in Azure, etc etc I wonder if I will honestly, un-ironically, use XML in my next project for
228.
by dagss 2y ago
What so often happens is you make a plan like this, then business priorities change/things took longer than expected/people leave or join and then you wish you never started...
229.
by dagss 2y ago
Do NOT do that with MS-SQL. The uniqueidentifier type shuffles byes around and does not give you the ordering you want. So whether you use ULID or UUIDv7, save it as binary(16) in MSSQL. (There is a special custom UUID implementation someon
230.
by dagss 2y ago
> Have you even run a production service? Yes, for many years I was in the core team responsible for a service important enough in my country that if it's down for 30 minutes it makes the national newspapers. Some million users. And
231.
by dagss 2y ago
...yet people flock to NoSQL to avoid the complexity of having to learn SQL. Or stick JSON into a single table in SQL, because using more than one table is too complex. And so on. (This is my context where I work, if you don't have to
232.
by dagss 2y ago
I don't understand the idea ... do you mean a middleware that parse the SQL query and contains a query planner and has full knowledge of all the indices in the database .. or something else?
233.
by dagss 2y ago
Note that I am ONLY talking about a mode to use for limited, trivial OLTP style queries. The kind where the query planner will never be in doubt -- if you just have the right indices in place. The kind of simple backend software queries whe
234.
by dagss 2y ago
What I had in mind was the simple OLTP usecases. To compete with NoSQL in developer ergonomics. My context is people choosing NoSQL because SQL is too hard to learn and has too many caveats; not because of performance etc So basically a mod
235.
by dagss 2y ago
I am an MS SQL user and didn't touch postgres but can I assume analyse is a tool for displaying the chosen query plan for a query? If so it is in all DBs I would think but it is a bit too manual for my taste, still a big hurdle and opt
236.
by dagss 2y ago
What popular SQL databases need is an option/hint to return an error instead of taking a slow query plan. That way a lot of SQL index creation -- something considered a black art by surprisingly many -- would just be prompted by test s
237.
by dagss 2y ago
By such arguments, what is the point of any research, at all? If everyone was using horses what would you had said about the first prototype car? Probably a very slow and clumsy and failureprone thing.
238.
by dagss 2y ago
Are you sure? I have never interpreted it this way and it is the first way I hear this interpretation. My understanding: To use something "for real" on an actual project, not just toy around with it. (What you use can be good or b
239.
by dagss 2y ago
Don't say auth, say authn and authz.
240.
by dagss 2y ago
If there was an open hot war, would US congress debate for months whether to approve the military package to Ukraine?

More ›