DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 113 — July 15, 2016
Featured
Modeling Polymorphic Associations in a Relational Database — Polymorphic associations can be difficult to correctly represent in a relational database. This post compares four different ways to model these challenging relationships.
Jack Christensen    tutorial   
A Beginner's Guide to Thinking in SQL — At first glance, SQL can look straightforward, but its simple elements can add up to something quite confusing. This primer provides some examples and advice on getting your head around some of SQL’s underlying concepts.
Soham Kamani
DBSherlock: A Performance Diagnostic Tool for Transactional Databases — A nice intro to DBSherlock, a performance explanation framework that helps DBAs diagnose performance problems
Adrian Coyier    tools   
Free t-shirt when you deploy RethinkDB in July — This month only we're giving away a free limited edition tshirt when you deploy RethinkDB on Compose. All deployments are free for 30-days.
Compose    sponsored   
1.1 Billion Taxi Rides with MapD and 4 NVIDIA Titan Xs — GPUs provide a compelling option for higher data processing power, but it’s even possible to make major savings depending on which GPUs you choose.
Mark Litwintschik    story   
How to Model Human Relationships — A look at a robust but flexible way to model the relationships between people and organizations in a relational database.
Vertabelo    tutorial   
Faster PostgreSQL Searches with Trigrams — pg_trgm is a PostgreSQL extension providing simple fuzzy string matching which, in some circumstances, can be a lot faster to use than full-text search.
Greg Navis    tutorial   
How to Build Your Own Semantic Search Engine — Hear how Mattermark, a startup providing data on privately held companies, is making its search engine smarter with deep learning.
Structure Events    video   
Comparing Data Structures For Storage on Disk — A look at various data structures (e.g. B trees and fractal trees) and how ideal they are for disk-based storage scenarios.
Max Bolingbroke    opinion   
Jobs
Stop Applying to Jobs - Let Companies Come To You — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly.
Hired.​com
In brief
Secrets of the Data Whisperer — ‘Data whisperers’ are people who can connect data and models to actual business problems.
Datanami    news   
Citus Cloud Now Generally Available — A managed, hosted version of Citus’s enhanced Postgres, running on top of AWS.
Citus Data    news   
AWS Database Migration Service Now Supports Continuous Data Replication — ..with high-availability, enables SSL endpoints, and adds support for SAP ASE.
Amazon Web Services    news   
MongoDB Security Basics For Your Deployments in AWS — Tips to secure your MongoDB data if running on AWS.
Jay Gordon    tutorial   
Understanding Database Multitenancy
Filipe Ximenes    tutorial   
A Speed Guide To Redis Lua Scripting — Lua is an embeddable language you can use directly from inside Redis.
Compose    tutorial   
Is Datomic the Sequel to SQL? — The short answer is ‘no’, but Matthew thinks there’s a lot to take from the Datomic approach going forward.
Matthew Forsyth    opinion   
SQL Dashboards in a Flash. — Periscope Data lets you run analyses over billions of rows in seconds.
Periscope Data    tools    sponsored   
SnappyData: A Hybrid Transactional Analytical Store Built On Spark — An academic paper.
ACM    tools   
aq: Query AWS Resources with SQL
Binh Le    tools   
« Prev
Next »