Category: PostgreSQL
-
Reminder: My “Intro to SQL” course is this Sunday!
This is just a reminder that on Sunday, I’ll be teaching a live, 4-hour introductory course on databases and SQL. If you haven’t ever worked with databases before, then this
-
Join the data revolution with my “Intro to SQL” course!
Have you heard? Data is “the new oil” — meaning, data is the most valuable and important thing in the modern world. Which means that if you can store, retrieve,
-
Yes, you can master regular expressions!
Announcing: My new book, “Practice Makes Regexp,” with 50 exercises meant to help you learn and master regular expressions. With explanations and code in Python, Ruby, JavaScript, and PostgreSQL. I
-
Using regexps in PostgreSQL
After months of writing, editing, and procrastinating, my new ebook, “Practice Makes Regexp” is almost ready. The book (similar to my earlier ebook, “Practice Makes Python“) contains 50 exercises to
-
In PostgreSQL, as in life, don’t wait too long to commit
I recently helped a client with serious PostgreSQL problems. Their database is part of an application that configures and monitors large networks; each individual network node reports its status to
-
Remember: Don’t mix = and NULL
I was recently performing an analysis on the database for my dissertation software, and wanted to look at one particular set of rows. The table I was looking at is
-
Turning a PostgreSQL array to rows
I’ve spent the last few blog posts in this series talking about PostgreSQL’s arrays — how to create them, query them, and even create them with the ARRAY function. But
-
Turning PostgreSQL rows into arrays
So far in this series, I have described how you can create arrays and retrieve information from them — both the actual data stored in the array, and information about
-
Looking in PostgreSQL arrays with ANY
So far, this series has looked at how to create PostgreSQL arrays, how to retrieve data from them, and how to get the length of an array’s outer and inner
-
PostgreSQL array indexes and length
In my last blog post, I introduced the idea of a PostgreSQL array, and showed how we can insert data into a table using either the curly-brace {} syntax, or