Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: OT: SQL and me

by wjw (Deacon)
on Sep 27, 2013 at 21:07 UTC ( #1056077=note: print w/ replies, xml ) Need Help??


in reply to OT: SQL and me

Agree with previous poster in that "Yes, this is a very good match for a RDBMS".

As you are just getting started with the DB stuff, I would start with SQLite which has some real advantages for this kind of a project:

  • DB is a single file
  • Has a good DBD module with reasonable documentation
  • It provides all the functionality you are asking for without having to get into a lot of DB admin like you might with heavier DB's like mysql, postgreql etc....
  • The online docs are not bad

I would do is look for existing DB implementations (google search) as the album app is commonly used as an example for simple DB development.

And finally, I would delve into basic DB design by checking out some books like This one.

Hope that is helpful and encouraging...

  • ...the majority is always wrong, and always the last to know about it...
  • ..by my will, and by will alone.. I set my mind in motion


Comment on Re: OT: SQL and me

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1056077]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (10)
As of 2014-07-25 21:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (175 votes), past polls