| ▲ | alexpotato 7 hours ago |
| 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 firm and you can see how this could get a little nuts. DevOps and DBA teams would prefer that the database be a big, heavy iron thing that is very obviously a database server. And when you connect to it, that's also very obvious etc etc. I still love SQLite though. |
|
| ▲ | Fwirt 7 hours ago | parent | next [-] |
| The question is, do the same firms ban Excel? Excel spreadsheets often end up as shadow databases in unlikely places. |
| |
| ▲ | hermitShell 6 hours ago | parent | next [-] | | The sane thing would be to ban Excel and promote SQLite. Excel is often used for tabulated text (issue tracking) not calculations. Perfect use case for a relational db | | |
| ▲ | harvie 2 minutes ago | parent | next [-] | | or reimplement excel with sqlite as a backend :-D BTW sqlite can run SQL queries on CSV files with relatively simple one-liner command... | |
| ▲ | rswail an hour ago | parent | prev | next [-] | | Excel has sheets for tables, columns and rows, primary keys (UNIQUE), foreign key references etc if you squint. It doesn't require you use all of that properly, but it's there. | |
| ▲ | frollogaston 6 hours ago | parent | prev | next [-] | | Excel is made for calculations. But if you make it hard to make a DB, people will abuse Excel as a DB. | | |
| ▲ | TJSomething 3 hours ago | parent [-] | | I mean, it might have been at first, but Microsoft figured out that the majority of users for lists without formulas in 1993 and they've strategized around that. IMHO, the biggest concession to this was when they added Power Query to core Excel in 2016. |
| |
| ▲ | 0123456789ABCDE an hour ago | parent | prev [-] | | and excel has gui for forms | | |
| |
| ▲ | silon42 3 hours ago | parent | prev | next [-] | | IMO, almost any Excel more than a month old should become readonly. | |
| ▲ | Spooky23 6 hours ago | parent | prev | next [-] | | They generally cannot. But they do banish Access. | | |
| ▲ | pasc1878 2 hours ago | parent [-] | | Now that is different. Access gets used for a shared DB and that is quite easy to corrupt. It is much more cost effective to have that in a proper central database (I supse SQLLite is better here as well) |
| |
| ▲ | 4 hours ago | parent | prev | next [-] | | [deleted] | |
| ▲ | DeathArrow 4 hours ago | parent | prev [-] | | Do companies ban text files? Text files are used to store data. | | |
|
|
| ▲ | tehlike 5 hours ago | parent | prev | next [-] |
| There are interesting uses for sqlite, like this one:
https://sqlite.org/sqlar.html |
|
| ▲ | ai_slop_hater 7 hours ago | parent | prev | next [-] |
| That's so dumb |
|
| ▲ | slopinthebag 6 hours ago | parent | prev [-] |
| > DevOps and DBA teams Ah so two teams nobody should listen to. |
| |
| ▲ | frollogaston 6 hours ago | parent [-] | | At least would take it with a grain of salt when the DBA wants you to depend more on the DBA. | | |
| ▲ | slopinthebag 6 hours ago | parent [-] | | Same with devops tbh. "Hey everyone, we need to chose the option that involves us the most and provides us the most job security" | | |
| ▲ | mschuster91 38 minutes ago | parent [-] | | Well... eventually the company learns the lesson the hard way, either because a site goes down or gets 0wned. Then everyone will cry about "how this could happen", and the ops people will tell you in response "we warned you that this would happen, here's the receipts, now GTFO". |
|
|
|
