#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Location
    Illinois
    Posts
    2
    Rep Power
    0

    Looking for some helpful advice...


    This might be in the wrong forum, but since I haven't picked a program or language yet, I am looking for some advice on where to set my sights. I need a stable database program that allows a table for each client, and tracks admin defined resources for each table. Also, clients need to be able to sign in with mobile devices and change certain aspects of those resources on their table. If possible I am also looking for a low start cost. Does anyone have any suggestions?

    Thank you in advance for the help.
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    Your description is really too generalized, I have no idea what you mean by "resource". Maybe you can give a more specific example.

    It sounds like you need both a database and some front-end software for managing that database. Your decision will probably be driven a lot more by the front-end software than by the database back-end. Are you going to be running this off a web server? If so, what languages are installed on the server?
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Location
    Illinois
    Posts
    2
    Rep Power
    0
    I have decided to use oracle, and my decision really will be driven by front end software, especially because I am looking for mobile software (IOS and Android) to interface with the database as well.

    In terms of resources, the closest example to what I am looking at is an inventory management program. I need to track a list of specific inventory items for multiple clients. Clients need to be able to log in and show their expenditure of the inventory, and I need to be able to replenish them from my end.

    Thanks for your response and hopefully this clears up the picture as to what I am looking for.
  6. #4
  7. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    Originally Posted by EnderCowboy
    If possible I am also looking for a low start cost.
    Oracle is not recommended for you, better try some of the open source stuff.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Location
    Haifa, Israel
    Posts
    17
    Rep Power
    0

    RE: Looking for some helpful advice...


    Hey there @EnderCowboy,

    In your initial post you mentioned you are looking for a low starting cost, and as @debasisdas said, Oracle is expensive; if you're still considering other options, I'd recommend looking into MySQL which is open source and relatively easy to use. If you're ready for a small investment there are also self-managed MySQL cloud database options, which are easier to get started with and save you the need to install, configure and scale the database up and down.

    Regarding Android connectivity, or front-end management, take a look at this post about Android access to MySQL.

    Good luck Ronny
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    3
    Rep Power
    0
    Well, Your problem is not that big... You can use a free database software like Mysql. It is a database software that is commonly used for websites and mobile applications. The difference is that in websites, you can access it directly. but for mobiles,you need a certain website that access the database so that the information could be loaded on the mobile device.

    For further information with this topic, you can search in google and you will surely find helpful links that will give you a clear insight on the said topic.

    Good luck.
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by RonnyFink
    Oracle is expensive
    Oracle's Express Edition is free.

    I'd recommend looking into MySQL which is open source and relatively easy to use.
    but lacks many modern SQL features.

    Especially for a beginner, a more standard's compliant and feature-rich database like PostgreSQL is the better choice.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2009
    Posts
    41
    Rep Power
    10
    I'm not sure what 'modern' features MySQL lacks, but Oracel violates many of the standard rules of relational databases.

    Honestly based on the vague description you gave, I'd use filemaker pro. The front end interface is inherent in the program and thus you don't have to build anything on top of it.
  16. #9
  17. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    I'm not sure what 'modern' features MySQL lacks, but Oracel violates many of the standard rules of relational databases.
    Here's a short list of modern features that I've found missing in MySQL within the past couple months:
    * materialized views (Postgresql lacks these too, but Oracle supports them)
    * check constraints
    * full outer joins (not sure if Postgresql supports these)
    * geospatial indexing with support for arbitrary polygons (although this is coming in 5.6; I don't think Postgresql supports this without an extension)

    However, that said, I still use MySQL almost exclusively because I'm familiar with it, it is supported virtually everywhere, and I rarely need features that it doesn't have.
    Last edited by E-Oreo; October 24th, 2012 at 06:34 PM. Reason: s/fuller/full
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  18. #10
  19. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2009
    Posts
    41
    Rep Power
    10
    Ah - well - see - I've never heard of any of those things (though I'm not sure what a 'full' outer join is - if you mean left and right you can just write a union statement - si there so some of 'new' join that is bigger than a left or right?
  20. #11
  21. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    No, a full outer join is essentially a union of a left and right join (without duplicates) and you can implement it as such. However, a database engine that doesn't support full outer joins obviously can't optimize the union query for them and you end up having to write and maintain essentially two copies of the same query.

    However, there are fairly few situations in which you ever need to perform a full outer join.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  22. #12
  23. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2009
    Posts
    41
    Rep Power
    10
    I thought MYSQL did full outer joins and sql server didn't - maybe i got it backwards (unions remove duplicates inherently)
  24. #13
  25. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,144
    Rep Power
    4274
    Originally Posted by E-Oreo
    ... and I rarely need features that it doesn't have.
    this

    Originally Posted by E-Oreo
    ...there are fairly few situations in which you ever need to perform a full outer join.
    and this

    Originally Posted by jemagee
    I thought MYSQL did full outer joins and sql server didn't
    it's the other way around
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo