Tag: PostgreSQL

Feed: Planet PostgreSQL. proposed by PostgreSQL contributor Alvaro Herrera. BRIN stands for “Block Range INdex”. A block range is a group of pages adjacent to each other, where summary information about all those pages is stored in Index.  For example, Datatypes like integers – dates where sort order is linear – can be stored as min and max value in the range. Other database systems including Oracle announced similar features later. BRIN index often gives similar gains as Partitioning a table.BRIN usage will return all the tuples in all the pages in the particular range. So the index is lossy ... Read More

Feed: Planet MySQL; Author: Meenakshi Agarwal; This tutorial explains MySQL CONCAT() which is a built-in String function. It takes variable no. of strings as input and concatenates them together. We’ll describe the usages of this method with the help of simple examples.MySQL string concatenation is more user-friendly than other databases such as PostgreSQL or Oracle. They provide a string concatenation operator “||” instead of a proper function. However, MS SQL server does the same job using the addition arithmetic operator (+).1. CONCAT() Syntax2. CONCAT() Simple Examples4. CONCAT() with TablesLet’s now go through each of the section one by one.MySQL CONCAT() ... Read More

Feed: Planet PostgreSQL. Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection.In this article, we’re going to tackle the referential integrity improvement first. This will provide some sample data to use later for the other explanations. And the feature is just amazingly cool, so it goes first anyway. This example builds on the example given for the Generated columns in PostgreSQL 12 article, where we built a ... Read More

Feed: Planet MySQL; Author: Thorben Janssen; Hibernate Tips is a series of posts in which I describe a quick and easy solution for common Hibernate questions. If you have a question for a future Hibernate Tip, please post a comment below. Question: One of the readers of my article about using Hibernate with a MySQL database asked the following question: What is the difference between the following two recommended approaches concerning the primary keys? @GeneratedValue(strategy = GenerationType.IDENTITY) @GeneratedValue(generator = "native") @GenericGenerator(name = "native", strategy = "native") Solution: As so often in software development, the answer to that question is: “It depends ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Since MemSQL became free to use last November – for up to four nodes, and with community support – new, creative uses of MemSQL have abounded. One of the most impressive new implementations is from Katoni, an ecommerce hub that offers SEO tools via software as a service (SaaS) to mostly Scandinavian clients. Katoni has replaced Elasticsearch with MemSQL for MemSQL’s ability to handle complex queries with speed, scalability, and native SQL support. MemSQL is currently the primary database powering Katoni’s SaaS suite of SEO tools. MemSQL runs alongside PostgreSQL, which serves as a ... Read More

Feed: Planet PostgreSQL. In a lot of PostgreSQL environments, it’s common practice to protect user accounts with a password. Starting with PostgreSQL 10, the way PostgreSQL manages password-based authentication got a major upgrade with the introduction of SCRAM authentication, a well-defined standard that is a significant improvement over the current system in PostgreSQL. What’s better is that almost all PostgreSQL drivers now support this new method of password authentication, which should help drive further adoption of this method.While it may be easy to take advantage of SCRAM authentication in new PostgreSQL deployments, there are a few steps involved in upgrading ... Read More

Feed: Planet PostgreSQL. Postgres 12 is around the corner, and as always is packed with new features. One of them being the option to allow the user to control the behaviour of CTE materialization. You can find the commit from Tom Lane here, which explains everything about this new change but TLDR is that so far, CTE's where fully materialized, so restrictions from the query that uses it won't apply to the CTE. Which is the right way doing this when you are using CTEs to INSERT/UPDATE/DELETE or when they are recursive. This means that when a CTE is side-effect-free ... Read More

Feed: Planet PostgreSQL. Reverse proxying requests to a pgAdmin server is becoming more and more popular if posts to the mailing lists are to be taken as an indicative measure; more often than not when using pgAdmin in a container (of which there have now been over 10 million pulls)! Typically users will deploy a reverse proxy for a couple of reasons; to host multiple applications in different subdirectories under the same domain, or to add SSL/TLS support independently of the application.Because of the number of questions asked, I spent a little time over the last couple of days doing ... Read More

Feed: Planet PostgreSQL. While playing on quite large database (in terms of number of tables) with a friend of mine, we discovered that almost all tables did not have a primary key! Gosh! This is really baaaad!Why is that bad? Well, you should not ask, but let’s keep the poor database design alone and focus on some more concrete problems: in particular not having a primary key prevents a lot of smart softwares and middlewares to work on your database. As you probably know, almost every ORM requires each table to have at least one surrogate key in order to ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are happy to announce that we have just released the July update for the On-premises data gateway (version 3000.7.147). Here are some of the things that we would like to highlight with this month’s release: .Net Framework Update Encrypted Connection – Bug Fix July version of the mashup engine .Net Framework Update We are using .NET 4.7.2 framework for gateways July 2019 version or higher hence some of the operating systems we used to support may no longer be supported. More information about OS which will be supported ... Read More