Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
MySQL & free databases
Old 02-13-2015, 06:13 PM   #1
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
MySQL & free databases

I probably shouldn't have tried this on Friday the 13th, but I was feeling brave, so...

I wanted a free database to install and use on my old Windows Vista SP2 desktop. From my experience while working, the DB experts there chose MySQL (it handled a whole lot of data generated there, so it seemed a reasonable choice to me).

I first tried downloading/installing the default but it kept failing, specifically on the MySQL Workbench, which is a graphical interface to the thing. I really wanted that, as I am no database wizard.

Trial and error led me to an installation that seems to work: install latest MySQL community base, but omit the most recent Workbench and instead use an earlier release (6.1 CE).

That was enough for a bit of an afternoon, now I just have to create a database and populate it with data. My goal is to store the media I own on a purely local basis, hopefully this will provide a good free infrastructure.
__________________

__________________

steelyman is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 02-13-2015, 06:41 PM   #2
Recycles dryer sheets
 
Join Date: Apr 2005
Posts: 163
As somebody who has to deal with MySQL on a regular basis, I recommend Postgres. (The grass is always greener, etc, but googling for "mysql sucks" vs "postgres sucks" suggests that more people dislike MySQL.)
__________________

__________________
nuisance is offline   Reply With Quote
Old 02-13-2015, 07:32 PM   #3
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
That's a sampling strategy I did not think of using!

Well, I will try it out in my little playground and see how it goes.

To clarify, I meant metadata about the media, not the media itself. Things like CDs, songs, artists, composers, and so on. Extend that beyond music and it is interesting (to me, anyway).
__________________

steelyman is offline   Reply With Quote
Old 02-13-2015, 07:34 PM   #4
Thinks s/he gets paid by the post
sengsational's Avatar
 
Join Date: Oct 2010
Posts: 3,844
Whatever you go wirh, at least change the default admin password. And I'd change the port numbers too.
__________________
sengsational is offline   Reply With Quote
Old 02-13-2015, 07:37 PM   #5
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
Quote:
Originally Posted by sengsational View Post
Whatever you go wirh, at least change the default admin password. And I'd change the port numbers too.

Gotcha, that's a good idea. I disabled TCP/IP, so I hope that means I didn't hide the key under the welcome mat.
__________________

steelyman is offline   Reply With Quote
Old 02-13-2015, 07:53 PM   #6
Thinks s/he gets paid by the post
sengsational's Avatar
 
Join Date: Oct 2010
Posts: 3,844
My experience comes from using a database to power a web app. So I had my router configured to pass unsolicited packets to the subject machine. I'm not sure what I sent out, but the Chinese were pounding on the default ports within a day.
__________________
sengsational is offline   Reply With Quote
Old 02-13-2015, 08:00 PM   #7
Recycles dryer sheets
 
Join Date: Apr 2005
Posts: 163
Looking around even more, sqlite might be a more suitable database. It's a lot lighter-weight than mysql/postgres, and if you don't need something with really high performance then it should be fine.
DB Browser for SQLite appears to have a reasonable Windows GUI for it. (That's all you need to download, since sqlite doesn't run as a stand-alone server.)
__________________
nuisance is offline   Reply With Quote
Old 02-13-2015, 08:03 PM   #8
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
Quote:
Originally Posted by sengsational View Post
My experience comes from using a database to power a web app. So I had my router configured to pass unsolicited packets to the subject machine. I'm not sure what I sent out, but the Chinese were pounding on the default ports within a day.

That would make for an unhappy Steely-day, for sure.

The beauty of this for me is, like many things when ER'd, there is no deadline and no customers! I'll probably spend weeks thinking of what would be nice to include (e.g., "What charts do I have of songs written by Cole Porter?") and how to represent it.
__________________

steelyman is offline   Reply With Quote
Old 02-13-2015, 08:10 PM   #9
Thinks s/he gets paid by the post
sengsational's Avatar
 
Join Date: Oct 2010
Posts: 3,844
I'm signed up for this one, which will be the first real coding I've done in a year: https://www.coursera.org/course/androidpart1
__________________
sengsational is offline   Reply With Quote
Old 02-13-2015, 08:24 PM   #10
Thinks s/he gets paid by the post
 
Join Date: Feb 2014
Posts: 1,050
I thought most of the mySQL crew left and made MariaDB in its place.

https://mariadb.org/

Don't know how good it is. I was a MS Access / MS SQL Server programmer in Megacorp.
__________________
jim584672 is offline   Reply With Quote
Old 02-13-2015, 09:08 PM   #11
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Quote:
Originally Posted by steelyman View Post
... I'll probably spend weeks thinking of what would be nice to include (e.g., "What charts do I have of songs written by Cole Porter?") and how to represent it.
As I was digitizing my CDs and some LPs, I thought it was great that I could bring up any tune or album or artist in seconds from the database within the music player app.

But then I was disappointed in what I couldn't do. I was really hoping that each song would have much more meta-data, like who plays what on each track, producers, engineer, composer, etc. I really wanted to do things like - bring up everything with so and so - I'm often amazed who is playing back-up on some other album. LPs had a lot of this info, CD usually less.

I decided just doing a web search when listening was the best I was going to do w/o a lot of work. It would be nice if places like CDDB had far more data. Maybe there is something out there I'm not aware of?

-ERD50
__________________
ERD50 is online now   Reply With Quote
MySQL & free databases
Old 02-13-2015, 09:26 PM   #12
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
MySQL & free databases

Quote:
Originally Posted by ERD50 View Post
But then I was disappointed in what I couldn't do. I was really hoping that each song would have much more meta-data, like who plays what on each track, producers, engineer, composer, etc. I really wanted to do things like - bring up everything with so and so - I'm often amazed who is playing back-up on some other album. LPs had a lot of this info, CD usually less.

I decided just doing a web search when listening was the best I was going to do w/o a lot of work. It would be nice if places like CDDB had far more data. Maybe there is something out there I'm not aware of?

Yes, in the area of recorded music the possibilities seem endless. But I am willing to try a roll-my-own. It's not due tomorrow, after all!

I am expecting a few new CDs to arrive soon. If this were all set up, it should be easy to add a few new records. But it's not set up yet
__________________

steelyman is offline   Reply With Quote
Old 02-13-2015, 09:45 PM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Quote:
Originally Posted by steelyman View Post
Yes, in the area of recorded music the possibilities seem endless. But I am willing to try a roll-my-own. It's not due tomorrow, after all!

I am expecting a few new CDs to arrive soon. If this were all set up, it should be easy to add a few new records. But it's not set up yet

I'll guess the answer will be "but that's no fun", but... what about the database apps in the Office suites, like LibreOffice Base?


-ERD50
__________________
ERD50 is online now   Reply With Quote
MySQL & free databases
Old 02-13-2015, 10:00 PM   #14
Thinks s/he gets paid by the post
steelyman's Avatar
 
Join Date: Feb 2011
Location: Triangle
Posts: 3,218
MySQL & free databases

Quote:
Originally Posted by ERD50 View Post
I'll guess the answer will be "but that's no fun", but... what about the database apps in the Office suites, like LibreOffice Base?

That's one reason I come here: enthusiastic encouragement!

At this point, I am wide open to alternatives, front/back ends. That's one reason for the thread. But it has to be free, with the data itself transportable if possible. I am a Winvictim currently by circumstance.
__________________

steelyman is offline   Reply With Quote
Old 02-13-2015, 10:09 PM   #15
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Quote:
Originally Posted by steelyman View Post
That's one reason I come here: enthusiastic encouragement!

At this point, I am wide open to alternatives, front/back ends. That's one reason for the thread. But it has to be free, with the data itself transportable if possible. I am a Winvictim currently by circumstance.
I haven't played with the Office Suite databases ( I did some work with a BIG SQL database at MegaCorp in the 90's, but mostly managing the team that worked on it, though I was able to do some queries and write a few scripts to check on things that I didn't want to bother them to create a report), but since the LibreOffice is all about open document formats (and free!), I assume the files are as transportable as any.


-ERD50
__________________
ERD50 is online now   Reply With Quote
Old 02-14-2015, 05:27 AM   #16
Thinks s/he gets paid by the post
bUU's Avatar
 
Join Date: Dec 2012
Location: Georgia
Posts: 1,914
Quote:
Originally Posted by nuisance View Post
As somebody who has to deal with MySQL on a regular basis, I recommend Postgres. (The grass is always greener, etc, but googling for "mysql sucks" vs "postgres sucks" suggests that more people dislike MySQL.)
There are roughly 5-6 times more MySQL users than Postgres users, so if you see anything less than 5-6 times as many complaints about MySQL then that means MySQL is better. Beyond that, there is a secondary effect of popularity that that logic doesn't reveal: Given the same frequency of problems between the two database platforms, the fact that there are 5-6 times more MySQL users means that you have that much more chance of finding a solution to any problem you have, or you find such solutions 5-6 times more readily, if such a solution exists.
__________________
bUU is offline   Reply With Quote
Old 02-14-2015, 06:09 AM   #17
Thinks s/he gets paid by the post
JoeWras's Avatar
 
Join Date: Sep 2012
Posts: 2,531
Sheesh, this sounds too much like w*rk!

I spent a bit of time with both MySQL and Postgres at w*rk over the last year. We settled on MySQL for what it is worth.

Neither are trivial to use. Steelyman, you have nerves of steel to attempt such a project. I tip my hat to you.
__________________
JoeWras is offline   Reply With Quote
Old 02-14-2015, 08:13 AM   #18
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,709
Rather than installing locally, you could install and develop on a cheap Web hosting account. There are pros and cons, but you're ready to roll in short order.
__________________
target2019 is offline   Reply With Quote
Old 02-14-2015, 08:28 AM   #19
Recycles dryer sheets
 
Join Date: Jan 2008
Posts: 385
Quote:
Originally Posted by jim584672 View Post
I thought most of the mySQL crew left and made MariaDB in its place.

https://mariadb.org/

Don't know how good it is. I was a MS Access / MS SQL Server programmer in Megacorp.
My linux distro automatically converted my local mySQL db to MariaDB and I haven't noticed a single difference. So far it's 100% compatible with the mySQL db that I use on a web host. (I develop locally in MariaDB before implementing those changes on a public website which uses mySQL).
__________________
JoeDreaming is offline   Reply With Quote
Old 02-14-2015, 09:04 AM   #20
Thinks s/he gets paid by the post
 
Join Date: Mar 2010
Location: Kerrville,Tx
Posts: 2,724
Quote:
Originally Posted by steelyman View Post
I probably shouldn't have tried this on Friday the 13th, but I was feeling brave, so...

I wanted a free database to install and use on my old Windows Vista SP2 desktop. From my experience while working, the DB experts there chose MySQL (it handled a whole lot of data generated there, so it seemed a reasonable choice to me).

I first tried downloading/installing the default but it kept failing, specifically on the MySQL Workbench, which is a graphical interface to the thing. I really wanted that, as I am no database wizard.

Trial and error led me to an installation that seems to work: install latest MySQL community base, but omit the most recent Workbench and instead use an earlier release (6.1 CE).

That was enough for a bit of an afternoon, now I just have to create a database and populate it with data. My goal is to store the media I own on a purely local basis, hopefully this will provide a good free infrastructure.
Given that you chose a vista machine it is suprising that the current version works. Windows has changed a bit since then, and current versions of the database and in particular the gui likley assume windows 7 or better.
So for the gui it is not surprising you had to go back a few versions.
__________________

__________________
meierlde is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Family & money & death & paperwork Khan Other topics 10 12-30-2009 10:47 AM
When in dist. mode- reinvest div & int & sell shares or take div & int in cash? cashflo2u2 FIRE and Money 12 12-11-2008 04:25 PM
Ruh-roh-- Hurricanes Jova & Kenneth & Lidia & ... Nords Other topics 3 09-18-2005 05:55 PM

 

 
All times are GMT -6. The time now is 05:02 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.