DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 136 — January 6, 2017
Featured
SQL Server is DB-Engines' DBMS of 2016 — DB-Engines tracks the popularity of database systems and found Microsoft’s SQL Server grew most in popularity in 2016. The release of SQL Server 2016 and the Linux port likely had a major effect.
DB-Engine    news   
Dgraph v0.7.1: A Low Latency Graph Database — Bills itself as ‘the most production ready graph database’. Strong claims versus Neo4j, but the feature set is certainly interesting.
Manish Rai Jain    tools   
SQLite 3.16.0 Released — Uses 9% fewer CPU cycles, fixes a long standard LEFT JOIN bug, adds experimental support for PRAGMA functions, has faster LIKE and GLOB matching when using multiple wildcards, and more.
sqlite.​org    news   
Explore your memory use over time with RedisGreen — RedisGreen's hosting and monitoring service maps your memory usage and tracks how keys in your database behave over time.
Redisgreen    sponsored   
RocksDB: A Persistent Key-Value Store for Flash and RAM Storage — From Facebook comes a library forming the core of a fast memory-based key-value store. It has a Log-Structured-Merge-Database (LSM) design with flexible tradeoffs and multi-threaded compactions.
Facebook    tools   
Playing with 80 Million Amazon Product Ratings Using Apache Spark — An attempt to show manipulating big data can be as easy as performing an analysis on a dataset with only a few records.
Max Woolf    story   
BigDL: Distributed Deep Learning Library for Apache Spark — Lets you write deep learning apps as standard Spark programs to run on Spark or Hadoop clusters.
Intel Analytics    tools   
Solving a Classic Puzzle using Postgres and Advanced SQL — Love puzzles and got quite a bit of time on your hands? This is a fascinating journey.
Quassnoi    story   
In brief
An SQL Injection Attack is a Legal Company Name in the UK
Bruce Schneier    news   
Five Things to Monitor After Black Friday & Cyber Monday — Baron Schwartz discusses how organizations can monitor their databases wisely after the holiday rush.
VividCortex    tutorial    sponsored   
MongoDB 3.4 and Money: Hello BigDecimal Type
Buzz Moschetti    tutorial   
Generating YouTube-Like IDs in Postgres Using PL/V8 and Hashids
Abe Voelker    tutorial   
A Database Model for Gallery or Museum Management
Vertabelo    tutorial   
The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()
jOOQ    tutorial   
How to Generate A Pivoted CROSS JOIN Where The Resulting Table Definition Is Unknown — An interesting question and set of answers that looks into using Postgres’ ‘crosstab’ function as well as other approaches.
Stack Overflow    tutorial   
Installing Livy on a Hadoop Cluster — Livy is an add-on to Spark that lets you communicate with your cluster in a RESTful fashion.
clairvoyantsoft.​com    tutorial   
What 2017 Will Bring: 10 More Big Data Predictions
Datanami    opinion   
How can you help your team write better, shareable SQL faster? — Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL.
Red Gate    video    sponsored   
Is There A Perf Difference Between Equal (=) and IN with 1 Value?
Stack Overflow
catsql: 'cat' for SQL Databases
Paul Fitzpatrick    tools   
Hasbolt: The New Haskell Neo4j Bolt Driver
Pavel Yakovlev    tools   
rediSQL: Redis Module Providing an SQL Database Inside Redis — Very alpha. Uses SQLite under the hood.
Simone Mosciatti    tools   
RediSearch: Full-Text Search Extension for Redis
RedisLabs    tools   
Presto: Distributed SQL Query Engine for Interactive Big Data
Facebook    tools   
aredis: An Efficient Async Redis Client for Python
github.​com    code   
Tile38: Geolocation Data Store, Spatial Index, and Realtime Geofence
Josh Baker    code   
« Prev
Next »