Issue 109 — June 17, 2016
ClickHouse: Open-Source Distributed Column-Oriented DBMS
— An open-source column-oriented database management system that allows generating analytical data reports in real time.
pickaxe: An SQL-Based DSL Web Scraper/Screen Scraper
— A C# / Mono based Web scraper that takes a novel approach of letting you scrape the Web by building special SQL queries. There are lots of examples to look at.
Elasticsearch-Based Image Search using RGB Signatures
— An interesting technique to be able to use Elasticsearch to provide image searching functionality.
DreamFactory 2.2 released, includes important API changes
— Our API automation platform keeps getting better with new streamlined commercial packages.
The Guts n’ Glory of Database Internals: B+Tree
“The absolute worst thing about B+Trees is their name. It is like someone maliciously considered all the possible names and then selected the most confusing one.”
VisualAlchemist: A Web-Based Database Diagramming Tool
— An open-source Web-based database diagramming tool that’s under active development and looking for contributors - check out
the online demo.
— If you’re looking for a way to practice your SQL skills some PG Exercises offers some good example data and exercises to hone your skills.
10 Reasons to Migrate to MariaDB (If Still using MySQL)
— A better ecosystem, increased popularity, more storage engines, and potential for future data incompatibility are pressing reasons, says Seravo.
Hired is the best place to find engineering jobs.
— Bored at work? Want to try a new stack? Find 3500+ great tech companies on Hired who will compete to hire you.
Try it today.
PGDay UK 2016 (London, July 5)
— The UK’s only dedicated PostgresSQL annual user conference returns next month.
PostgreSQL UK Usergroup
MemSQL Introduces New Enterprise Security Capabilities
SQL Server 2016 Developer Image Now in The Azure Gallery
— A free licensed version of SQL Server that you can use to develop and test SQL Server applications.
Considering migration to PostgreSQL? Get help from the experts
— From initial migration assessments and migration assistance, to training and 24/7 technical support, turn to the PostgreSQL professionals for the most comprehensive service.
How to Lock Down Elasticsearch, Kibana, and Logstash and Maintain Security
An Introduction to Data Models for MMO Games
Advanced MySQL Basics
Scaling Out MySQL with PostgreSQL and Citus
— How PostgreSQL and Citus can help to scale out existing MySQL data.
Copying Data from Postgres to Redshift
Efficient Color Similarity Searching with Postgres
— A novel example of what you can do with Postgres and computing similarity.
PG Casts: Postgres Screencasts
What If Apache Spark Was Also The Database?
Is Spark Overhyped?
“The Apache Spark phenomena has taken the big data world by storm. But can the technology actually deliver according to the tremendous hype that is accompanying it, or has it been oversold?”
Why SQL Injection Vulnerabilities Still Exist
Have you got SQL fingers?
— Try SQL Prompt and you’ll be able to write, refactor, and reformat SQL effortlessly in SSMS and Visual Studio.
Find out more.
pg_view: Get A Detailed, Real-time View of Your PostgreSQL Database and System Metrics
Microsoft SQL Server 2014 Express in a Docker Container