Are you over 18 and want to see adult content?
More Annotations
A complete backup of chirurgie-hessen.de
Are you over 18 and want to see adult content?
Joomla Templates and Extensions | Pixel Point Playground
Are you over 18 and want to see adult content?
Дума ТВ - Парламентское телевидение ГД ФС РФ
Are you over 18 and want to see adult content?
CelebRiot - Celebrity Weight, Net Worth, Measurements & Dating
Are you over 18 and want to see adult content?
Gulf Jobs - Top Job Portal in Gulf | Wisdom Jobs UAE
Are you over 18 and want to see adult content?
Online Shopping Site in India | Shop for Mobiles, Electronics, Fashion, Grocery & more @ Paytmmall.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of https://balkanje.com/latino-serije/opasne-igre-2010/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/turske-serije/ljubav-na-medji/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/turske-serije/draguljareva-kci/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/cesta-pitanja/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/latino-serije/tajne-istine-2015/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/marasli-epizoda-17/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/turske-serije/da-sam-oblak-2009/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/turske-serije/mirna-ulica/
Are you over 18 and want to see adult content?
A complete backup of https://balkanje.com/turske-serije/mehmed-2018/
Are you over 18 and want to see adult content?
Text
TAPOUEH.ORG
POSTGRESQL DATA TYPES: ENUM POSTGRESQL CONCURRENCY: ISOLATION AND LOCKING PostgreSQL is a relational database management system. It’s even the world’s most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. This article is a primer on PostgreSQL Isolation and Locking properties and behaviors. USING TRIGRAMS AGAINST TYPOSEVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 THE ART OF POSTGRESQL The Art of PostgreSQL is the new edition of my previous release, Mastering PostgreSQL in Application Development . It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG DATABASE NORMALIZATION AND PRIMARY KEYSSEE MORE ON TAPOUEH.ORG POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. SQL REGRESSION TESTS EXPORTING A HIERARCHY IN JSON: WITH RECURSIVE QUERIESSEE MORE ONTAPOUEH.ORG
POSTGRESQL DATA TYPES: ENUM POSTGRESQL CONCURRENCY: ISOLATION AND LOCKING PostgreSQL is a relational database management system. It’s even the world’s most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. This article is a primer on PostgreSQL Isolation and Locking properties and behaviors. USING TRIGRAMS AGAINST TYPOSEVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 THE ART OF POSTGRESQL The Art of PostgreSQL is the new edition of my previous release, Mastering PostgreSQL in Application Development . It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. SIMPLE DATA MODELING WITH A TEST DATA SET The not-so-random Latin text comes from Lorem Ipsum and is a pretty good base for generating random content. We go even further by separating words from their context and then aggregating them together completely at random in the sandbox.lorem(int) function.. The method we use to get N words at random is known to be rather inefficient given large data sources. UNDERSTANDING WINDOW FUNCTIONS There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can be quite hard to grasp the feature. This article aims at making it crystal clear so that you can begin using it today and are able to reason about it and recognize cases where you want to be using window functions. POSTGRESQL DATA TYPES: ENUM PostgreSQL ENUM Data Type. It’s possible to make an enum type instead, using the following database model now: Be aware that in MySQL there’s no create type statement for enum types, so each column using an enum is assigned its own data type. As you now have a separate anonymous data type per column, good luck maintaining aglobally
SET RETURNING FUNCTIONS AND POSTGRESQL 10 PostgreSQL 10 is now available for everyone to use, and hinted by David Fetter I had to review my previous article on Json and SQL to adapt to Set Returning Functions changes. A Set Returning Function is a PostgreSQL Stored Procedure that can be used as a relation: from a single call it returns an entire result set, much like a subquery or atable.
FROM MYSQL TO POSTGRESQL Today pgloader v3.4.1 is released and available! This new release comes with 110 commits as show in github compare view. This release of pgloader is following the tradition of simplifying things for users, or if you allow me to quote Alan Kay, I believe that if simple things should be simple, complex things should be possible. USING TRIGRAMS AGAINST TYPOS In our ongoing Tour of Extensions we played with earth distance in How far is the nearest pub? then with hstore in a series about trigger, first to generalize Trigger Parameters then to enable us to Auditing Changes with Hstore. Today we are going to work with pg_trgm which is the trigrams PostgreSQL extension: its usage got seriously enhanced in recent PostgreSQL releases and it’s now aBATCH UPDATE
The first thing is to make it so that you’re doing only one batch update at any time, by architecting your application around that constraint. That’s the most effective way around the problem, but not the most practical. The other thing you can do, is force the concurrent transactions to serialize one after the other, using anexplicit
PG_RESTORE -L & PG_STAGING On the PostgreSQL Hackers mailing lists, Andrew Dunstan just proposed some new options for pg_dump and pg_restore to ease our lives. One of the answers was talking about some scripts available to exploit the pg_restore listing that you play with using options -l and -L, or the long name versions --list and --use-list. The pg_staging tool allows you to easily exploit those lists too.EVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 THE ART OF POSTGRESQL The Art of PostgreSQL is the new edition of my previous release, Mastering PostgreSQL in Application Development . It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG DATABASE NORMALIZATION AND PRIMARY KEYSSEE MORE ON TAPOUEH.ORG POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. SQL REGRESSION TESTS EXPORTING A HIERARCHY IN JSON: WITH RECURSIVE QUERIESSEE MORE ONTAPOUEH.ORG
POSTGRESQL DATA TYPES: ENUM POSTGRESQL CONCURRENCY: ISOLATION AND LOCKING PostgreSQL is a relational database management system. It’s even the world’s most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. This article is a primer on PostgreSQL Isolation and Locking properties and behaviors. USING TRIGRAMS AGAINST TYPOSEVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 THE ART OF POSTGRESQL The Art of PostgreSQL is the new edition of my previous release, Mastering PostgreSQL in Application Development . It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG DATABASE NORMALIZATION AND PRIMARY KEYSSEE MORE ON TAPOUEH.ORG POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. SQL REGRESSION TESTS EXPORTING A HIERARCHY IN JSON: WITH RECURSIVE QUERIESSEE MORE ONTAPOUEH.ORG
POSTGRESQL DATA TYPES: ENUM POSTGRESQL CONCURRENCY: ISOLATION AND LOCKING PostgreSQL is a relational database management system. It’s even the world’s most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. This article is a primer on PostgreSQL Isolation and Locking properties and behaviors. USING TRIGRAMS AGAINST TYPOSEVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 THE ART OF POSTGRESQL The Art of PostgreSQL is the new edition of my previous release, Mastering PostgreSQL in Application Development . It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. SIMPLE DATA MODELING WITH A TEST DATA SET The not-so-random Latin text comes from Lorem Ipsum and is a pretty good base for generating random content. We go even further by separating words from their context and then aggregating them together completely at random in the sandbox.lorem(int) function.. The method we use to get N words at random is known to be rather inefficient given large data sources. UNDERSTANDING WINDOW FUNCTIONS There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can be quite hard to grasp the feature. This article aims at making it crystal clear so that you can begin using it today and are able to reason about it and recognize cases where you want to be using window functions. POSTGRESQL DATA TYPES: ENUM PostgreSQL ENUM Data Type. It’s possible to make an enum type instead, using the following database model now: Be aware that in MySQL there’s no create type statement for enum types, so each column using an enum is assigned its own data type. As you now have a separate anonymous data type per column, good luck maintaining aglobally
SET RETURNING FUNCTIONS AND POSTGRESQL 10 PostgreSQL 10 is now available for everyone to use, and hinted by David Fetter I had to review my previous article on Json and SQL to adapt to Set Returning Functions changes. A Set Returning Function is a PostgreSQL Stored Procedure that can be used as a relation: from a single call it returns an entire result set, much like a subquery or atable.
FROM MYSQL TO POSTGRESQL Today pgloader v3.4.1 is released and available! This new release comes with 110 commits as show in github compare view. This release of pgloader is following the tradition of simplifying things for users, or if you allow me to quote Alan Kay, I believe that if simple things should be simple, complex things should be possible. USING TRIGRAMS AGAINST TYPOS In our ongoing Tour of Extensions we played with earth distance in How far is the nearest pub? then with hstore in a series about trigger, first to generalize Trigger Parameters then to enable us to Auditing Changes with Hstore. Today we are going to work with pg_trgm which is the trigrams PostgreSQL extension: its usage got seriously enhanced in recent PostgreSQL releases and it’s now aBATCH UPDATE
The first thing is to make it so that you’re doing only one batch update at any time, by architecting your application around that constraint. That’s the most effective way around the problem, but not the most practical. The other thing you can do, is force the concurrent transactions to serialize one after the other, using anexplicit
PG_RESTORE -L & PG_STAGING On the PostgreSQL Hackers mailing lists, Andrew Dunstan just proposed some new options for pg_dump and pg_restore to ease our lives. One of the answers was talking about some scripts available to exploit the pg_restore listing that you play with using options -l and -L, or the long name versions --list and --use-list. The pg_staging tool allows you to easily exploit those lists too.EVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG SQL REGRESSION TESTS SIMPLE DATA MODELING WITH A TEST DATA SETSEE MORE ON TAPOUEH.ORG POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. BATCH UPDATES AND CONCURRENCY EXPORTING A HIERARCHY IN JSON: WITH RECURSIVE QUERIESSEE MORE ONTAPOUEH.ORG
SQL AND BUSINESS LOGIC POSTGRESQL, AGGREGATES AND HISTOGRAMSSEE MORE ON TAPOUEH.ORG USING TRIGRAMS AGAINST TYPOS POSTFIX SENDER_DEPENDENT_RELAYHOST_MAPS The previous article about M-x mailq has raised several mails asking me details about the Postfix setup I’m talking about. The problem we’re trying to solve is having a local MTA to send mails, so that any old-style Unix tool just works, instead of only the MUA you’ve spent time setting up. Postfix makes it possible to do that quite easily, but it gets a little more involved if you have OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG SQL REGRESSION TESTS SIMPLE DATA MODELING WITH A TEST DATA SETSEE MORE ON TAPOUEH.ORG POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. BATCH UPDATES AND CONCURRENCY EXPORTING A HIERARCHY IN JSON: WITH RECURSIVE QUERIESSEE MORE ONTAPOUEH.ORG
SQL AND BUSINESS LOGIC POSTGRESQL, AGGREGATES AND HISTOGRAMSSEE MORE ON TAPOUEH.ORG USING TRIGRAMS AGAINST TYPOS POSTFIX SENDER_DEPENDENT_RELAYHOST_MAPS The previous article about M-x mailq has raised several mails asking me details about the Postfix setup I’m talking about. The problem we’re trying to solve is having a local MTA to send mails, so that any old-style Unix tool just works, instead of only the MUA you’ve spent time setting up. Postfix makes it possible to do that quite easily, but it gets a little more involved if you have POSTGRESQL AS A MICROSERVICE The MACI French podcast honoured me with an invitation to a guest appearance on their weekly schedule. As you can imagine, we talked about many things related to PostgreSQL and also reacted to some newsworthy articles carefully curated by the MACI team. One of the topics we discussed in the podcast started with looking at PostgreSQL through the angle of it being one of the SIMPLE DATA MODELING WITH A TEST DATA SET The not-so-random Latin text comes from Lorem Ipsum and is a pretty good base for generating random content. We go even further by separating words from their context and then aggregating them together completely at random in the sandbox.lorem(int) function.. The method we use to get N words at random is known to be rather inefficient given large data sources. EXPLORING A DATA SET IN SQL Artists, Albums, Tracks, Genre. The Chinook database model contains a music collection of tracks, artists, albums and genre. Each track has a genreid which is a foreign key to the genre reference table, and also an albumid which is a foreing key to the album table. Then album has a foreign key to artist. To discover that we use the \d facility of psql, here’s an example for the track table: DATABASE NORMALIZATION AND PRIMARY KEYS In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of PostgresQL, so it’s only fair that I would now publish said Primary Key section! So in this article, we dive into Primary Keys as being a cornerstone of database normalization. It’s so important to get Primary Keys right that THE MODE ORDERED-SET AGGREGATE FUNCTION In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks of multiple genres, and for the analytics we were then pursuing, we wanted to clean the data set and assign a single genre per album. We did that in SQL of course, and didn’t actually edit the data. BATCH UPDATES AND CONCURRENCY Batch Update, MoMA Collection. The Museum of Modern Art (MoMA) Collection hosts a database of the museum’s collection, with monthly updates. The project is best described in their own words: MoMA is committed to helping everyone understand, enjoy, and use ourcollection.
POSTGRESQL DATA TYPES: JSON The json datatype, being a text datatype, stores the data presentation exactly as it is sent to PostgreSQL, including whitespace and indentation, and also multiple-keys when present (no processing at all is done on the content, only form validation). The jsonb datatype is an advanced binary storage format with full processing, indexing and POSTGRESQL DATA TYPES: ENUM PostgreSQL ENUM Data Type. It’s possible to make an enum type instead, using the following database model now: Be aware that in MySQL there’s no create type statement for enum types, so each column using an enum is assigned its own data type. As you now have a separate anonymous data type per column, good luck maintaining aglobally
SET RETURNING FUNCTIONS AND POSTGRESQL 10 PostgreSQL 10 is now available for everyone to use, and hinted by David Fetter I had to review my previous article on Json and SQL to adapt to Set Returning Functions changes. A Set Returning Function is a PostgreSQL Stored Procedure that can be used as a relation: from a single call it returns an entire result set, much like a subquery or atable.
POSTGRESQL, AGGREGATES AND HISTOGRAMS PostgreSQL and Mathematics. The other day while giving a Practical SQL training my attention drifted to the width_bucket function available as part of the Mathematical Functions and Operators PostgreSQL is offering to its fearless SQL users. Here’s what the documentation says about it: The function width_bucket(op numeric, b1 numeric, b2 numeric, count int) returns (as an int) the OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG SQL REGRESSION TESTS DATABASE NORMALIZATION AND PRIMARY KEYSSEE MORE ON TAPOUEH.ORG THE MODE ORDERED-SET AGGREGATE FUNCTION In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks of multiple genres, and for the analytics we were then pursuing, we wanted to clean the data set and assign a single genre per album. We did that in SQL of course, and didn’t actually edit the data. EXPLORING A DATA SET IN SQL USING TRIGRAMS AGAINST TYPOS POSTGRESQL DATA TYPES: JSON The json datatype, being a text datatype, stores the data presentation exactly as it is sent to PostgreSQL, including whitespace and indentation, and also multiple-keys when present (no processing at all is done on the content, only form validation). The jsonb datatype is an advanced binary storage format with full processing, indexing and PG_RESTORE -L & PG_STAGING On the PostgreSQL Hackers mailing lists, Andrew Dunstan just proposed some new options for pg_dump and pg_restore to ease our lives. One of the answers was talking about some scripts available to exploit the pg_restore listing that you play with using options -l and -L, or the long name versions --list and --use-list. The pg_staging tool allows you to easily exploit those lists too.EVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 EMACS MUSE POWERED BLOG So finaly a blogging software for geeks exists? The problem with communication is that you think it happened. OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMSEE MORE ON TAPOUEH.ORG SQL REGRESSION TESTS DATABASE NORMALIZATION AND PRIMARY KEYSSEE MORE ON TAPOUEH.ORG THE MODE ORDERED-SET AGGREGATE FUNCTION In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks of multiple genres, and for the analytics we were then pursuing, we wanted to clean the data set and assign a single genre per album. We did that in SQL of course, and didn’t actually edit the data. EXPLORING A DATA SET IN SQL USING TRIGRAMS AGAINST TYPOS POSTGRESQL DATA TYPES: JSON The json datatype, being a text datatype, stores the data presentation exactly as it is sent to PostgreSQL, including whitespace and indentation, and also multiple-keys when present (no processing at all is done on the content, only form validation). The jsonb datatype is an advanced binary storage format with full processing, indexing and PG_RESTORE -L & PG_STAGING On the PostgreSQL Hackers mailing lists, Andrew Dunstan just proposed some new options for pg_dump and pg_restore to ease our lives. One of the answers was talking about some scripts available to exploit the pg_restore listing that you play with using options -l and -L, or the long name versions --list and --use-list. The pg_staging tool allows you to easily exploit those lists too.EVENT TRIGGERS
Event Triggers A.K.A The Real Mess. Dimitri Fontaine dimitri@2ndQuadrant.fr February, 3rd 2013 Dimitri Fontaine dimitri@2ndQuadrant.fr Event Triggers February, 3rd 2013 1 / 32 EMACS MUSE POWERED BLOG So finaly a blogging software for geeks exists? The problem with communication is that you think it happened. POSTGRESQL AS A MICROSERVICE The MACI French podcast honoured me with an invitation to a guest appearance on their weekly schedule. As you can imagine, we talked about many things related to PostgreSQL and also reacted to some newsworthy articles carefully curated by the MACI team. One of the topics we discussed in the podcast started with looking at PostgreSQL through the angle of it being one of the POSTGRESQL DATA TYPES: TEXT ENCODING Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion of encoding. So when addressing the text datatype we must mention encoding settings, and possibly also issues. An encoding is a particular representation of characters in bits and bytes. DATABASE NORMALIZATION AND PRIMARY KEYS In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of PostgresQL, so it’s only fair that I would now publish said Primary Key section! So in this article, we dive into Primary Keys as being a cornerstone of databasenormalization.
THE MODE ORDERED-SET AGGREGATE FUNCTION In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks of multiple genres, and for the analytics we were then pursuing, we wanted to clean the data set and assign a single genre per album. We did that in SQL of course, and didn’t actually edit the data. DATABASE MODELIZATION ANTI-PATTERNS Entries in a column (field) are of the same kind. An anti-pattern that fails to comply with those rules means having a multi-valued field in a database schema: create table tweet ( id bigint primary key , date timestamptz, message text , tags text ); Data would then be added with a semicolon separator, for instance, or maybe a pipe | char, or EXPLORING A DATA SET IN SQL Sometimes you need to dive in an existing data set that you know very little about. Let’s say we’ve been lucky to have had a high level description of the business case covered by a database, and then access to it. Our next step is figuring out data organisation, content and quality. Our tool box: the world’s most advanced open source database, PostgreSQL, and its Structured Query BATCH UPDATES AND CONCURRENCY Batch Update, MoMA Collection. The Museum of Modern Art (MoMA) Collection hosts a database of the museum’s collection, with monthly updates. The project is best described in their own words: MoMA is committed to helping everyone understand, enjoy, and use ourcollection.
POSTGRESQL, AGGREGATES AND HISTOGRAMS PostgreSQL and Mathematics. The other day while giving a Practical SQL training my attention drifted to the width_bucket function available as part of the Mathematical Functions and Operators PostgreSQL is offering to its fearless SQL users. Here’s what the documentation says about it: The function width_bucket(op numeric, b1 numeric, b2 numeric, count int) returns (as an int) the WHY IS PGLOADER SO MUCH FASTER? pgloader loads data into PostgreSQL. The new version is stable enough nowadays that it’s soon to be released, the last piece of the 3.1.0 puzzle being full debian packaging of the tool. As you might have noticed if you’ve read my blog before, I decided that pgloader needed a full rewrite in order for it to be able to enter the current decade as a relevant tool. pgloader used to be written EMACS MUSE POWERED BLOG So finaly a blogging software for geeks exists? The problem with communication is that you think it happened.__
* __
* __
* __
* __
__
DIMITRI FONTAINE
POSTGRESQL MAJOR CONTRIBUTOR* __ Blog
* __ About
* __ YeSQL
* __ The Art of PostgreSQL* __ GitHub
* __ Twitter
* __ Categories
* __ RSS
What if you could turn thousands of lines of code intosimple queries?
2020: ONLINE CONFERENCES __ Friday 27 Nov 2020 __ 4 mins read __ PostgreSQL, YeSQL
__ Conferences __ Failover __pg_auto_failover
Among a lot of other changes, the year 2020 brings Online Conferences to us. In the Postgres community too we now record our talks at home and send a video file to be playedto a virtual audience, and sometimes shared later in a platform online. So this year I did participate in Postgres Vision 2020 where I did deliver a talk about The Art of PostgreSQL. This a talk all about the book that I have written and self-publish at The Art of PostgreSQL: learn how to turn thousands of lines of code into simple SQL queries. -------------------------I WROTE A BOOK!
------------------------- LIST POSTGRESQL TABLES USING EXTENSIONS __ Tuesday 12 Nov 2019 __ 2 mins read __ PostgreSQL, YeSQL
__ Extensions __ Catalog Postgres has extensions, and that’s awesome! Of course as the author of CREATE EXTENSION I’m a little biased… just remember that the ability to extend Postgres is way more than just this command. The whole database system has been design from the ground up to allow for extensibility. Parts of the design is to be found in the way you can register new objects at runtime: functions of course, and also data types, operators, index support structures such as operator classes and families, even index access methods! Today’s article shows a query that you can use to list those tables in your schemas that are using a data type which is provided by anextension.
------------------------- POSTGRES CONNECTION STRINGS AND PSQL __ Wednesday 04 Sep 2019 __ 3 mins read __ PostgreSQL, YeSQL
__ psql __ DSN
PostgreSQL connection strings embedded in your application can take two different forms: the key-value notation or the postgresql:// URI scheme. When it comes to using psql though, another form of connection string is introduced, with command line options -h -p -U and environment variable support. In this short article you will learn that you can use either of the three different forms in psql and thus easily copy & paste you application connection string right at the console to test it! ------------------------- THE ART OF POSTGRESQL __ Monday 26 Aug 2019 __ 7 mins read __ PostgreSQL, YeSQL
__ The Art of PostgreSQL I did it again! Today I am releasing the new edition of my book, with a new title: “The Art of PostgreSQL”. I’m very happy (and quite excited) to declare my book as _Generally Available_! The Art of PostgreSQL is the new edition of my previous release, _Mastering PostgreSQL in Application Development_. It contains mostly fixes to the old content, a new title, and a new book design (PDF and paperback). Content wise, The Art of PostgreSQL also comes with a new whole chapter about PostgreSQL Extensions. The new chapter covers extensions such as hstore, pg_trgm, intarray, earthdistance, ip4r, and hll or HyperLogLog, one of the all times favorite extensions of Craig Kerstiens … who made himself available to answer my questions and share his view of PostgreSQL Extensions in aninterview!
------------------------- PREVENTING SQL INJECTIONS __ Saturday 10 Nov 2018 __ 7 mins read __ PostgreSQL, YeSQL
__ Security __ SQL Injection An _SQL Injection_ is a security breach, one made famous by the Exploits of a Mom xkcd comic episode in which we read about _little Bobby Tables_: PostgreSQL implements a protocol level facility to send the static SQL query text separately from its dynamic arguments. An SQL injection happens when the database server is mistakenly led to consider a dynamic argument of a query as part of the query text. Sending those parts as separate entities over the protocol means that SQL injection is no longer possible. ------------------------- GEOLOCATION WITH POSTGRESQL __ Friday 24 Aug 2018 __ 10 mins read __ PostgreSQL, YeSQL
__ Point __ Geolocation __Extensions __ ip4r
We have loaded Open Street Map points of interests in the article The Most Popular Pub Names — which compares PostgreSQL with MongoDB for simple geographical queries, and is part of our PostgreSQL Extensions article series. In today’s article, look at how to geolocalize an IP address and locate the nearest pub, all within a single SQL query! For that, we are going to use the awesome ip4r extension from RhodiumToad.
* __
*
2021 Dimitri Fontaine.__
DIMITRI FONTAINE
PostgreSQL Major Contributor__
Open Source Software Engineer__
France
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0