DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 109 — June 17, 2016
Featured
ClickHouse: Open-Source Distributed Column-Oriented DBMS — An open-source column-oriented database management system that allows generating analytical data reports in real time.
Yandex    tools   
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.
bitsummation    tools   
Elasticsearch-Based Image Search using RGB Signatures — An interesting technique to be able to use Elasticsearch to provide image searching functionality.
Sujit Pal    tutorial   
DreamFactory 2.2 released, includes important API changes — Our API automation platform keeps getting better with new streamlined commercial packages.
DreamFactory    sponsored   
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.”
Ayende Rahien    tutorial   
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.
Prahlad Yeri    code   
PostgreSQL Exercises — 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.
pgexercises.​com
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.
Seravo Oy    opinion   
Jobs
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.
Hired.​com
In brief
PGDay UK 2016 (London, July 5) — The UK’s only dedicated PostgresSQL annual user conference returns next month.
PostgreSQL UK Usergroup    news   
MemSQL Introduces New Enterprise Security Capabilities
Datanami    news   
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.
Luis Vargas    news    tools   
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.
2ndQuadrant.​com    sponsored   
How to Lock Down Elasticsearch, Kibana, and Logstash and Maintain Security
Adam Vanderbush    tutorial   
An Introduction to Data Models for MMO Games
Vertabelo    tutorial   
Advanced MySQL Basics
Tim Ellis    tutorial   
Scaling Out MySQL with PostgreSQL and Citus — How PostgreSQL and Citus can help to scale out existing MySQL data.
Eren Başak    tutorial   
Copying Data from Postgres to Redshift
Alexander Rakoczy    tutorial   
Efficient Color Similarity Searching with Postgres — A novel example of what you can do with Postgres and computing similarity.
Gašper Žejn    tutorial   
PG Casts: Postgres Screencasts
Jack Christensen    video   
What If Apache Spark Was Also The Database?
Pierce Lamb    opinion   
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?”
Alex Woodie    opinion   
Why SQL Injection Vulnerabilities Still Exist
Dan Kuykendall    opinion   
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.
Red Gate    tools    sponsored   
pg_view: Get A Detailed, Real-time View of Your PostgreSQL Database and System Metrics
Zalando SE    tools   
Microsoft SQL Server 2014 Express in a Docker Container
Docker Hub    tools   
« Prev
Next »