Re: [Sqlalchemy-users] database literature

[Ezio Vernacotola]

I wish suggest you to look for a book that is not limited to sql, and starts from very general aspects, such as real world modeling (as entity relationship diagrams), concurrency, integrity, and talks also of not sql and not relational databases. SQLAlchemy is a object relational mapper, you can think SA as a easier way to access your SQL database, but it's also, from the application view, an object oriented database, that use sql  because is simpler reuse many good sql implementations around to have persistence, concurrency control, management tools etc. I learned database on a rather old book, Principles of Database and Knowledge-Base Systems, of  Jeffrey Ullman, and perhaps is too much academic, but gives you a very large view of databases. At my advice you can search something of newer that talks not only about relational but also about object oriented databases. Ezio Alexandre CONRAD wrote: I don't think these are quite on the mark - one is too low-level, the other too high - but they are both good books and somewhat related. What do you mean by "too high" or "too low-level" ? Do you mean it's too high or too low in terms of programming ? Or it's too much suited for experts or newbies ? I might have to mention that I'm new to the database world and I only have a very few vocabulary words concerning them. Words like "tables", "columns", "fields", "primary key", "foreign key" start to make sense to me. A also discovered about "normalization" a few days ago. Here is a very practical guide on *using* databases, it does have a chapter on design. http://www.amazon.com/Practical-SQL-Handbook-Using-Variants/dp/0201703092/sr=1-1/qid=1157968204/ref=pd_bbs_1/104-4955671-9297524?ie=UTF8&s=books This is an excellent book about how to design an application that uses a database, talks about the problems that come up, different ways to address the problems and tradeoffs in the solutions: http://www.amazon.com/Patterns-Enterprise-Application-Architecture-Martin/dp/0321127420/sr=1-1/qid=1157968478/ref=pd_bbs_1/104-4955671-9297524?ie=UTF8&s=books It all sounds good. I'll have a look on these also. Thanks you. Regards,

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users