Tag Results

Imperva, a provider of data and application security solutions, is actively running a research effort with the express goal of identifying attack methods on databases. They call their project StickyDB, a database decoy designed to deceive a would-be hacker into targeting their databases. Once hackers engage the database decoy and reveal their methods, Imperva has more knowledge to counter new exploits and harden their customer’s data security. Recently, the Imperva research team uncovered a technique targeted at their database decoy leveraging code […]

PostgreSQL has long been a popular database, loved by developers and database administrators for its ease of use, comprehensive and intuitive documentation, and reliability. Anyone at EnterpriseDB® (EDB™) could tell you that interest in PostgreSQL (also known as Postgres) has been growing rapidly in recent years, but that might be considered biased. Now, an unbiased source, DB-Engines, has announced that 2017 was a banner year for interest in Postgres. So much so that DB-Engines named Postgres “DBMS of the Year 2017”. DB-Engines is a website […]

In a recent support case, I came across a customer who used a clever way to create streaming replication base backups–by taking a Google Cloud instance and cloning it. With the proliferation of cloud computing, it’s very convenient to be able to create a block-level clone of a VM within minutes or even seconds, and it would be much faster than any program like scp or rsync. They had found it to be faster than pg_basebackup for sure, on the order of several […]

Virtual machines are by far the most prevalent deployment model for data centers – close to 99%. What was once a revolutionary idea has transformed into the best practice standard for data center deployments. Virtualization has evolved into a very well established and understood technology that is also extremely robust and reliable. And, the largest growth in cloud deployment today is in fact still in virtual machines. But that is about to change. Today’s great interest in containers is impossible to ignore, for […]

You must be hearing the term Polyglot Persistence quite often. So I thought, why not take our readers through what exactly it is, the role it plays and more. Let’s start with the basics – Polyglot Persistence is the idea of using various, right-fitting databases to store data for either single or multiple applications. In the new-age world, most applications need to connect with multiple databases; and each with different types of data stored in different ways. This is where Polyglot […]

Use case: Mobile Application with offline first approach One of Ashnik’s customers – a top Insurance company in Asia was looking to develop a mobile application with online & offline capabilities. The needs being: To enable the field agents to access their customers’ insurance related information for read and offline operations Subsequently, sync all the insurance related customer data, captured by the field agents while being offline, back to the data centre  – when the device goes online later The Goal of the […]

Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were committed to PostgreSQL 10 which is expected to be released next week, it seems like a good time for a brief review of all the work that has been done over the last 18 months or so. Prior to version 10, hash indexes didn’t perform well under concurrency, lacked write-ahead logging and thus were not safe […]

To say the database market is evolving would be a gross understatement. New data types and sophisticated new analytic requirements, combined with increasing pressure to lower costs without sacrificing functionality is ushering in an era of great change and great opportunity in the database market. And today’s customers are taking advantage of that change. With such a wide range of new and innovative platforms on the market, customers are increasingly seeking efficiency not by consolidating around a single database, as they […]

These days buzz is all about Big Data. But where is my data and what happened to database technology? Ain’t all the business critical applications powered by database? In terms of importance for the business continuity, it is the database technology that is carrying the day. Till recently, picking up database for your applications was fairly easy. Though there are choices to be made from among the database vendors, they were all within the same category of RDBMS. Application design and […]