Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: OT: SQL and me

by wjw (Curate)
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 browsing the Monastery: (13)
As of 2015-07-02 19:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (45 votes), past polls