Database for at-home use
12-14-12, 01:21 PM
#26
Riding Heaven's Highways on the grand tour
Join Date: Aug 2006
Posts: 1,675
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
If you can find an old version of Symphony, it too has limited database usage. 
of course, you'll have to run it in CMD mode, and probably figure out a way to recompile it with a no wait statement.
of course, you'll have to run it in CMD mode, and probably figure out a way to recompile it with a no wait statement.
__________________
1 bronze, 0 silver, 1 gold
1 bronze, 0 silver, 1 gold
12-14-12, 01:22 PM
#27
always rides with luggage
Originally Posted by jsharr
I suggest FileMaker. It is the bees knees.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
12-14-12, 02:11 PM
#28
Senior Member
Join Date: Dec 2006
Location: UT
Posts: 398
Bikes: Ibex Xray
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Originally Posted by bigbenaugust
Also, both Access and LibreOffice DB have a SQL view for querying. So you enter data as in a spreadsheet, and then you can query it using SQL. If learning SQL is your goal, that might be an easier route.
12-14-12, 02:14 PM
#29
You Know!? For Kids!
Originally Posted by bigbenaugust
*crack*
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
12-14-12, 02:20 PM
#30
always rides with luggage
Originally Posted by somedood
Alfster,this is a great idea. It gives you the benefit of the ease of use from a spreadsheet, which fits your data well, and the felxibility of custom queries w/sql.
Originally Posted by jsharr
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
12-14-12, 09:10 PM
#31
Senior Member
Join Date: Aug 2008
Location: Irving, TX
Posts: 358
Bikes: Schwinn Paramount
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
Originally Posted by Alfster
First off, I've never worked directly with a database program. I want to learn some basics for use at home (basic tracking of financial info, etc), exporting to Excel for creation of charts, etc. Does anyone here work with Databases for home-use? What database program do you use? and more importantly ... is it free? I've starting reading about MySQL, but I'm not sure if it's more than what I need???
I have a week off at Christmas and am hoping to learn how to create and use databases. Sounds like fun ... right
I have a week off at Christmas and am hoping to learn how to create and use databases. Sounds like fun ... right
For tracking of financial info. I would suggest something like Quicken but there are many alternatives. A little google searching will find lots of stuff, or you could just use spreadsheets.
https://www.getrichslowly.org/blog/20...ance-programs/
For other types of databases such as tracking collections or whatever, you can find lots of database programs by searching someplace like cnet for freeware or shareware.
A week isn't enough time to learn how to use real database programs, and a lot more self punishment than you probably deserve.
12-14-12, 09:24 PM
#32
Banned
Join Date: Sep 2010
Posts: 57
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Originally Posted by SonataInFSharp
Eh, just use SAP (FI)
:-p
:-p
JDE is better than SAP.
Couch
12-15-12, 09:04 AM
#33
You Know!? For Kids!
Originally Posted by Couch
I can install JD Edwards 9.1 if you are running 64bit Windows 2008 on three separate VM instances.
JDE is better than SAP.
Couch
JDE is better than SAP.
Couch
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
12-15-12, 09:12 AM
#34
Senior Member
Join Date: Apr 2011
Location: Alpharetta, GA
Posts: 15,280
Bikes: Nashbar Road
Mentioned: 71 Post(s)
Tagged: 0 Thread(s)
Quoted: 2933 Post(s)
Liked 336 Times
in
224 Posts
Originally Posted by ModoVincere
Download the free VB version and build your own front end....sheesh.
First off, I've never worked directly with a database program. I want to learn some basics for use at home (basic tracking of financial info, etc),
Or better yet use something like MS Access for the front end. Or Excel as appropriately as someone mentioned. Rapid development and ease of learning and maintenance.
12-15-12, 10:02 AM
#35
long time visiter
Thread Starter
I think I'm going to try and learn MySQL, mainly because we use a version of it at work. I don't like being in meetings when development of databases are being discussed ... and I haven't got a clue what a query is 
If it's too difficult, I'll try something else.
Btw, I already use Excel, and it's OK, but the purpose is for me to learn about databases. While I don't know too many computer languages ... I used to rock FORTRAN back in the day
If it's too difficult, I'll try something else. Btw, I already use Excel, and it's OK, but the purpose is for me to learn about databases. While I don't know too many computer languages ... I used to rock FORTRAN back in the day
12-15-12, 10:22 AM
#36
Senior Member
Join Date: Apr 2011
Location: Alpharetta, GA
Posts: 15,280
Bikes: Nashbar Road
Mentioned: 71 Post(s)
Tagged: 0 Thread(s)
Quoted: 2933 Post(s)
Liked 336 Times
in
224 Posts
Learning MySQL is worthwhile if you need the knowledge for work. I work professionally with MySQL, Oracle, MSSQL, some others - at one level it's all just SQL with some variations.
For home use, basic tracking of financial information, importing into charts, etc it's not really practical to "use MySQL" (eg, design a query for everything and export) and is going to take more than a couple of weeks to learn. The best approach to learn MySQL for your objectives, in my opinion, would be to go ahead and install the windows LAMP stack on your pc, then install an ODBC connector for MySQL and then use the front end of your choice for your application. You can set up your tables, indexes, import data and so forth directly in MySQL and learn all that stuff, but use more familiar GUI interfaces for designing what you actually want to do with it.
For home use, basic tracking of financial information, importing into charts, etc it's not really practical to "use MySQL" (eg, design a query for everything and export) and is going to take more than a couple of weeks to learn. The best approach to learn MySQL for your objectives, in my opinion, would be to go ahead and install the windows LAMP stack on your pc, then install an ODBC connector for MySQL and then use the front end of your choice for your application. You can set up your tables, indexes, import data and so forth directly in MySQL and learn all that stuff, but use more familiar GUI interfaces for designing what you actually want to do with it.
12-15-12, 10:37 AM
#37
Caustic Soccer Mom
Join Date: Jun 2005
Location: Millstone WV
Posts: 1,761
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 11 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
I would suggest you get a copy of Lotus 123 SmartSuite 9.8 or 9.8.2...available at amazon for @ $30.00. It has Lotus 123 spreadsheet & Approach database - both of which are FAR easier to use than the Excel/Access counterpart!
__________________
As with mud, life, too, slides by.
As with mud, life, too, slides by.
