Where can I find a secure, free database?

Apikoros18 November 21, 2012

My wife is a social worker, but not technically savvy. She needs an easy to use database, free, that is exceptionally secure. She wants to be able to sort 60+ groups, with 25 clients or so per group, and be able to enter who is where and when, than have that searchable with reports.

Ideas for a tool to suggest to her?

  1. dragonmouth
    January 30, 2013 at 10:45 pm

    The database will be only as secure as the computer it is installed/used on. If the computer is not secure, the data will not be secure.

  2. Vishal Srivastava
    December 13, 2012 at 4:49 pm

    SQL or Microsoft Access

  3. Rohit Pandey
    December 6, 2012 at 4:39 pm

    ORACLE is in best of all.......
    except that you can try sql,mysql..etc

  4. Sathya Murthy
    November 30, 2012 at 4:31 am

    Try either to use MS Access or use Mysql. It works well

  5. Aniket Singh
    November 29, 2012 at 11:51 am

    tery Oracle 11G Express Edition...

  6. softwaredemons
    November 28, 2012 at 9:15 am

    My SQL is my choice for security reasons

  7. Abba Jee
    November 27, 2012 at 1:21 pm

    hmm secure and free , i guess you need to download MYSQL

  8. Economatix
    November 27, 2012 at 7:31 am

    A bit (!!) late into this, but hey-ho-here-we-go.

    Lock it up:
    Concerning "exceptionally secure" you can't do better than TrueCrypt (http://www.truecrypt.org/) as @shawn recommended. Create an encrypted container, lock it down with a TRUE secure password (like a mangled sentence complete with characters) and I defy anyone to access the contents.

    Where to store it?
    Once again as @shawn commented, if the db is on a laptop it can still be lost if the laptop is stolen. While encrypting an entire partition (or an entire drive) is a recommended thing to do ANYWAY, true defense is "defense in depth" which consists of "layering" your defenses. You might want to consider installing dropbox. A free account gives you 2GB (I've read that it's been increased to 5GB but can't personally confirm that). Now dropbox installs a folder on your local hard drive. Whatever is in that folder is instantly sync'd to "The Cloud" (their datacenter storage cluster). The benefit of this approach is that IF the laptop was stolen or damaged, there's a copy of the dataset available. Additionally, if you have a desktop and laptop, data can be accessed and updated from either location. Even if a laptop isn't in the picture, I'd still go with a Dropbox approach. Hard drives on desktops also die - usually when you least expect it!

    So now you have:
    a) a TrueCrypt container, encrypted and locked down with a strong password. Store anything you like within that container. The database is just one such application which could store its payload inside a .tc file. The same applies to documents, images, and so on. The list is infinite.
    b) which is sync'd to a datacenter server, and accessible from your other "authorized devices"
    c) with whatever password schema is already part of your database application

    Now that's a robust implementation of both storage AND security in one.

    Now talking about the database itself for a moment. As other responders have commented, there are a large number of free database applications out there. Without further details concerning the "platform" (Operating System) available, or what other software is installed on the laptop/desktop, it's tough to give an outright recommendation. IF Microsoft Office is already installed, consider using MS Access. It's a capable tool and will most definitely do what you need. ALL database applications have a learning curve, and some more than others. Access is about the most straightforward, and has a TRAINLOAD of documentation available - plus a number of pre-made database templates which could be adapted to the stated purpose.

    The "free toolkit" at your disposal is large and growing almost daily, so there's no shortage of methods and tools available.

    Please post back when you find a combination that works best for you, describe what you did, and mark as "Resolved" so that others may take advantage of the approaches which have been discussed. If you have questions concerning implementation, throw 'em out here. Someone will be happy to help if you get stuck.

    Good luck!!

  9. atul mahajan
    November 24, 2012 at 3:21 pm

    You should try MYSQL .
    it is quite simple to use.
    you can find it here: http://www.mysql.com

  10. Mangesh Kharche
    November 24, 2012 at 2:58 am

    GreenSQL Express FREE Database Security.

  11. Mangesh Kharche
    November 24, 2012 at 2:58 am
  12. Ashish Yadav
    November 23, 2012 at 6:21 am

    A good SQLite cleint.

  13. Ashish Yadav
    November 23, 2012 at 6:13 am

    Use SQLITE database if it satisfy needs it is lightweight and secure. Personally I don't see need of Oracle here as it's too complicated for trivial use. You can use TruceCrypt to create containers to store databases for additional security.

  14. Chuck juhl
    November 22, 2012 at 8:56 pm

    Why don't you just ask for a winning Powerball ticket to go with that? Seriously. You want all that and you want it "Free"? Was Romney right - half of America just wants free stuff?

    • Rajaa Chowdhury
      November 24, 2012 at 1:17 am

      Reserve your comments till you see Kolkata, West Bengal, India. Half of America only wants free stuff, whereas here in Kolkata, they do not even believe that software and solutions can be a priced service, everyone wants free stuff. Was a IT marketing guy at Kolkata, India for 22 years, was the most frustrating ordeal I went through in my life. The people wants best IT solution at no price. This question will seem trivial against those demands, if you have ever heard. :)

  15. shawn
    November 22, 2012 at 8:36 pm

    from the sound of it she is already using some thing like MS Access which has limited builtin encryption. if its in case your laptop gets stolen you might want to look at your bios support for full drive encryption after which additional is not really needed. or something like true crypt which creates and encrypted space that you can store anything in and is extremely hard to crack.


  16. Nikhil Chandak
    November 22, 2012 at 2:31 pm

    check out this link
    free database software - http://www.microsoft.com/en-in/sqlserver/editions/express.aspx
    the same but more about SQL software - http://www.microsoft.com/web/platform/database.aspx
    this may help u out

  17. Alan Wade
    November 22, 2012 at 11:52 am

    If you are using MS Office, you have the tools at your hands. If you are usin Open Office, yes the tools are there.
    To design a speadsheet or an Access database is fairly simple with loads and loads of help on the internet and in this forum.

    • Amit Sinha
      November 26, 2012 at 4:48 pm

      Creating databases on MS Access or MySQL or Oracle require some basic knowledge of databases, As per the details written by the above user it can be achieved by MS Excel too and encrypting with password can make it secure.
      Do you think that any one can create databases on any platform and interact with other software.

  18. Rob Hindle
    November 22, 2012 at 10:26 am

    The responses so far recommend a database product. Fair enough but the database is merely a tool like a programming language, what she needs is an application written using that tool but you write " ...not technically savvy...". Is there someone to write the application for her? Look at the Oracle userguide, it's fine for technically savvy users (and comparable with other databases) but anyone else is facing a big learning curve.

    In similar vein you write "...that is exceptionally secure...". Again this is not so much a feature of the database itself but the way it's implemented and used. Poor password policy and you're sunk.
    Worse still, users who don't understand how important password security is. Recently I was in a customer's office and could see a yellow post-it note stuck to the side of their PC listing their passwords. In another business I was asked to change the password on a system to be "the same easy to remember password everyone in the office uses for all their other passworded systems".
    And 2 weeks ago I was asked to urgently update the logons and passwords somewhere else because they'd fired an employee, she'd already defaced their web-site and she had everyone's email passwords...

    One of the recent UK Government lost data scandals was that someone needed some data from a secure database so a user just dumped the contents to CD and put it in the post totally unencrypted.

    And then there are the hackers trying to find technical weaknesses they can exploit to get into the system.

    So what she really needs is a developer with an in depth understanding of the specific database product, any computer language used to provide a better user interface and, in particular, the security environment. And she needs total confidence that everyone using the system has a full grasp of the security issues.

    And she wants that free... Good luck!

  19. Aswin Kumar K P
    November 22, 2012 at 4:57 am

    Oracle 11G Express Edition will be the better choice.

  20. Rajaa Chowdhury
    November 22, 2012 at 2:16 am

    You can try Oracle 11G Express Edition in that case. It is totally free, a very capable RDBMS and supports multiple platforms with multiple front -end environments. http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

Ads by Google