News for hackers. Stuff that matters.
Re:“LibreOffice is at serious risk” by bonzini on Friday July 10, 2020 @03:43PM (#23795535)
Actually I miss Access the most. As an Excel replacement it has what I need to do my taxes and to set up voting sheets and schedules for conferences.
Re:“LibreOffice is at serious risk” by beamatronic on Friday July 10, 2020 @03:46PM (#23795578)
Is there anyway to do visual basic, Access-type apps in the cloud? I mean a full cloud-based IDE?
Re:“LibreOffice is at serious risk” by oh-4-fucks-sake on Friday July 10, 2020 @03:53PM (#23795642)
Might not be the exact right feature-set here, but Google Sheets allows you to write custom functions in Javascript. IIRC, you can hook a Google Sheet up to Google Forms and this might give you what you want.
Re:“LibreOffice is at serious risk” by bonzini on Friday July 10, 2020 @04:12PM (#23795883)
It doesn't let you do declarative queries (read: SQL) and it's not relational.
Re:“LibreOffice is at serious risk” by JustARandomGuy on Friday July 10, 2020 @04:39PM (#23796184)
Google Apps Scripts (equivalent to VBA in Office) can script most Google products; you could build a form on one tab of a Google Sheet, use Apps Scripts to store and query data against Cloud SQL, then use another tab of Sheets to output the data from Cloud SQL.

https://developers.google.com/apps-script/guides/jdbc

Re:“LibreOffice is at serious risk” by bonzini on Friday July 10, 2020 @05:15PM (#23796557)
That's not what a replacement for Access should be like.
Re:“LibreOffice is at serious risk” by grandinj on Friday July 10, 2020 @04:02PM (#23795750)
LibreOffice Base is an Access-type program
Re:“LibreOffice is at serious risk” by canada_dry on Friday July 10, 2020 @04:52PM (#23796331)
In the same way a Lada is an automobile.

Perhaps it's improved, but a while ago I tried to program Base and found the documentation around it's functions/methods/properties to be scant and/or terribly out-of-date, and pretty much useless.

Re:“LibreOffice is at serious risk” by grandinj on Monday July 13, 2020 @03:04AM (#23817842)
Ouch!

:-)

Yeah, it's the unloved step-child of the LibreOffice suite, we fix stuff sometimes, but there is no commercial user of it to fund development

Re:“LibreOffice is at serious risk” by blihp on Friday July 10, 2020 @04:53PM (#23796341)
In theory, but not in practice. Yes, it's a somewhat visual database. But it doesn't have anywhere near the power or ease of use that Access did 20 years ago and its integration with the rest of LO isn't even close to what Access does in MS Office. If that weren't bad enough, the underlying database it uses is effectively an island in the larger open source world.

In the Windows world, just about everything can interact with Access. Just about nothing can with Base.