Go Back  Bike Forums > The Lounge > Foo
Reload this Page >

Database for at-home use

Notices
Foo Light hearted off-topic chit chat with no general subject.

Database for at-home use

Old 12-14-12, 01:21 PM
  #26  
ModoVincere
Riding Heaven's Highways on the grand tour
 
ModoVincere's Avatar
 
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.
__________________
1 bronze, 0 silver, 1 gold
ModoVincere is offline  
Old 12-14-12, 01:22 PM
  #27  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,109

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 273 Post(s)
Liked 19 Times in 16 Posts
Originally Posted by jsharr View Post
I suggest FileMaker. It is the bees knees.
*crack*
__________________
--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
bigbenaugust is offline  
Old 12-14-12, 02:11 PM
  #28  
somedood
Senior Member
 
somedood's Avatar
 
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 View Post
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.
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.
somedood is offline  
Old 12-14-12, 02:14 PM
  #29  
jsharr
You Know!? For Kids!
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,165

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 11 Post(s)
Tagged: 0 Thread(s)
Quoted: 35 Post(s)
Liked 15 Times in 15 Posts
Originally Posted by bigbenaugust View Post
*crack*
https://www.filemaker.com/
__________________
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 View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 12-14-12, 02:20 PM
  #30  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,109

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 273 Post(s)
Liked 19 Times in 16 Posts
Originally Posted by somedood View Post
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.
I usually just get frustrated with the Query Builder interface in either one and go straight for the SQL View.

Originally Posted by jsharr View Post
Would you please keep the F-word out of this discussion?
__________________
--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
bigbenaugust is offline  
Old 12-14-12, 09:10 PM
  #31  
bjtesch
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 View Post
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

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.
bjtesch is offline  
Old 12-14-12, 09:24 PM
  #32  
Couch
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 View Post
Eh, just use SAP (FI)

:-p
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
Couch is offline  
Old 12-15-12, 09:04 AM
  #33  
jsharr
You Know!? For Kids!
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,165

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 11 Post(s)
Tagged: 0 Thread(s)
Quoted: 35 Post(s)
Liked 15 Times in 15 Posts
Originally Posted by Couch View Post
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
How does it compare to other products currently on the market, like Photoshop or Filemaker?
__________________
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 View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 12-15-12, 09:12 AM
  #34  
wphamilton
Senior Member
 
wphamilton's Avatar
 
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 View Post
Download the free VB version and build your own front end....sheesh.
Correct answer. Because "
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.
wphamilton is offline  
Old 12-15-12, 10:02 AM
  #35  
Alfster 
long time visiter
Thread Starter
 
Alfster's Avatar
 
Join Date: Oct 2005
Location: in the Northern Tundra
Posts: 654

Bikes: 2005 Trek 6700 disc 2007 Orbea Onix 2009 Raleigh One Way

Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 33 Post(s)
Liked 1 Time in 1 Post
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
Alfster is offline  
Old 12-15-12, 10:22 AM
  #36  
wphamilton
Senior Member
 
wphamilton's Avatar
 
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.
wphamilton is offline  
Old 12-15-12, 10:37 AM
  #37  
apclassic9
Caustic Soccer Mom
 
apclassic9's Avatar
 
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.
apclassic9 is offline  

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


Thread Tools
Search this Thread

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

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