Show your appreciation, with the Buy Me Stuff list. Just books for now, no longer accepting offers for dinner and a movie.
Available for consultation and contracting.
- RDBMS: PostgreSQL, MySQL, SQL Lite.
Microsoft SQL Server is objectively not a real database: it is the Devil's Inferior Stateful Abacus. Find the Microsoft "Closed as Won't Fix" social media network here. #SQLserverIsAnInsideJob
MySQL is even worse. It's a failed attempt at applying a server-client model to Lotus 1-2-3.
For a swift proletarian revolution and an end to fascism, vote Evan Carroll in the next Moderator Election.
- Upgrading schema to not require double quotes
- Date vs (month,year)
- Handling measurements inside the database
- How to parse an address
- Searching in n-dimensional space
SELECT count(*)returns 1
- How to generate a time series
- Triggerz on triggerz triggaz
- Occurrence of substring in a string
+) vs array-to-element concatenation (
- custom window functions
Gaps and Islands
- Stack Overflow 65.7k 65.7k 3939 gold badges213213 silver badges357357 bronze badges
- Database Administrators 51.7k 51.7k 3434 gold badges184184 silver badges386386 bronze badges
- Skeptics 24.7k 24.7k 3535 gold badges109109 silver badges208208 bronze badges
- Unix & Linux 19.6k 19.6k 2828 gold badges106106 silver badges184184 bronze badges
- Ask Ubuntu 7.1k 7.1k 1414 gold badges4747 silver badges8282 bronze badges
- View network profile
Top network posts
- 785 Node.js: printing to console without a trailing newline?
- 427 How to hide element using Twitter Bootstrap and show it using jQuery?
- 180 Did Valerie Jarrett say she wanted "America to be a more Islamic country"?
- 143 How do I login and authenticate to Postgresql after a fresh install?
- 115 How do I find out if my wireless card supports 5 GHz?
- 106 Express.js: No Such file or directory
- 106 How do I import modules or install extensions in PostgreSQL 9.1+?
- View more network posts →