11–20 of 205 posts
Earlier quoted context omitted.
> DevOps and DBA teams Ah so two teams nobody should listen to.
At least would take it with a grain of salt when the DBA wants you to depend more on the DBA.
"Hey everyone, we need to chose the option that involves us the most and provides us the most job security"
I have always loved SQLite. I have also heard that some firms ban its use. Why? Because it makes it SO easy to set up a database for your app that you end up with a super critical component of your application that looks exactly like a file. A file that can have any extension. And that file can be copied around to other servers. Even if there is PII in that file. Multiply this times the number of applications in your…
The question is, do the same firms ban Excel? Excel spreadsheets often end up as shadow databases in unlikely places.
For public-sector data preservation, it may be one of the best options. The specification is publicly available - It is widely adopted - It is likely to remain readable in the future - It has little dependency on specific operating systems or services - It carries low patent risk From the perspective of long-term continuity, avoiding dependence on any particular company or service is extremely important.
For public-sector data preservation, it may be one of the best options. The specification is publicly available - It is widely adopted - It is likely to remain readable in the future - It has little dependency on specific operating systems or services - It carries low patent risk From the perspective of long-term continuity, avoiding dependence on any particular company or service is extremely important.
Archivists also love formats close to native. SQLite lets the relational relationships be present in a way that csv cannot.
So this news is nearly six EIGHT years old. But I didn't happen to know about it until now, so that's not a complaint at all; rather, this is a thank-you for posting it.
(Thanks for the correction. Brief brain malfunction in the math department there).
> As of this writing (2018-05-29) ... So this news is nearly six EIGHT years old. But I didn't happen to know about it until now, so that's not a complaint at all; rather, this is a thank-you for posting it. (Thanks for the correction. Brief brain malfunction in the math department there).
> As of this writing (2018-05-29) ... So this news is nearly six EIGHT years old. But I didn't happen to know about it until now, so that's not a complaint at all; rather, this is a thank-you for posting it. (Thanks for the correction. Brief brain malfunction in the math department there).
Sir, it's 2026. It's 8 years old.
I have always loved SQLite. I have also heard that some firms ban its use. Why? Because it makes it SO easy to set up a database for your app that you end up with a super critical component of your application that looks exactly like a file. A file that can have any extension. And that file can be copied around to other servers. Even if there is PII in that file. Multiply this times the number of applications in your…