Database for small company

Discuss the database features

Database for small company

Postby harry47 » Thu Jan 25, 2018 1:48 pm

I run a small publishing company and need a simple database which creates invoices, adjusts book inventory totals after sales and new additions etc.

The OpenOffice database seems to be quite comprehensive but I don't see the functions I need. Can it be used for such purposes or do I need something different?
OpenOffice 4.0.1 with MacOS 10.6
harry47
 
Posts: 3
Joined: Thu Jan 25, 2018 1:39 pm

Re: database for small company

Postby Villeroy » Thu Jan 25, 2018 3:06 pm

You need a database developer.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25560
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Database for small company

Postby RoryOF » Thu Jan 25, 2018 5:25 pm

My advice is to buy a readymade business database. In the past I used Quickbooks, which I found simple and straightforward. I believe (no personal experience) that Gnucash may be similar.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26920
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Database for small company

Postby harry47 » Thu Jan 25, 2018 6:21 pm

Thank you for your suggestions, but I am retired and do not feel that our limited sales are sufficient to motivate the purchase (or rental) of a commercial program. I'm looking more for an open-source or free business application, which can be used with Mac OS.
OpenOffice 4.0.1 with MacOS 10.6
harry47
 
Posts: 3
Joined: Thu Jan 25, 2018 1:39 pm

Re: Database for small company

Postby RoryOF » Thu Jan 25, 2018 6:29 pm

Developing a business database on OpenOffice will take much time. The few hundred dollars/euro Quickbooks will cost will be less than the ultimate cost of expenditure of time in developing a business database. Plus, you will also get access to user forums and perhaps support for a period. But it is your decision, of course.

I am not sure what commercial business databases are available for Macs.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26920
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Database for small company

Postby Villeroy » Thu Jan 25, 2018 10:28 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25560
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Database for small company

Postby harry47 » Thu Jan 25, 2018 10:39 pm

This was helpful – thanks.
OpenOffice 4.0.1 with MacOS 10.6
harry47
 
Posts: 3
Joined: Thu Jan 25, 2018 1:39 pm

Re: Database for small company

Postby the_watchmann » Tue Feb 27, 2018 11:18 am

I have been using gnucash for 10 years now and I can vouch for it. I do the bookkeeping for a medium sized timber company and gnucash comes through rock solid. You can link it to sqlite3 for a really stable experience. I found the sqlite3 database to be less prone to losing data in the event of a system crash.
OpenOffice 4 Linux Mint 17.2
User avatar
the_watchmann
 
Posts: 18
Joined: Wed Oct 05, 2011 2:40 pm

Re: Database for small company

Postby joaofmateus » Tue Feb 27, 2018 2:05 pm

I am incredulous!
In a forum on the Base, visitors are advised to use another product when their use should be encouraged.
And, as if that were not enough, they are still advised to look for a database developer when, I think, the BASE should essentially serve to be used by advanced users, or even beginners, who want to venture either in programming or in the construction of small (or large) databases.
In fact, this seems to come in the line of thought that has lately presided over the very development of the Base that, instead of making it more and more user friendly, has little or nothing to do with it!
I, who, I confess, already have some experience in database development, for databases with large tables and large amounts of information, I would never choose to develop them as the Base, but for simple and little databases volume of data would choose the Base, yes, if I were guaranteed the problem of data loss that, undoubtedly seems to me to be its most serious problem and which has not been given due attention by its developers, either for lack of means, or lack of knowledge!
OOo 4.1.5 on MS Windows 10
joaofmateus
 
Posts: 33
Joined: Fri Mar 20, 2009 12:15 pm
Location: Lisbon - Portugal

Re: Database for small company

Postby RoryOF » Tue Feb 27, 2018 2:21 pm

One is not obliged to offer advice, but I believe that, if one does, it should be best advice. Knowing the learning curve and problems that might arise from an inexperienced user attempting a mission critical development (it is intended to be used in a business for invoicing etc) using Base and associated database, I advised that a commercial or an already developed product is best.

Are you prepared to hold the OP's hand and take him through the development of the application he proposes?
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26920
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Database for small company

Postby Villeroy » Tue Feb 27, 2018 4:49 pm

joaofmateus wrote:I am incredulous!

This is the same Base component since 2011. And between 2005 and 2011 there used to be 2 developers working on Base. They struggled hard to keep this compmonent up and running against regressions and they added small, nevertheless important, improvements to the functionality of 2005. Today we can be happy when someone from the Calc department takes a look at a serious Base problem.

The GUI tools which should allow you to click together some working database always have been insufficient because they have far too many gaps leading new users right into a huge mess of inadequate data types, all fields optional, arbitrary primary keys, no foreign keys and non-normalised tables constantly requiring new category columns. The tools do not even cover all features of HSQL 1.8, for instance it is impossible to apply any default value that is not a constant (DEFAULT CURRENT_DATE) and you can not have admin and user.

RoryOF wrote:Are you prepared to hold the OP's hand and take him through the development of the application he proposes?

Users who barely can handle a spreadsheet with 2 data types don't cope with abstract design concepts and those freedom fighters with some Excel/VBA background immediately start to write macros in order to bypass any conceptual "limitations" (and of course they fail).
As a supporter you find yourself building up the whole database in question or compile a link list pointing to similar solutions. Writing the data definition SQL for a handful of tables, 10 queries, two or three forms can take a full Sunday afternoon. Demonstrating the underlying concepts by examples -- as close as possible to the user's actual problem -- is an efficient way to get "normal users" on track or lose them completely (which is also fine).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25560
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 2 guests