News for hackers. Stuff that matters.

LookingToLearn

Re:Looking to learn: SQL in MySQL and SQLlite on Sunday April 24, 2011 @05:23PM (#2479646)
Excellent information - thanks.
Re:Looking to learn: SQL in MySQL and SQLlite on Sunday April 24, 2011 @12:18PM (#2479085)
Indeed. And thanks again.
Re:Looking to learn: SQL in MySQL and SQLlite on Sunday April 24, 2011 @11:01AM (#2478941)
I'm pretty sure normalization won't be a problem in my context and with my background. My requirement is simple, and the design straight-forward.

Many thanks for your response.

Re:Looking to learn: SQL in MySQL and SQLlite on Sunday April 24, 2011 @08:50AM (#2478776)
You'd recommend MySQL over SQLite? The latter comes "baked in" to Python, so no installation required, and I was planning to go with that as a starter to avoid any problems with installation and configuring.

It would be easy to write a command line for that so I could then experiment. Thoughts?

And any suggestions for guide to SQL syntax and semantics?

Many thanks.

I have a similar question which I asked over here:

http://news.ycombinator.com/item?id=2478537

That hasn't got many upvotes, so probably very few will see it, but it seems related enough to mention here and ask for advice.

Thanks in advance.

Looking to learn: SQL in MySQL and SQLlite

Hi,I'm a long time programmer in C, Python, and a range of other languages. The need has arisen for me to write something that uses a database, and I'm looking for advice on where to start.A database consists of a collection of tables, and SQL is the language used to create, populate, manipulate, query and destroy the tables and their contents.Can anyone suggest a non-patronising,...

( Read More... | 8 comments | 9 points | on HN )