Author Topic: Need a simple database for Windows 10  (Read 4601 times)

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Need a simple database for Windows 10
« on: March 15, 2020, 01:44:34 AM »
I'm prepping an old desktop computer to sell. Hard drive has been scrubbed of all files with anything relating to me (used a DoD-compliant wipe program), Windows has been updated to release 1909. I don't want to use any of my Microsoft Office licenses, so I installed a freeware office suite called (cleverly) FreeOffice. It's actually a very nice suite and it gets good reviews. Where it falls flat on its Teutonic face (it's from Germany) is that it doesn't include a database. Not even a flat file database. (They claim that functionality is built into the word processor, but at best that's not much more than a rudimentary address book.)

There are usually any number of good to excellent freeware options to paid, commercial software. Database seems to be an exception. I could use Libre Office, which includes Base, but Libre Office still uses a traditional menu structure (that's a plus for me, but probably not for younger people who learned with the Microsoft ribbon menu. FreeOffice allows the user to have whichever he/she/it prefers.)

Is there anything out there that anyone is aware of?
- - - - - - - - - - - - -
100% Politically Incorrect by Design

cordex

  • Administrator
  • Senior Member
  • *****
  • Posts: 8,626
Re: Need a simple database for Windows 10
« Reply #1 on: March 15, 2020, 07:55:24 AM »
You are overthinking this. Let the buyer pick their own software.

The people who will use a database will probably appreciate less bloat because what you pick likely isn’t going to be what they want to use.  The people who want all the software preinstalled probably won’t ever use it.

Ben

  • Administrator
  • Senior Member
  • *****
  • Posts: 46,049
  • I'm an Extremist!
Re: Need a simple database for Windows 10
« Reply #2 on: March 15, 2020, 08:31:30 AM »
You are overthinking this. Let the buyer pick their own software.

The people who will use a database will probably appreciate less bloat because what you pick likely isn’t going to be what they want to use.  The people who want all the software preinstalled probably won’t ever use it.

Yup, what he said. Unless you're including progs that the new owner would otherwise have had to pay hundreds of dollars for, just sell it with the OS and let them pick their own freeware or buy the progs they want.
"I'm a foolish old man that has been drawn into a wild goose chase by a harpy in trousers and a nincompoop."

lee n. field

  • friend
  • Senior Member
  • ***
  • Posts: 13,579
  • tinpot megalomaniac, Paulbot, hardware goon
Re: Need a simple database for Windows 10
« Reply #3 on: March 15, 2020, 09:45:47 AM »
"Me too me to!"

I agree  with cordex.   Don't worry about a database.  Most people don't need and couldn't use one.  Those that do can install their own.
In thy presence is fulness of joy.
At thy right hand pleasures for evermore.

zxcvbob

  • friend
  • Senior Member
  • ***
  • Posts: 12,240
Re: Need a simple database for Windows 10
« Reply #4 on: March 15, 2020, 09:48:35 AM »
Lotus Symphony is free, but I agree that just a clean install of the OS is a better idea.
"It's good, though..."

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Re: Need a simple database for Windows 10
« Reply #5 on: March 15, 2020, 02:56:04 PM »
Around this neck of the woods, people who are buying old computers seem to want something that's ready to go. They don't want to buy or find software, they want it pre-installed. I don't think a bare operating system would be a selling point, it would be a liability.

I didn't know that Symphony even existed any more. That's one to look into. Last night, after much searching, I stumbled on one that looks promising: https://runabase.com/


[Edit to add]Looks like Symphony doesn't include a database.
https://ibm-lotus-symphony.en.softonic.com/
- - - - - - - - - - - - -
100% Politically Incorrect by Design

WLJ

  • friends
  • Senior Member
  • ***
  • Posts: 28,353
  • On Patrol In The Epsilon Eridani System
Re: Need a simple database for Windows 10
« Reply #6 on: March 15, 2020, 06:03:50 PM »
"Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us".
- Calvin and Hobbes

lee n. field

  • friend
  • Senior Member
  • ***
  • Posts: 13,579
  • tinpot megalomaniac, Paulbot, hardware goon
Re: Need a simple database for Windows 10
« Reply #7 on: March 15, 2020, 06:20:12 PM »
LibreOffice
https://www.libreoffice.org/


If I read the Wikipedia article right, you may as well be getting Libre.

https://en.wikipedia.org/wiki/IBM_Lotus_Symphony

Quote
In thy presence is fulness of joy.
At thy right hand pleasures for evermore.

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Re: Need a simple database for Windows 10
« Reply #8 on: March 15, 2020, 09:04:44 PM »
LibreOffice
https://www.libreoffice.org/


Already considered ...

Quote from: Hawkmmon
I could use Libre Office, which includes Base, but Libre Office still uses a traditional menu structure (that's a plus for me, but probably not for younger people who learned with the Microsoft ribbon menu. FreeOffice allows the user to have whichever he/she/it prefers.)

Yes, I could use Libre Office. I would prefer to use SoftMaker FreeOffice, with something added as a database. I tried to install just Base out of Libre Office but, unlike Microsoft Office, they don't allow you to install only selected modules. The corker is that SoftMaker used to offer a database, but they dropped it a few years ago.
- - - - - - - - - - - - -
100% Politically Incorrect by Design

AZRedhawk44

  • friends
  • Senior Member
  • ***
  • Posts: 13,972
Re: Need a simple database for Windows 10
« Reply #9 on: March 17, 2020, 03:20:50 PM »
Anyone that actually gives a crap about a database is going to have their own preferences.

MySQL or MariaDB or PostgreSQL are decent free relational DB engines, and you can use Toad as a management UI and SQL interpreter or load app.  You can also install Microsoft's SQLExpress engine (or SQL Server Developer Edition for that matter) and SQL Management Studio for free, and most Office suites can make calls to that.  Anyone that actually needs a database (as opposed to a multi-sheet spreadsheet document) will be looking that direction anyways.

Desktop "databases" are utter trash though.  Leave it at an XML-compatible spreadsheet application and call it good. 

"But whether the Constitution really be one thing, or another, this much is certain - that it has either authorized such a government as we have had, or has been powerless to prevent it. In either case, it is unfit to exist."
--Lysander Spooner

I reject your authoritah!

zxcvbob

  • friend
  • Senior Member
  • ***
  • Posts: 12,240
Re: Need a simple database for Windows 10
« Reply #10 on: March 17, 2020, 03:39:28 PM »
I thought Symphony had a database, but they must have removed it -- probably the same time they removed importing Lotus Word Pro documents.  I think I would still install Symphony, Chrome, Firefox, VLC media player, and Adobe Acrobat Reader, and call it good.  Anyone actually using a database will want their own, like maybe MySQL.
"It's good, though..."

lee n. field

  • friend
  • Senior Member
  • ***
  • Posts: 13,579
  • tinpot megalomaniac, Paulbot, hardware goon
Re: Need a simple database for Windows 10
« Reply #11 on: March 17, 2020, 04:06:35 PM »

You can also install Microsoft's SQLExpress engine (or SQL Server Developer Edition for that matter) and SQL Management Studio for free, a


There you go, Hawkmoon.  Express is free, and Joe User is unlikely to hit the limits of Express.
In thy presence is fulness of joy.
At thy right hand pleasures for evermore.

cordex

  • Administrator
  • Senior Member
  • *****
  • Posts: 8,626
Re: Need a simple database for Windows 10
« Reply #12 on: March 17, 2020, 05:06:46 PM »
There you go, Hawkmoon.  Express is free, and Joe User is unlikely to hit the limits of Express.
But Microsoft SQL Server Management Studio doesn't have the ribbon menu ...

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Re: Need a simple database for Windows 10
« Reply #13 on: March 18, 2020, 01:59:57 AM »
The kind of people who are going to buy a 15+ year old computer are not people who want or need MySQL -- or who even know what it is. This was a business-grade computer when I bought it, but that was a very long time ago. The likely market is either elderly folks (ouch, how it hurts to type that), or a family on a very tight budget who can't afford something new. I expect their database needs would be on the order of an address book, a Christmas card list, maybe some sort of home inventory. Nothing business-related or "enterprise-grade."
- - - - - - - - - - - - -
100% Politically Incorrect by Design

zxcvbob

  • friend
  • Senior Member
  • ***
  • Posts: 12,240
Re: Need a simple database for Windows 10
« Reply #14 on: March 18, 2020, 08:31:18 AM »
That sounds like you want Microsoft Works.
"It's good, though..."

Ben

  • Administrator
  • Senior Member
  • *****
  • Posts: 46,049
  • I'm an Extremist!
Re: Need a simple database for Windows 10
« Reply #15 on: March 18, 2020, 08:31:52 AM »
The kind of people who are going to buy a 15+ year old computer are not people who want or need MySQL -- or who even know what it is. This was a business-grade computer when I bought it, but that was a very long time ago. The likely market is either elderly folks (ouch, how it hurts to type that), or a family on a very tight budget who can't afford something new. I expect their database needs would be on the order of an address book, a Christmas card list, maybe some sort of home inventory. Nothing business-related or "enterprise-grade."

Elderly? They must be 1000 years old if they plan on using a database prg as an address book.  :lol:
"I'm a foolish old man that has been drawn into a wild goose chase by a harpy in trousers and a nincompoop."

K Frame

  • friend
  • Senior Member
  • ***
  • Posts: 44,369
  • I Am Inimical
Re: Need a simple database for Windows 10
« Reply #16 on: March 18, 2020, 08:34:31 AM »
"I expect their database needs would be on the order of an address book, a Christmas card list, maybe some sort of home inventory. Nothing business-related or "enterprise-grade."


Yeah... that's where an Excel-type spreadsheet would shine.

None of the learning curve of an actual database type program and more than flexible enough for any of those applications.
Carbon Monoxide, sucking the life out of idiots, 'tards, and fools since man tamed fire.

Ben

  • Administrator
  • Senior Member
  • *****
  • Posts: 46,049
  • I'm an Extremist!
Re: Need a simple database for Windows 10
« Reply #17 on: March 18, 2020, 08:38:16 AM »
"I expect their database needs would be on the order of an address book, a Christmas card list, maybe some sort of home inventory. Nothing business-related or "enterprise-grade."


Yeah... that's where an Excel-type spreadsheet would shine.

None of the learning curve of an actual database type program and more than flexible enough for any of those applications.

Yes. My non-snarky response is all those things can be done in Excel, Word, or the LibreOffice equivalents, including mailing label or envelope printing, and much more easily and intuitively than in a full blown database. Or there are a bajillion freeware prgs that will do that stuff for you. Not to mention the Gazoogles and smart phones.
"I'm a foolish old man that has been drawn into a wild goose chase by a harpy in trousers and a nincompoop."

lee n. field

  • friend
  • Senior Member
  • ***
  • Posts: 13,579
  • tinpot megalomaniac, Paulbot, hardware goon
Re: Need a simple database for Windows 10
« Reply #18 on: March 18, 2020, 08:52:00 AM »
That sounds like you want Microsoft Works.

Which is long gone. * 

"Office 2010 Starter Edition" replaced it in bundled software category, and that didn't last very long either.

---edit to add---

*and didn't have the "ribbon interface", which, I gather, is something MS patented.

« Last Edit: March 18, 2020, 11:36:12 AM by lee n. field »
In thy presence is fulness of joy.
At thy right hand pleasures for evermore.

zxcvbob

  • friend
  • Senior Member
  • ***
  • Posts: 12,240
Re: Need a simple database for Windows 10
« Reply #19 on: March 18, 2020, 08:54:19 AM »
Which is long gone. 

"Office 2010 Starter Edition" replaced it in bundled software category, and that didn't last very long either.


I think Works is still available for free download at places like CNET.
"It's good, though..."

lee n. field

  • friend
  • Senior Member
  • ***
  • Posts: 13,579
  • tinpot megalomaniac, Paulbot, hardware goon
Re: Need a simple database for Windows 10
« Reply #20 on: March 18, 2020, 11:41:44 AM »
I think Works is still available for free download at places like CNET.

Euuu!  No. 

Just die, MS Works.  Proprietary default format, no real reason for its continued existence, with better free alternatives available.

In thy presence is fulness of joy.
At thy right hand pleasures for evermore.

AZRedhawk44

  • friends
  • Senior Member
  • ***
  • Posts: 13,972
Re: Need a simple database for Windows 10
« Reply #21 on: March 18, 2020, 11:46:24 AM »
I don't get the positive reviews the Ribbon interface has for some people.

It takes up more room, reduces the number of options you have on screen, and hides lots of options from conventional access.  It's every bit as awful as the smart/adaptive start menu that was introduced in Win98 and the evolution to a double-tier start menu in XP.  Bigger fonts and pictures that bias functionality or applications.

I use MS Office on my work computer because our company's product integrates with it, but on my personal computers I favor LibreOffice.
"But whether the Constitution really be one thing, or another, this much is certain - that it has either authorized such a government as we have had, or has been powerless to prevent it. In either case, it is unfit to exist."
--Lysander Spooner

I reject your authoritah!

WLJ

  • friends
  • Senior Member
  • ***
  • Posts: 28,353
  • On Patrol In The Epsilon Eridani System
Re: Need a simple database for Windows 10
« Reply #22 on: March 18, 2020, 11:52:46 AM »
View -> User Interface -> Tabbed
In LibreOffice to switch to a ribbon type menu
 
"Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us".
- Calvin and Hobbes

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Re: Need a simple database for Windows 10
« Reply #23 on: March 18, 2020, 12:48:41 PM »
Quote from: AZRedhawk44
I don't get the positive reviews the Ribbon interface has for some people.

I agree completely. I keep Office 2003 on my computers, along with Office 2010, 2013, or 2016 (some of each -- I have too many notebook computers to buy multiple licenses for, so I keep using the old family packs of Office 2010 Home & Student). I hate the ribbon interface. I can't find anything.

I also didn't know that Libre Office offers it as an option. The reason I want the ribbon available on the machine I'm gearing up to sell is that some people may want it. I've read numerous reviews of various programs in which the reviewers complain when a program has an "antiguated" (conventional) menu system.
- - - - - - - - - - - - -
100% Politically Incorrect by Design

Hawkmoon

  • friend
  • Senior Member
  • ***
  • Posts: 27,273
Re: Need a simple database for Windows 10
« Reply #24 on: March 18, 2020, 12:59:33 PM »
View -> User Interface -> Tabbed
In LibreOffice to switch to a ribbon type menu
 

Not an option in release 6.1.6.3, which I believe is the most recent stable version. Are you in the power user channel?
- - - - - - - - - - - - -
100% Politically Incorrect by Design