TechSoup.org The place for nonprofits, charities, and libraries

Databases for small organizations?

Databases for small organizations?

  • I develop database applications for non-profits utilizing Alpha 5 Version 7 software.

    Its very flexible and can be easily customized.

    The software can be purchased through TechSoup.

    We would love to hear from you!
    Regards,
    Bill Terry
    Tri-State Software
    W.C. Terry & Associates
    Tri-State Email:
  • My company Linked Software has provided reasonably priced database software for over 10 years.

    Hope you'll take a look.

    Thanks!

    Lynn Howard
    Linked Softwarewww.linkedsoftware.com
  • When comparing databases, You cant just say I love/hate Access, Filemaker, MySQL, etc, since these area all just DB shells, the true beauty of these is that they are VERY customizable. It all depends on your developer.

    Ive had clients tell me I hate filemaker, blah blah blah, then Ive gone in created a new table, or complete new db and they ve loved it. Ive seen terrible designs with access/FM/MySQL, and good ones too. I also liek to consider than not everyone uses Windows, there are better alternatives. Get a good developer and the difference can be amazing.

    Also when considering local or hosted, remember that anything online is only secure as your password is. And creating a "web based" system does not mean it has to be on the internet, you can host it locally for your network.
  • We are a 60 person all volunteer organization that raises funds through fundraisers and local foundations and individual donors. Our present donor base has about 2000 donors. We are looking for a database that would track our donations as well help with communicating with our donors. Some software is too sophisticated for us and other too costly. We would appreciate any information regarding software that could be run on a PC.
  • arg_51, what is your affiliation with this company?

    Thanks,

    Megan

    Megan Keane

    Follow me on Twitter: @penguinasana or connect with me on my website.

  • I realize I'm bringing this topic back from the dead, but I'm now in a position of finding a way to manage dictation/transcription workflow for my agency and am looking at some online database products to help systematize it all.

    Now that it's been a while, has anyone used any of the solutions previously covered in this thread? Have any feedback on any of them? Know of any other online database products I should look at?

    I'm exploring [Zoho Creator] at the moment and also wondering if anyone has used it and has anything to say about it.

    Dana

  • It seems like everyone absolutely loves Fundraiser Software. Are there any negatives to this donor database system? We are almost ready to purchase this database, but want to make sure we are making a good investment.
  • 2 cents on the online database security issue:

    In my 20 years of non-profit tech work, the orgs I've worked with have not experienced a successful online attack (worms and viruses excepted). They have had people burrowing through walls and taking doors off hinges to steal hardware, as well as having elaborately-locked file cabinets simply carried away (what says "Steal me" more than those large, danger-red bar locks?).

    I think having a database hosted by a trusted vendor where the server is stored in a climate-controlled room, with reinforced walls and biometric entry, and the database subject to professional, periodic online security audits by a third party is a legitimate and maybe preferred, choice.

    That being said, I think studies still show that the vast majority of data loss incidences are own goals. Whether your database is a small desktop system or a web enabled, hosted system, proper training of your users in all aspects of security and using the database is the best preventive measure.
  • We have been using Access since 2003 for - a complex client database ( the heart of our social work business) , a funding/grants system.

    I have used Filemaker and other DB shells but my need now is for rapid application development probably onto a SQL database. I would prefer a web based front end. 

    My main issue is things change, we grow , take on new development etc but it can be very expensive pulling in outside coders to do the work to modify ,add to existing databases or create new solutions.  In my experiance creating the data structure is not such a big task  and one I am more than willing to bring in outside help on - its making the database usable thats the issue , the issue is , the user interface, business logic, interfacing with printers,web,email, calendars and bullet proofing it .

    Are there good rapid application develop tools that can help in this area ?

    Richard Aston

     

     

    Richard Aston CEO Big Buddy www.bigbuddy.org.nz

  • From the perspective of someone who has been intimately involved (Board Member, Volunteer Coordinator, Consultant, Tech Trainer, db developer) with many smaller non-profits as well as being a database developer and web and tech developer/consultant professionally, I think that MaureenBoyle and Blackberg have both put forth advice that is absolutely critical to smoothing a path to success.

    Your success probabilities and return on investment will skyrocket if your planning, needs and outcome identification, workflow mapping and design blueprint are rock solid at the beginning. I have been designing and developing Access databases and data driven websites for 15 years now and the hardest concept for most people to grasp is that the success of the program has to start with defining exactly what it is you want out of the program before you ever start building it, NOT what you want to put into it. If the initial design does not take the full picture into account and all of the exceptions to the rules that seem to be par for the course, you will not have smooth sailing along your course.

    Many of the non-profits I have been involved in are actually pretty complicated little organizations. Unless you really do have folks on board who are experts at this, do yourselves a huge favor and bring someone who really knows database systems in to help you chart a path for the pros and cons of different options based upon what YOUR organization does and (as Maureen points out) will be doing in the upcoming years. If you do your jobs well, you will grow. 

    As Blackberg points out, database programs are shells. Kind of like supplying you a easel, canvas and paint. If you did that to me I would make a very messy job of slopping paint on canvas but in the right hands a priceless piece of art would appear. There is a real art to making a software program easy and effortless for the users and organization to use and be confident that they can rely on. It can be very complicated to make it very simple for the end users. Your staff probably have great talents and skills but I doubt if they are experts in what you need here.

    Access, MySQL, Base, SQL, Alpha 5 are all wonderful programs that can do amazing things in the right hands but are programs where untrained folks tend to create disastrous monsters that eat up  an organizations time and resources vs. making life easy. Whoever develops something successfully for you will pester you to death with detailed questions about all of the arcane ins and outs of your operation. They need to develop in detail the big picture and create a clearly thought out plan before they ever start writing code. 

    If you are considering 'canned' solutions such as many of the web based solutions the key is to make sure that the product is going to be flexible enough and truly fitting for your purposes. If it only covers 40% of what you do, how do you cover or integrate the rest? Many of the are fairly specific in their purposes. Bring in someone who is adept at walking you through this exploratory process. A huge advantage here is if it does fit you can rest assured that the programs were probably developed by professionals and will be maintained by the same. A huge disadvantage is they are what they are and can only be modified within the framework provided. Will you need a combination of solutions? Will they work together?

    There are pre-packaged solutions can also be lumped in the Access, Alpha group too if they are programs that someone has developed for a specific purpose close to what you need. Some are very good and affordable. There are some of these that may allow an experienced programmer modify them a bit to tailor more closely to your model, but many will not.  

    The key here is that you should set sail based on the guidance of an experienced navigator who has experience to help you figure out where you are trying to go, how to create the charts you will need and how to get there most efficiently. Columbus had a great trip, but he never did get where he intended to go.

    Gary Miller
    Gary Miller Computer Services
    EMail
    Sisters, OR

  • How do you feel about Alpha 5 as a database for a small non profit with a staff of 3. I do not know much about databases but I am planning on downloading it and using it to keep track of our mentees and mentors.