Results 1 to 6 of 6

Thread: What's a good database for personal use

  1. #1
    Join Date
    Apr 2013
    Location
    Silicon Valley
    Posts
    14

    What's a good database for personal use

    I would like to write a few database applications mainly for personal use. These are not super complex applications, but also not trivial. I am wondering if someone can recommend some good choices for me to look into. These

    I have a little experience with databases (Access) and quite a bit of experience with code (VB, VBA). I have MS Office 2007 and 365.

    Thanks for any suggestions.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use Microsoft SQL Express or MySQL.

  3. #3
    Join Date
    Apr 2013
    Location
    Silicon Valley
    Posts
    14
    I probably didn't state my question very clearly. Let me try again.

    I have MS Office so I have Access. I've fiddled around with it a bit, but now I want to get serious about writing some usable applications. Here are a couple of examples:

    1. Personal library. Keep track of all of my books. There are probably library apps already available, but I'd like to write my own partly as a way of learning database skills.
    2. Product ratings. Keep track of and rate various products that I frequently buy.
    3. Exercise. Keep track of my reps and sets.


    So my question is: Is there something better than Access, which I already have, for my needs? I see a lot of alternatives: MySQL, TeamDesk, Knack, AxisBase, Glom, FileMaker Pro, FireBird, ....

    Are any of these better for my needs than Access?

    One of my criteria is user support. Access has a lot of users and a number of user communities, so getting help is fairly easy.

  4. #4
    Join Date
    Aug 2008
    Location
    Indiana
    Posts
    13
    skhanal's recommendations of Microsoft SQL Express and MySQL are still good. Both of these are popular and you should be able to find pletny of support and help for either on the internet.
    --------------------
    Founder, Lots of Software, LLC
    Site Manager, DatabaseJournal.com.

    ------------

  5. #5
    Join Date
    Sep 2019
    Posts
    1
    Which one of those would you say is more novice-friendly, Brad?

  6. #6
    Join Date
    Sep 2019
    Location
    Washington DC
    Posts
    1
    There are three ways to do database design:

    1- SQL-based databases...try SQLite or MySQL

    2- No SQL-based databases...try MongoDB....it is very easy..

    3- Graph-based databases....It is evolving in data science

    Gradually no-sql databases are getting more popular. However, learning SQL really pays off your investment of time and efforts as it can be used in many databases like IBM, Oracle, MySQL, SAP Hana Microsoft, etc.

    Cheers,

    Matt Zand
    High School Technology Services
    DC Web Makers
    Coding Bootcamps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •