sqlstarter.com

postgresqldbnews.blogspot.com

Postgres Database News: March 2008

http://postgresqldbnews.blogspot.com/2008_03_01_archive.html

News and Commentary regarding the open source database, Postgres. Saturday, March 29, 2008. Postgres East 2008 Conference. I'm in Baltimore this weekend at the Postgres East 2008 conference. I'm giving a presentation tomorrow on SQL/XML for developers. Below is the presentation and below that is the code used in the presentation. Code to follow along:. If you aren't using javascript, you can get download the presentation. From scribd. Or, to make it easy, just grab this code:. Posted by Lewis Cunningham.

postgresqldbnews.blogspot.com

Postgres Database News: August 2008

http://postgresqldbnews.blogspot.com/2008_08_01_archive.html

News and Commentary regarding the open source database, Postgres. Tuesday, August 19, 2008. Final Week for Database Survey. This is the last week to participate in a database usage survey. If you haven't already done so, please take a few minutes to answer 25 questions. Posted by Lewis Cunningham. Thursday, August 7, 2008. Database Survey hits 250. It hasn't been 2 weeks yet but the database survey. Posted by Lewis Cunningham. Subscribe to: Comment Feed (RSS). Uarr; Grab this Headline Animator. Enterpris...

postgresqldbnews.blogspot.com

Postgres Database News: October 2007

http://postgresqldbnews.blogspot.com/2007_10_01_archive.html

News and Commentary regarding the open source database, Postgres. Sunday, October 7, 2007. Best Way to Handle No Data Found in a Procedure? CREATE TABLE empty table ( empty col integer );. In Oracle this procedure:. CREATE OR REPLACE PROCEDURE no data found test AS v int field INTEGER; BEGIN SELECT empty col INTO v int field FROM empty table; END;. BEGIN no data found test; END;. However, the equivalent procedure in Postgres:. Does not raise an exception when run:. Postgres=# select * from no data found ...

postgresqldbnews.blogspot.com

Postgres Database News: Database Survey hits 250

http://postgresqldbnews.blogspot.com/2008/08/database-survey-hits-250.html

News and Commentary regarding the open source database, Postgres. Thursday, August 7, 2008. Database Survey hits 250. It hasn't been 2 weeks yet but the database survey. I plan to leave it up for another 2 1/2 weeks (for a total of 4 weeks). If you haven't taken it yet, please do so if you get a few minutes. It only takes 5-10 minutes as the survey only has 25 questions. Also, if you can blog about it, post the link on forums (without spamming), or spread the word any other way, I would appreciate it.

postgresqldbnews.blogspot.com

Postgres Database News: A New Open Source Community

http://postgresqldbnews.blogspot.com/2009/01/new-open-source-community.html

News and Commentary regarding the open source database, Postgres. Tuesday, January 6, 2009. A New Open Source Community. If you are into social sites, check out the newest for OSS: Open Source Universe. Of course, this isn't just an issue with open source. Technologists seem to want to spend most of their time with people dealing with the same technology. Who today isn't using (even if not developing) multiple OSS applications and tools? So anyway, that's why I wanted to give a shout out to OSU. LewisC's...

mysqldbnews.blogspot.com

MySQL Database News: SQL Newbie Book

http://mysqldbnews.blogspot.com/2008/11/sql-newbie-book.html

It's news to me! Friday, November 21, 2008. I have written a new book on SQL DML. This is a total beginner book: how to commit and rollback, how to query, how to add data, etc. Probably not of interest to most of the people who read this blog but if you know of anyone completely new to SQL, this would make a great Christmas present. Only 14.95. It is completely vendor agnostic, although the examples all use Oracle and MySQL. You can view the Table Of Contents, Preface and Index here. I have very much imp...

lewisc.us

Database Wisdom: MySQL Table Of Contents

http://www.lewisc.us/mysql_toc.shtml

The Database Knowledgebase on the Web. Database Wisdom: MySQL (Coming Soon)! Chapter 1. Introduction, Acquisition and Installation. Chapter 2. Using Databases. Chapter 3. Connections. Chapter 4. SQL. Chapter 5. Schema Objects and Data Models. Chapter 6. Programming The Database. View the Privacy Policy.

lewisc.us

Database Wisdom: Oracle Table Of Contents

http://www.lewisc.us/oracle_toc.shtml

The Database Knowledgebase on the Web. Chapter 1. Introduction, Acquisition and Installation. Chapter 2. Using Databases. Chapter 3. Connections. Chapter 4. SQL. Chapter 5. Schema Objects and Data Models. Chapter 6. Programming The Database. Chapter 7. Oracle Replication Methods. Chapter 8. Partitioning in Oracle 11g. View the Privacy Policy.

lewiscsrandomthoughts.blogspot.com

LewisC's Random Thoughts: January 2008

http://lewiscsrandomthoughts.blogspot.com/2008_01_01_archive.html

Drivel from my mind. It flows much freer than I would like. Enter your search terms. Tuesday, January 22, 2008. The 10s, 30s and 40s on Flickr. I'm pretty much a history nut but I don't think you need to be to enjoy the new US Library of Congress Photo Collections on Flickr. These are some incredibly amazing photos. I didn't know photos like this existed back then. The best part of these are that they are being released freely for use by anyone. Did you like this entry? Why not subscribe to it. I am will...

lewiscsrandomthoughts.blogspot.com

LewisC's Random Thoughts: August 2007

http://lewiscsrandomthoughts.blogspot.com/2007_08_01_archive.html

Drivel from my mind. It flows much freer than I would like. Enter your search terms. Wednesday, August 29, 2007. Doomsday - The Death of Superman. I have been a sci-fi freak for decades but even before that, I was a Superman freak. When I collected comics, I had a stash of about 3000 and many of those were Superman, Action Comics, Superboy and other superman related comics. Warner Bros is coming out, 9-18-2007, with a new animated movie, Doomsday - The Death of Superman. Posted by Lewis Cunningham. 1 How...