Database Software Recommendation?

by ivana
11 replies
Hi warriors,

I am looking to either outsource some work or get a database software to build my own web based database.

So I have set of questions:

If I outsource, I need 1 main database with all the data and two more, which share partial data from main database.

All three need to have password protection.

The problem is I have limited budget on this, so I am not sure if anyone would do it for that amount which is around $400

my second option is to create it myself. Do you know of any database software that is easy to use? The second option has to stay with in my budget of 400 as well, and while I know I have to spend time on it, I at least will know how it all works

your feedback is greatly appreciate it.
#database #recommendation #software
  • Profile picture of the author seasoned
    You aren't specific enough to get a good answer. First of all, WEB BASED, PASSWORD, SIMPLICITY means probably MYSQL, especially when you figure in cost.

    Because of the way it works, you would want either SEPARATE databases that APPEAR connect via a program, or ONE database. It is generally a bad idea to duplicate data needlessly. BTW, you CAN have an app that accesses different data based on password roles(driven by the application), if THAT is your concern. The database password only needs to be known by the apps accessing it.

    ALSO, it is often possible to have views that are HIGHLY password specific. I BELIEVE MYSQL 5.x(maybe even 4.x) can handle this. I haven't checked. MYSQL has historically stayed away from such things, as views, but oracle tried to kill them and I guess they figured they would try to fight back! Anyway, if it DOES support such table based control, and have views, you could limit access to the actual column based on DATABASE passwords.

    All THAT effectively costs you NOTHING! If someone were to "MODEL" the database, etc... It could cost from perhaps $0-$50 IF you have a good idea of what you want. The program to access it is where the cost would be, and that depends on the complexity of it.

    $400 MIGHT be enough. Then again, it may not be NEARLY enough.

    Steve
    {{ DiscussionBoard.errors[2181613].message }}
    • Profile picture of the author ivana
      Hi Steve, thanks for getting back to me,

      Yes I need someone to model it, and I know exactly what I want, and I have it ready (in terms of fields and so forth even divided by each platform.

      It is one database, but 3 platforms, basically platform #1 has all the data, while the platform two can have an access to input some data and view partial, and third platform mainly view and 2 fields to enter data.

      I had a person who supposed to do it, and since FEB. I worked with him and in the end, his work overload did not allow him to complete, and I need it done in the next month or so.
      {{ DiscussionBoard.errors[2181653].message }}
      • Profile picture of the author seasoned
        Originally Posted by ivana View Post

        Hi Steve, thanks for getting back to me,

        Yes I need someone to model it, and I know exactly what I want, and I have it ready (in terms of fields and so forth even divided by each platform.

        It is one database, but 3 platforms, basically platform #1 has all the data, while the platform two can have an access to input some data and view partial, and third platform mainly view and 2 fields to enter data.

        I had a person who supposed to do it, and since FEB. I worked with him and in the end, his work overload did not allow him to complete, and I need it done in the next month or so.
        If by platform, you basically mean program, with another program to allow security, and it is just basically a CRUD(CReate Update Delete) program, it should have been done by now. Anyway, if that is ALL you want, and you are prepared, $400 will LIKELY be enough. I WOULD suggest laying out the field associations, length, at least GENERAL type(alpha(size), decimal(digits on either side of the decimal), integer, date), needed language, and screen layouts, relations of various fields, and required checks on data entry. Do THAT, and you will be WAY ahead, it may get done faster and at a lower cost.

        Steve
        {{ DiscussionBoard.errors[2181770].message }}
  • Profile picture of the author kiopa
    Banned
    Two quick questions:

    1.) Is it something that can be made into a general package, and sold? In other words, is it a general concept that others would benefit from using, or is it very customized to your specific needs / ideas?

    2.) If yes to above, do you have a contact list / customer base you can push it out to? And the know how to do so?

    If yes to both questions above, drop me a PM, and we'll talk. I can provide some of the highest quality online software you'll find, and all depending, can maybe do it for free for you.

    Thanks,
    Matt
    {{ DiscussionBoard.errors[2181756].message }}
  • What do you want to do?

    That is like saying you want a "big" vehicle... ok... a big vehicle... for hauling dirt? for taking your children to school? to go in a car race?

    But pretty much anything webbased... you'll want a php/mySQL solution. If you just want something easy -- then if someone is using MS technologies -- it is really easy to put together a database (albeit a bit sloppy, but kind of works) in minutes... really depends what you want.

    Originally Posted by ivana View Post

    Hi warriors,

    I am looking to either outsource some work or get a database software to build my own web based database.

    So I have set of questions:

    If I outsource, I need 1 main database with all the data and two more, which share partial data from main database.

    All three need to have password protection.

    The problem is I have limited budget on this, so I am not sure if anyone would do it for that amount which is around $400

    my second option is to create it myself. Do you know of any database software that is easy to use? The second option has to stay with in my budget of 400 as well, and while I know I have to spend time on it, I at least will know how it all works

    your feedback is greatly appreciate it.
    Signature
    Pick a product. Pick ANY product! -> 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
    {{ DiscussionBoard.errors[2181768].message }}
  • Profile picture of the author Michael Mayhew
    Google SugarCRM. Free.
    Signature

    IMO Partnership. A National Insurance Marketing Alliance.
    http://www.imopartnership.com/

    {{ DiscussionBoard.errors[2182381].message }}
  • Profile picture of the author rts2271
    Sugarcrm, vtiger or intuits quickbase.
    {{ DiscussionBoard.errors[2182387].message }}
  • Profile picture of the author seasoned
    I love it. People are representing software that is NOTHING as described, and most is SPECIAL PURPOSE, and they have NO idea what this stuff is to do!

    Ivana,

    Based on what you said,

    SUGAR CRM, and VTIGER won't work!

    QUICKBASE MIGHT, but is TOO EXPENSIVE!(Starts around $299/MONTH)!

    Oh well, that is what happens when you're vague!

    Steve
    {{ DiscussionBoard.errors[2182564].message }}

Trending Topics