Good, cheap, customizable database program?

Started by Syt, June 18, 2011, 06:30:29 AM

Previous topic - Next topic

Syt

What the program should be able to do:

- customize/define what fields I want to capture
- is possible, have different categories of data sets in one database (e.g. people, places, organizations ...)
- allow to crossreference/tag entries

I know I could do all that in Excel, but I don't find Excel works well for administrating data beyond a certain size.
We are born dying, but we are compelled to fancy our chances.
- hbomberguy

Proud owner of 42 Zoupa Points.

Baron von Schtinkenbutt


Syt

We are born dying, but we are compelled to fancy our chances.
- hbomberguy

Proud owner of 42 Zoupa Points.

Norgy

http://www.firebirdsql.org/

Firebird is open source and if not fantastic, at least relatively useful.


viper37

Quote from: Syt on June 18, 2011, 06:30:29 AM
What the program should be able to do:

- customize/define what fields I want to capture
- is possible, have different categories of data sets in one database (e.g. people, places, organizations ...)
- allow to crossreference/tag entries

I know I could do all that in Excel, but I don't find Excel works well for administrating data beyond a certain size.
Access + http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

If you don't have Access in your Office version, it can be bought for a decent price, seperated from the rest, if you dig a little.

Of your could use LibreOffice's database with Microsoft SQL Server Express.  100% free.
I don't do meditation.  I drink alcohol to relax, like normal people.

If Microsoft Excel decided to stop working overnight, the world would practically end.

Zanza

Quote from: viper37 on June 20, 2011, 09:37:01 AM
Quote from: Syt on June 18, 2011, 06:30:29 AM
What the program should be able to do:

- customize/define what fields I want to capture
- is possible, have different categories of data sets in one database (e.g. people, places, organizations ...)
- allow to crossreference/tag entries

I know I could do all that in Excel, but I don't find Excel works well for administrating data beyond a certain size.
Access + http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

If you don't have Access in your Office version, it can be bought for a decent price, seperated from the rest, if you dig a little.

Of your could use LibreOffice's database with Microsoft SQL Server Express.  100% free.
Installing a server that needs half a gig of RAM all the time and makes Windows start up slower is a bit over the top when all you need is a simple desktop database.

Grey Fox

Quote from: Zanza on June 20, 2011, 10:58:40 AM
Quote from: viper37 on June 20, 2011, 09:37:01 AM
Quote from: Syt on June 18, 2011, 06:30:29 AM
What the program should be able to do:

- customize/define what fields I want to capture
- is possible, have different categories of data sets in one database (e.g. people, places, organizations ...)
- allow to crossreference/tag entries

I know I could do all that in Excel, but I don't find Excel works well for administrating data beyond a certain size.
Access + http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

If you don't have Access in your Office version, it can be bought for a decent price, seperated from the rest, if you dig a little.

Of your could use LibreOffice's database with Microsoft SQL Server Express.  100% free.
Installing a server that needs half a gig of RAM all the time and makes Windows start up slower is a bit over the top when all you need is a simple desktop database.

It's still cheap tho.
Getting ready to make IEDs against American Occupation Forces.

"But I didn't vote for him"; they cried.

viper37

Quote from: Zanza on June 20, 2011, 10:58:40 AM
Quote from: viper37 on June 20, 2011, 09:37:01 AM
Quote from: Syt on June 18, 2011, 06:30:29 AM
What the program should be able to do:

- customize/define what fields I want to capture
- is possible, have different categories of data sets in one database (e.g. people, places, organizations ...)
- allow to crossreference/tag entries

I know I could do all that in Excel, but I don't find Excel works well for administrating data beyond a certain size.
Access + http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

If you don't have Access in your Office version, it can be bought for a decent price, seperated from the rest, if you dig a little.

Of your could use LibreOffice's database with Microsoft SQL Server Express.  100% free.
Installing a server that needs half a gig of RAM all the time and makes Windows start up slower is a bit over the top when all you need is a simple desktop database.
That's what I use at the office.  It's slower in Vista, ok in Win7 64bit with 8gb ram.
I don't do meditation.  I drink alcohol to relax, like normal people.

If Microsoft Excel decided to stop working overnight, the world would practically end.

Iormlund

Quote from: Grey Fox on June 20, 2011, 11:01:07 AM
It's still cheap tho.
If that's your main concern, PostgreSQL is much better. Not to mention a LOT more capable.

Grey Fox

Quote from: Iormlund on June 21, 2011, 12:43:01 PM
Quote from: Grey Fox on June 20, 2011, 11:01:07 AM
It's still cheap tho.
If that's your main concern, PostgreSQL is much better. Not to mention a LOT more capable.

Yes. Not that I know the program, just that I've seem to be much in love with open source software nowadays.
Getting ready to make IEDs against American Occupation Forces.

"But I didn't vote for him"; they cried.