Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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]
[choroba]: not enough tuits?
[Corion]: choroba: Yeah, maybe. I'm also unaware of who uses Email:: modules, but that's more my limited horizon of things ;)
[Corion]: Ah - there even is the replacement of Email::Address::XS , by the bug reporter, which hopefully fixes this bug already ;)
[choroba]: the reporter is my colleague, BTW, albeit in a different team

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2018-06-20 12:02 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (116 votes). Check out past polls.