Evan Carroll
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.
- Langs: JavaScript, Perl, PHP, Python
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.
PostgreSQL Types
PostgreSQL Posts
- 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
- Why
SELECT count(*)
returns 1 - How to generate a time series
- Triggerz on triggerz triggaz
- Occurrence of substring in a string
intarray
push (+
) vs array-to-element concatenation (||
)- custom window functions
Gaps and Islands
-
Houston, TX
-
Member for 9 years, 5 months
-
5,126 profile views
-
Last seen 47 mins ago
Communities (27)
Top Meta Posts
22
30
Top network posts
Badges (531)
Gold
Rarest
-
Aug 8 '18
-
Feb 7 '18
-
Dec 23 '17
Silver
Rarest
-
Nov 1 '19
-
Jan 19 '18
-
Mar 26 '17