Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

free database?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

free database?

Old 01-04-04, 09:23 PM
  #1  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
free database?

I'm looking for some free database software. Nothing special. I'd like each entry to have some user-defined fields. I'd like control over the fields and be able to sort entries based on the fields. I don't need any web interfaces or querying or multi-user or anything special.

Any recommendations? I don't have MS Access. I have MS Works and it looks like it has a database function, but I haven't tried it yet.

Thanks in advance!
Old 01-04-04, 10:57 PM
  #2  
DVD Talk Hall of Fame
 
Join Date: Jan 2000
Location: US
Posts: 9,631
Likes: 0
Received 0 Likes on 0 Posts
http://www.mysql.com

Dave
Old 01-04-04, 11:12 PM
  #3  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
It looks like mysql might be a little overkill. Can you run mysql not as a database server? From what little I've looked at it, it doesn't look very user-friendly.

Also, does this page mean that it's not free?
http://www.mysql.com/products/pricing.html
Old 01-04-04, 11:24 PM
  #4  
DVD Talk Hall of Fame
 
Join Date: Jan 2000
Location: US
Posts: 9,631
Likes: 0
Received 0 Likes on 0 Posts
They have different licensing terms, but it is free to anyone who wants to use it. (I think you need a license if you develop a program that uses it, and include it in the application). You can run it on a regular pc, you don't need a server OS, if I read that question right. If this is something basic you need, then the free one in works might be best. Mysql isn't hard to use if you understand SQL, but that can be a steep learning curve.

Dave
Old 01-04-04, 11:43 PM
  #5  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
It looks like mysql is kind of a pain to set up from reading documentation. So, you set it up to always run the server in the background, is that correct? And then individual DBs connect to it?

Are there any GUI wrappers around mysql to make it more user friendly?
Old 01-05-04, 12:22 AM
  #6  
Member
 
Join Date: Jun 2003
Posts: 116
Likes: 0
Received 0 Likes on 0 Posts
Open Office (http://www.openoffice.org/) is a free program very similar to Microsoft Office. It includes an Access-like database program along with a bunch of other MS Office equivalents. I haven't tried it, but it looks just as user friendly as Access.
Old 01-05-04, 12:28 AM
  #7  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
Thanks brilk. I'm using Open Office 1.1 Beta now. It looks like the DB is just kind of half-assed added on and not very robust at all. It keeps crashing on me all the time. I upgraded to OO 1.1.0 and it doesn't even recognize the DB from the beta version. So now I'm looking for something new.
Old 01-05-04, 12:30 AM
  #8  
DVD Talk Hall of Fame
 
Join Date: Jan 2000
Location: US
Posts: 9,631
Likes: 0
Received 0 Likes on 0 Posts
mysql sets up as a service, so it always runs, unless you tell it not to. There is a free gui from mysql (I think it is called myCC, you'll have to track it down on their site. )
There are other gui's, I use this one:
http://www.ems-hitech.com/mymanager
and have used this one:
http://www.navicat.com/product.php3

neither are free however. I think the main one people use is phpmyadmin, however that is a PHP web based admin, which is probably way more effort than you want.

Dave
Originally posted by Beaver
It looks like mysql is kind of a pain to set up from reading documentation. So, you set it up to always run the server in the background, is that correct? And then individual DBs connect to it?

Are there any GUI wrappers around mysql to make it more user friendly?
Old 01-06-04, 10:12 PM
  #9  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
Any other recs? Mysql looks like too much of a project. I'd like something easy to set up and manage, since this will just be a little, for-fun project.

I'm leaning towards MS Works, but there HAS to be something better out there.
Old 01-07-04, 12:20 AM
  #10  
DVD Talk Gold Edition
 
Join Date: Dec 1999
Posts: 2,708
Likes: 0
Received 0 Likes on 0 Posts
What about openoffice.org? Might not yet be much better than Works, but hey, it's free and open source
Old 01-07-04, 01:37 AM
  #11  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by Lampei
What about openoffice.org? Might not yet be much better than Works, but hey, it's free and open source
Like I mentioned in my post above, that is what I'm currently using. But I'm having lots of problems and am looking for something new.
Old 01-07-04, 12:04 PM
  #12  
Banned
 
Join Date: Sep 2003
Location: Chicago, IL
Posts: 994
Likes: 0
Received 0 Likes on 0 Posts
Download the database from oracle.com.
Old 01-12-04, 11:53 PM
  #13  
Senior Member
Thread Starter
 
Join Date: Sep 2001
Posts: 255
Likes: 0
Received 0 Likes on 0 Posts
I finally got OO 1.1.0 to work with my old DB. There are certain things I don't like about it. Looking at things in list view is not very usable. But I may end up keeping it. I also have Book Collectorz and am thinking of modifying that for more general purposes.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.