Tag: INSERT

Feed: Blog – Hazelcast. Author: Neil Stevenson. In a previous blog post, Designing an Evergreen Cache with Change Data Capture, Nicolas describes “one-way” change data capture (CDC). It is a one-way process. In Nicolas’ post, the database copy can change and CDC pushes the change to Hazelcast to align the two copies of the data. Let’s take this a stage further, with “two-way” CDC. Now data in Hazelcast can change as well, and we need to push those changes back to the database. In terms of coding, this seems really easy, but it actually brings a lot of significant problems. Let’s ... Read More

Feed: SAS Blogs. Author: Amanda Pack. Growing up in Eastern NC meant attending a diverse elementary school until 6th grade when we moved across town.  I remember asking my mom where all the black people were.  I think there were a total of 3 black kids in my 6th grade class.  Little did I know, in the next town over, the story would have been quite the opposite.   In 1997 segregation, be it voluntary, was alive and well.  However, both elementary schools combined to create 1 high school.  Insert running.  I joined the cross-country team as a freshman and, aside ... Read More

Feed: Planet MySQL; Author: Ovais Tariq; In 2016 we published blog posts (I, II) about Schemaless – Uber Engineering’s Scalable Datastore. We went over the design of Schemaless as well as explained the reasoning behind developing it. In this post today we are going to talk about the evolution of Schemaless into a general-purpose transactional database called Docstore.  Docstore is a general-purpose multi-model database that provides a strict serializability consistency model on a partition level and can scale horizontally to serve high volume workloads. Features such as Transaction, Materialized View, Associations, and Change Data Capture combined with modeling flexibility and ... Read More

Feed: Planet PostgreSQL. This is something a lot of people want: being able to track changes happening on their database when and who ordered them. Well, I have good news, my friends, there is a native feature in Postgres that can help you achieve that exact goal!DDL and DML First things first, what are DDL and DML? Both DDL and DML are a subset of the SQL language. DDL means Data Definition Language (or Data Description Language). It means the SQL orders you need to create or modify database objects. An example of a DDL query is a create query ... Read More

Feed: SAS Blogs. Author: Amanda Pack. Growing up in Eastern NC meant attending a diverse elementary school until 6th grade when we moved across town.  I remember asking my mom where all the black people were.  I think there were a total of 3 black kids in my 6th grade class.  Little did I know, in the next town over, the story would have been quite the opposite.   In 1997 segregation, be it voluntary, was alive and well.  However, both elementary schools combined to create 1 high school.  Insert running.  I joined the cross-country team as a freshman and, aside ... Read More

Feed: Planet PostgreSQL. Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases. While it is great that there are several features available with Postgres by default, it may be challenging if there are no solutions to help with migrations to postgres. Fortunately, there are several contributions through extensions and Open source ... Read More

Feed: Planet PostgreSQL. PostgreSQL is one of the most advanced open source databases globally with a lot of great features. One of them is Streaming Replication which was introduced in PostgreSQL 9.0—known as Physical Replication. It works by sending the WAL segments generated by the primary PostgreSQL to another standby server also running PostgreSQL. However, if we only want to replicate a portion of the database tables, then Physical Replication in this case is not ideal. To improve the replication feature, PostgreSQL 9.4 came up with a feature called Logical Replication, in which we can perform efficient synchronous streaming replication ... Read More

Feed: Planet PostgreSQL. Just like in most databases, in PostgreSQL a trigger is a way to automatically respond to events. Maybe you want to run a function if data is inserted into a table. Maybe you want to audit the deletion of data, or simply respond to some UPDATE statement. That is exactly what a trigger is good for. This post is a general introduction to triggers in PostgreSQL. It is meant to be a simple tutorial for people who want to get started programming them.Create a simple tableWriting a trigger is easy. The first important thing you will need ... Read More

Feed: SAS Blogs. Author: Rick Wicklin. A previous article describes how to use the SGPANEL procedure to visualize subgroups of data. It focuses on using headers to display information about each graph. In the example, the data are time series for the price of several stocks, and the headers include information about whether the stock price increased, decreased, or stayed the same during a time period. The previous article discusses several advantages and disadvantages of using the SGPANEL procedure for this task. An alternative approach is to use the BY statement in the SGPLOT procedure ... Read More

Feed: Planet PostgreSQL. "I want to work on optimizing all my queries all day long because it will definitely be worth the time and effort," is a statement that has hopefully never been said. So when it comes to query optimizing, how should you pick your battles? Luckily, in PostgreSQL we have a way to take a system-wide look at database queries:  Which ones have taken up the most amount of time cumulatively to execute Which ones are run the most frequently And how long on average they take to execute And that's just a few places you can shine ... Read More