In a world rich in sqlite databases what purpose does access serve?
>>106567222https://help.sonatype.com/en/install-nexus-repository.htmlAs a ticking timebomb for penny pinching corposGoogle search "H2 database corruption"
>>10656722220 years ago it was a tool for very small businessestoday it's a tool for very small businesses who survived for 20 years but didn't grow
It's a database for the people at your corp's front desk to look up shit
because sqlite doesn't give you all the tools to build a basic CRUD app with a normie friendly GUI
>>106567571Christ, there's gotta be something out there better than Access tho, surely.
>>106567222I honestly don't know. does anyone actually use access?it seems more likely some retard will abuse a shared excel sheet as a database before reaching for access.
>>106567571the second you need to do automation you need to go in a wonderful world of Visual Basic for Applications and i wouldn't wish that on the worst fucking enemy, otherwise it's excel with forms
>>106567613They been preferring excel for 30 years now. Which maybe tells you more about how fucking horrible Access interface always was than people's propensity for confusing spreadsheets with db's
>>106567222SQLite is probably the world's most widely deployed software that normies have no idea existsyou have to find and download a separate GUI program to be able to use it in a manner similar to Access, which normies already know about and usually have installedbut you already know that, so why the question?
>>106567222I still use it once in a while for cleaning data, especially CSVs. It generally works better than SQL Server's import functionality.
>>106567636What do you mean, I love VBA
>>106567222Allows departments to create business critical applications that run locally and then run crying to IT when their shitty Dell laptop inevitably fails because they never put proper backup procedures in place. But it was way easier than submitting a ticket and project request to actually get a proper database hosted on a server because who wants to do that?
>>106567678I use Power Query for that.
>>106567600there are no decent desktop native competitors to access. there's definitely a gap for it as all the modern competitors are SASS webslop
>>106567711We don't have the resources for a FOSS competitor to Access. We are spending all our money on maintaining 150 useless Linux distros with 99% overlap in functionalities.
>>106567699>way easier than submitting a ticket and project request to actually get a proper database hosted on a server because who wants to do that?I agree. shadow IT gods heem sissy boi IT cucks every single day. if your process isn't push button, receive *thing* it's probably shit and you should feel ashamed.
>>106567730https://www.libreoffice.org/discover/base/
>>106567753Not my fault the contracted jeets on the other end of the servicenow request form take minimum of 3 weeks and 5 meetings to approve and provision this shit. At least management gets to pat itself on the back about the cost savings and FTE headcount efficiency.God corporate IT is a Kafkaesque hellscape.
>>106567803yes, I agree. I use to be the kind of nigga who'd mock "cloud" as "someone else's computer."is it true? yes, but "someone else's computer" has a proper API and is completely devoid of the need of human interaction.it's pathetic how much better it is to set up Azure SQL or SQL Server PaaS in Azure vs dealing with the retarded "DB team."
>>106567571lmao you can literally do 10s of thousands of writes per second with sqlite, only problem is when you need multiple writers
>>106567483True and real.
>>106567782Is it as much of an equal to Access as Calc is an equal to Excel, which is to say completely lacking in everything but the most basic functionality?
>>106567835Cloud stuff is improved but still needs to pass through management, network, and security teams where I work. Some dude had to wait almost two weeks for a simple firewall change because his application wasn't on the "approved" list. At least he got paid to sit around for two weeks with his thumb up his ass while waiting to hear back from Mumbai. Maybe I should take up carpentry or something,
>>106567222What are its use cases and how does LO Base(d?) stand up to it?
>>106568245The use cases being >>106567500, nothing more.
>>106567699Currently in the middle of migrating a team off a shitty Access app they've been using for the last 10 years. Its for companies still using windows XP and printers.
>>106568280I thought that was a job for Excel?
>>106568294Access, no matter how shit it is, is a database. Excel is for analysing data making tables.
>>106568210your mom is completely lacking in everything but the most basic functionality>>106568212>Maybe I should take up carpentry or something,based
>>106567600oops nm>Tables will no longer be supported on December 16, 2025. All workspaces are currently read-only. To continue using your data, transfer it to an AppSheet database or Google Sheet.
>>106567222none. thats why its dead and what few useful features it had were ported to excel>>106568454same story. anything you wanted to do with tables that was worth doing was probably ported to sheetsin both cases, tables can reference other tables and rich lookup operations are supported. you're like 145% of the way to an sql database (thoughbeit with 1% of the speed but youre an hr roastie kludging expense reports together so who cares)
>>106567222Database theory.
>>106567222user interface that people think they aren't using a database
>>106567571>>106567600GRIST is the only thing around that does this type of shitmore programmatic spreadsheetsthe sqlitebrowser program with a lot of polishing could maybe get there too
>>106568126You can get SQLite up to about the speed of native disk IO in writes, providing you pipeline them through a single thread and disable sync. It massively beats a big pile of files, and I've done terabyte-sized data imports (raw simulation results) this way. SQLite's awesome.But if you need parallel writes (especially to different rows), get a database server. That's what they're good at. Lots of apps don't actually need that, but some definitely do.
VBA, I guess.
>>106568126However you can't give SQLite to shit smearing simians and expect them to make something valuable out of it (unless you get to write a frontend and integrations for them, but if management doesn't care whatever can you do?) Access is the worst garbage i've seen in a decade but even your boss' dad can figure it out with enough clicks.
>>106567483Literally my company. We are going out of business btw, someone please give me a job quick
