A

Attack of the week: searchable encryption and the ever-expanding leakage function

https://blog.cryptographyengineering.com/2019/02/11/attack-of-the-week-searchable-encryption-and-the-ever-expanding-leakage-function/

A few days ago I had the pleasure of hosting Kenny Paterson, who braved snow and historic cold...

T

Group Log Data by Timestamp in Python with Pandas

https://www.alexkras.com/group-log-data-by-timestamp-in-python-with-pandas/

I often find myself with logs in the following format, exported in CSV....

T

Analyzing 200,000 Deleted Tweets with Spark, 40 Billion Comparisons

https://www.alexkras.com/analyzing-200000-deleted-russian-troll-tweets/

My wife and I were watching Jack Ryan, where John Krasinski is playing an FBI analyst. I wanted...

O

Atomic Updates with DBIx::Class

http://blogs.perl.org/users/ovid/2019/04/atomic-updates-with-dbixclass.html

As we're building Tau Station, a narrative sci-fi MMORPG written in Perl, we've encountered any...

M

Managing Sqitch with Make

http://www.modernperlbooks.com/mt/2014/02/managing-sqitch-with-make.html

Sqitch is a wonderful tool to automate database migrations. I've automated Sqitch with Make....

N

Logging raw SQL to the console in Django

https://neilwithdata.com/django-sql-logging.html

When working on a Django project it can be useful to see the raw SQL queries being made to your...

N

Advanced SQL and database books and resources

https://neilwithdata.com/advanced-sql.html

For people who've worked through Mastery with SQL, a common question I get is "What's next?" If...

N

Joins: USING vs ON for join conditions

https://neilwithdata.com/join-using.html

When establishing the join condition between two tables in PostgreSQL, and you're performing an...

N

Using Distinct

https://neilwithdata.com/using-distinct.html

The DISTINCT keyword has a bunch of interesting use-cases in ANSI SQL and offers some additional...

N

Mastery with SQL is out now!

https://neilwithdata.com/mastery-with-sql-launch.html

My new course Mastery with SQL is out now! I'm so thrilled with how it's turned out. My goal...

N

Permission Denied error when using PostgreSQL's COPY FROM/TO command

https://neilwithdata.com/copy-permission-denied.html

COPY FROM is commonly used to import data from a file (CSV, plain text, etc.) in to PostgreSQL....

N

Implementing SQL Server's WITH TIES in PostgreSQL

https://neilwithdata.com/with-ties-postgresql.html

SQL Server supports a TOP (N) WITH TIES clause which can be used to return the top N rows from a...

N

Using Visual Studio Code with psql

https://neilwithdata.com/using-vscode-with-psql.html

A quick HOWTO to show you how to setup psql to use Visual Studio Code for interactive...

C

How does a relational database work

http://coding-geek.com/how-databases-work/

When it comes to relational databases, I can’t help thinking that something is missing. They’re...

E

Design patterns in Go's database/sql package

https://eli.thegreenplace.net/2019/design-patterns-in-gos-databasesql-package/

Using SQL databases from Go is easy, in three steps: // Step 1: import the main SQL...

E

SQL inner and outer joins

https://eli.thegreenplace.net/2019/sql-inner-and-outer-joins/

If you store data in a relational database, it's good practice to have the data normalized. This...

E

To ORM or not to ORM

https://eli.thegreenplace.net/2019/to-orm-or-not-to-orm/

I've been enjoying using Go's database/sql package for working with databases. Recently, some...

R

Don't Manually Modify The PostgreSQL Data Directory!

http://rhaas.blogspot.com/2020/05/dont-manually-modify-postgresql-data.html

I was lucky enough to get a chance to give my talk Avoiding, Detecting, and Recovering From Data...

R

Who Contributed to PostgreSQL Development in 2019?

http://rhaas.blogspot.com/2020/05/who-contributed-to-postgresql.html

This is my fourth annual post on who contributes to PostgreSQL development. See previous posts...

View more articles