nikeee

18 ms·

181.
by nikeee 4y ago
That's what I feel like, too. Every ORM that I've worked with is a separate DSL that I need to learn. Also, abstracting away the database is something I don't get - why abstract away something that I explicitly chose because
182.
by nikeee 4y ago
The documentation offers some advice on this: https://www.sqlite.org/whentouse.html
183.
by nikeee 4y ago
These numbers are called "Highly Composite Numbers" [0]. Basically, it is a series of numbers where each number has more factors than the number before it (and is the first number with that number of factors). As you hinted, they
184.
by nikeee 4y ago
There was WebSQL, which aimed to be an SQL database as a JavaScript browser API [0]. Turned out, every browser used SQLite as an implementation backend which lead to the deprecation of WebSQL. [0]: https://en.wikipedia.org/w
185.
by nikeee 4y ago
Looking at this [0] news from about a month ago, the Chrome team showed that they are trying to bring Rust to the table. However, their wording was: > The Chrome security team is working to make a cross-platform memory safe language avai
186.
by nikeee 4y ago
> The language, at least for now, is Rust. What are the alternatives in the context of Chromium development as a replacement for C++?
187.
by nikeee 4y ago
The main page [0] shows you awesome demos, but also its weaknesses in the very first example. It doesn't encode the url encoded body properly: > body: `text=${text}`, So it breaks if the text contains a '&' and even al
188.
by nikeee 4y ago
Also consider setting a successor on GitHub: > We recommend inviting another GitHub user to be your successor, to manage your user owned repositories if you cannot https://docs.github.com/en/account-and-profile/
189.
by nikeee 4y ago
I was under the impression that they compile with /checked per default. TIL! Regardless of that flag, Math.Abs will throw an OverflowException: https://referencesource.microsoft.com/#mscorlib/system/math....
190.
by nikeee 4y ago
I've a C# background and was pretty surprised about that. C# throws an exception in that case.
191.
by nikeee 4y ago
> 1. Java does not trap overflows This one struck me some day because this is why Math.abs can return a negative value. When passing Integer.MIN_VALUE, the result will be -2147483648. There is now StrictMath.absExact that throws an excep
192.
by nikeee 4y ago
This is very cool. I like that it doesn't use a build process nor code generation. And especially that the project doesn't need to re-implement parsing and type inference.
193.
by nikeee 4y ago
By mutating queries I thought of UPDATE, INSERT and DELETE. It should be possible to parse those and check if they obey the schema, so raw SQL that updates/inserts/deletes data could also be checked.
194.
by nikeee 4y ago
I'm not a fan of the idea of leveraging TS types at runtime. This is just a lock-in to TS, even if type annotations become a thing in JS. I don't like ORMs that use runtime types either. Most of the time, I want to write raw SQL.
195.
by nikeee 4y ago
How do they handle the additional e-waste?
196.
by nikeee 4y ago
> 99% are just fake. If you reject cookies you keep get them Note that cookies that are technically required to serve the site don't need a cookie banner. This is something many people get wrong. Other people shift to LocalStorage i
197.
by nikeee 4y ago
There is also VACUUM INTO: https://www.sqlite.org/lang_vacuum.html#vacuuminto
198.
by nikeee 4y ago
Sadly no, but that's a different KPI than "how many visitors you get on your website".
199.
by nikeee 4y ago
They certainly can provide uniqueness to some degree. GoatCounter [1] does that. [1]: https://www.goatcounter.com
200.
by nikeee 4y ago
TypeScript also lets you create subsets of infinite size. For example, a string template literal type can be a type with (theoretically) infinite string values matching a string template. I've created a proposal for doing something sim
201.
by nikeee 5y ago
SQLite also supports referencing by parameter number (and name): https://www.sqlite.org/lang_expr.html#varparam So, changing "?" to "?1" could be done in SQLite before the actual migration, leaving just
202.
by nikeee 5y ago
A comment [0] on the commit of that PR points to this site [1]. This site mentions that the vulnerability is similar to CVE-2010-1622 [2, 3]. Maybe this could help finding the issue, toegether with the recommended actions and mentioned clas
203.
by nikeee 5y ago
As I understand shebangs, one could use something like this: #!/usr/bin/lic run
204.
by nikeee 5y ago
Author of a web-based GraphViz editor [1] here. We're currently using viz.js [2], which is the original GraphViz compiled to WASM. Since viz.js is unmaintained, we're looking for a replacement. This library looks really promising!
205.
by nikeee 5y ago
I recently discovered Hurl, which has a similar idea and I think it's great for API integration tests: https://hurl.dev
206.
by nikeee 5y ago
You can use an AbortController for that. Also, keep in mind that the linked solution does not abort the web request. It only aborts waiting for the response in the JS code. The browser does not close the connection.
207.
by nikeee 5y ago
I think the point here is that there are now two modes of operation, which leads to more complexity overall.
208.
by nikeee 5y ago
It prints the source off itself, when source is present as a query parameter: https://lucb1e.com/randomprojects/php/funnip.php?source
209.
by nikeee 5y ago
418 is defined in HTCPCP, an _extension_ to HTTP. That's why I never understood why people use it in HTTP. So it makes sense that it's only reserved in HTTP.
210.
by nikeee 5y ago
IMHO safe navigation only makes sense when the compiler is able to reason about nullability, meaning nullability is rooted in the type system. That's the case for Kotlin and not for Java. Otherwise, you've got a high risk of devel

More ›