arrowleaf

7 ms·

121.
by arrowleaf 3y ago
Have a single application clearly owning the data. All access to the data is done through that application. Why would you _want_ multiple applications deciding how to handle data in a common store? What about access authorization to sensiti
122.
by arrowleaf 3y ago
Implementations with skin in the game are still innovating and improving the 'tried and true' relational database model, IMO. PostgreSQL, MS SQL, MySQL, etc. consistently churn out new features that actually make sense, like FK co
123.
by arrowleaf 3y ago
And then, don't just drop the constraints because you read an article about how FK constraints don't work with a distributed relational model, take a careful look at the docs of whatever DB engine you're using. PostgreSQL 12
124.
by arrowleaf 3y ago
The only time I could see it really impacting performance is during bulk operations. But that's where making FK constraints deferred and wrapping the bulk actions in a transaction makes more sense.
125.
by arrowleaf 3y ago
My assumption (with modern applications!) is that nothing but the role directly owning the data will access the data. The development and DBA teams will likely have a role they can assume after performing a carefully-audited breakglass proc
126.
by arrowleaf 3y ago
By soft deletion, do you mean you would want to ever re-instate the record and make it valid again, PK/FK constraints and all? Or tracking deleted records? For the latter I use audit tables + triggers to track the changing values. At a
127.
by arrowleaf 3y ago
There's also lots of track included that hasn't seen passenger trains in 30-50 years. The only passenger rail in Idaho is in the panhandle. I'm not sure if Helena has any passenger traffic either.
128.
by arrowleaf 3y ago
All of their messaging, Ilya's especially, has always been that the forefront of AI development needs to be done by a company in order to benefit humanity. He's been very vocal about how important the gap between open source and O
129.
by arrowleaf 3y ago
I need to take another look at this. I've recently started working with RDF data on a scale of ~50 million URIs not including properties and statements, there's a ton of suplicates in there. I loaded a 10k entity subset of this an
130.
by arrowleaf 3y ago
Serious question, is Red Hat a risk to the Quarkus project? I haven't started any new applications on anything but Quarkus for a couple of years. I would love to use Helidon, but the features and production stability just aren't t
131.
by arrowleaf 3y ago
I love VS Code, but I will never be able to work with Java code outside of IntelliJ. Hopefully this extension is a bit more stable than the Red Hat one, whenever I've attempted to use VS Code for Java it's hit or miss whether plug