Re: [sqlite] SQLite Windows GUI alternative to Excel?
On Oct 6, 2018, at 2:21 PM, Simon Slavin wrote: > > > Excel ate the financial business world because companies use Excel to solve a > simple problem, then add a feature, then add another feature, and keep going > until they have some crawling creeping horror that needs to return to R'lyeh. > There is never any point in this process when a manager looks at what's > being done with Excel and says "Okay we need to hire a programmer to turn > this into a proper App.”. Up to a certain point, there’s nothing wrong with that process. One of the tasks smart management should be doing is keeping an eye on these guerrilla software development projects and step in when it becomes clear they’ve got a valuable business tool that needs to be rewritten on a stronger foundation to allow its continued growth and increasing value to the business. If your business is big enough to have an IT staff with at least one professional programmer, turning Excel prototypes into professional business tools is mainly a matter of scheduling. (Again, a function of management.) The main need for a personal database is in organizations too small to have full-time programming staff. (That includes most home use as well.) Maybe that’s the biggest reason this sort of software is rare and expensive: big business doesn’t need it, so it only gets funded by small businesses and home users, who are notoriously tight when it comes to software licensing. Contrast the elements of a traditional office software suite, which are needed clear through the Fortune uint8_t. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On 6 Oct 2018, at 8:04pm, Luuk wrote: > Even a simple program (or (gui?)-interface on top of sqlite will not > stop those Excel-whizz-kids from crafting things in Excel. Excel ate the financial business world because companies use Excel to solve a simple problem, then add a feature, then add another feature, and keep going until they have some crawling creeping horror that needs to return to R'lyeh. There is never any point in this process when a manager looks at what's being done with Excel and says "Okay we need to hire a programmer to turn this into a proper App.". Reasons why this doesn't happen are the subject of today's coursework essay, 3500 to 4000 words, due in my pigeonhole by 5pm on the 14th. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On 6-10-2018 18:23, Warren Young wrote: > On Oct 6, 2018, at 9:46 AM, Roger Schlueter wrote: >> In addition to the freebies mentioned by Luuk, WordPerfect Office X9 is a >> commercial product that includes all of Excel's features including >> import/export of Excel data. > I guess neither of you read the article, because the point of the original > question isn’t to get recommendations for yet another spreadsheet program, > it’s to get a program that lets us get away from spreadsheets-as-databases, > because when such creations get complicated, they become very difficult to > debug. > > (The article is about a guy who hates the fact that he allowed it to become > known that he can debug these monstrosities, with the result that people keep > bringing them to him.) > > What we want is a SQLite-based program along the lines of Access or > FileMaker, preferably with some kind of cloud capability. i never did anything with FileMaker, but if Excel is a no-way-to-go, than Access is most certainly too ! and, yes, i did not read the article... (sorry!) Even a simple program (or (gui?)-interface on top of sqlite will not stop those Excel-whizz-kids from crafting things in Excel. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On 6 Oct 2018, at 5:23pm, Warren Young wrote: > What we want is a SQLite-based program along the lines of Access or > FileMaker, preferably with some kind of cloud capability. > > If that wish seems frivolous, realize that we’re not going to get rid of the > spreadsheet-as-database as long as we have things like Office 365, Google > Sheets, and iWork Numbers filling the desktop, mobile, *and* cloud niches. > This replacement must fill all of these same niches to begin pushing out > these misuses of spreadsheets. Otherwise, it will only help the minority of > people who need a personal database on only one of these platforms. While all the above is true, I have written software like this. A top-of-the head estimate for a single-user version would be 5% OS interface, file handling, password protection 5% database, mapping cells onto file/memory structure 5% calculations and spreadsheet logic 85% GUI In other words, the DBMS doesn't matter. Most of your programming time is user interface and stopping the user from doing stuff they don't really want to do (e.g. circular references, implementing "Undo"). Much as I adore SQLite, it concerns just a tiny part of the problem. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On 06 Oct 2018, at 17:23, Warren Young wrote: > I guess neither of you read the article, because the point of the original > question isn’t to get recommendations for yet another spreadsheet program, > it’s to get a program that lets us get away from spreadsheets-as-databases, > because when such creations get complicated, they become very difficult to > debug. [snip] > What we want is a SQLite-based program along the lines of Access or FileMaker, > preferably with some kind of cloud capability. If you toddle over to forum.xojo.com, there seems to be a thread ("Evaluating - how can there be no DataGrid") asking this question, with some possible answers. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On Oct 6, 2018, at 9:46 AM, Roger Schlueter wrote: > > In addition to the freebies mentioned by Luuk, WordPerfect Office X9 is a > commercial product that includes all of Excel's features including > import/export of Excel data. I guess neither of you read the article, because the point of the original question isn’t to get recommendations for yet another spreadsheet program, it’s to get a program that lets us get away from spreadsheets-as-databases, because when such creations get complicated, they become very difficult to debug. (The article is about a guy who hates the fact that he allowed it to become known that he can debug these monstrosities, with the result that people keep bringing them to him.) What we want is a SQLite-based program along the lines of Access or FileMaker, preferably with some kind of cloud capability. If that wish seems frivolous, realize that we’re not going to get rid of the spreadsheet-as-database as long as we have things like Office 365, Google Sheets, and iWork Numbers filling the desktop, mobile, *and* cloud niches. This replacement must fill all of these same niches to begin pushing out these misuses of spreadsheets. Otherwise, it will only help the minority of people who need a personal database on only one of these platforms. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
In addition to the freebies mentioned by Luuk, WordPerfect Office X9 is a commercial product that includes all of Excel's features including import/export of Excel data. https://www.wordperfect.com/en/product/office-suite/?hptrack=mmap On 10/6/2018 4:40, Winfried wrote: Hello, After reading this article… "In the workplace, spreadsheet experts face a constant barrage of help requests" https://www.wsj.com/articles/the-first-rule-of-microsoft-exceldont-tell-anyone-youre-good-at-it-1538754380 … I'd like to check if there is a Windows GUI available as a valid alternative to Excel, either free or commercial, that would let people import XLS data and provide most of the Excel features. Thank you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Windows GUI alternative to Excel?
On 6-10-2018 13:40, Winfried wrote: > Hello, > > After reading this article… > > "In the workplace, spreadsheet experts face a constant barrage of help > requests" > https://www.wsj.com/articles/the-first-rule-of-microsoft-exceldont-tell-anyone-youre-good-at-it-1538754380 > > … I'd like to check if there is a Windows GUI available as a valid > alternative to Excel, either free or commercial, that would let people > import XLS data and provide most of the Excel features. > > Thank you. > > > LibreOffice (http://libreoffice.org/) or OpenOffice (http://www.openoffice.org/) LibreOffice provides all the functions of Excel, but the macro's is a nightmare ;) (or, in other words, writing a macro in Excel is easier than in LibreOffice) i dont use OpenOffice, so i cannot give any info on it. Finally, this question is prettu OFF-TOPIC for this list ? maybe more suitable, pick a list from https://www.libreoffice.org/get-help/mailing-lists/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Windows GUI alternative to Excel?
Hello, After reading this article… "In the workplace, spreadsheet experts face a constant barrage of help requests" https://www.wsj.com/articles/the-first-rule-of-microsoft-exceldont-tell-anyone-youre-good-at-it-1538754380 … I'd like to check if there is a Windows GUI available as a valid alternative to Excel, either free or commercial, that would let people import XLS data and provide most of the Excel features. Thank you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users