Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: OT: SQL and me

by wjw (Priest)
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...
  • my will, and by will alone.. I set my mind in motion

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (3)
As of 2018-12-19 06:30 GMT
Find Nodes?
    Voting Booth?
    How many stories does it take before you've heard them all?

    Results (85 votes). Check out past polls.