Mot-clé - postgres

Fil des billets - Fil des commentaires

Around the Web - March 2016 - Javascript, Citus DB and Dependencies

Javascript An opinionated State of the Art Javascript in 2016 : you may agree or not, at least, author justifies it. Don't know React ecosystem to have an opinion on this. Postgres Citus DB, a scalable and distributed version of Postgres, is going opensource with the release of the 5th version.  […]

Lire la suite

Around the Web - January 2016 - Website obesity crisis, AngularJS & Postgres

Website ObesityWebsite obesity crisis : transcript of a talk (video can be seen too from the link) about webperformance, bloated websites and how fat sites become for almost no real value for end users. Long but funny and instructive. It makes you think on how complex, fat and bloated the web is  […]

Lire la suite

Around the Data - September 2015 - SQL, NoSQL, BigData and streaming

Having new activities around big-data topics from this month, I'll publish here also my findings on this topic.So the "Around the Web" edition should be still be published on every last wednesday of the month and the "Around the Data" series should be published every wednesday in  […]

Lire la suite

Around the Web - March 2015

Browser A review from the Internet Explorer team where they explain why and how they created "Spartan", the new rendering engine for coming new Microsoft browser Making it easier for Enterprise customers to upgrade to Internet Explorer 11 — and Windows 10 : Tips from/for sysadmin /  […]

Lire la suite

Postgresql 9.3.5 pour Debian Wheezy et architecture armhf (raspberry, cubieboard, cubietruck, etc)

La fondation Postgres ne fournit des paquets debian/ubuntu que pour les architectures i386/x86_64 ; Voulant avoir une version 9.3 pour mes projets sur carte Raspberry / Cubietruck, j'ai donc recompilé les paquets sur la base des informations fournies ici que je complète. ### add postgre’s sources to  […]

Lire la suite

MySQL/Postgres Roundup 18/9

On MySQL side, or should I say MariaDB one : Google swaps out MySQL, moves to MariaDB : beyond the significative reference for MariaDB and the fact that Google will sustain his effort to patch MariaDB as they did for MySQL, the question that raised for me was : how long will Percona go with MySQL ?  […]

Lire la suite

Postgres > Major security issue > PostgreSQL 9.2.4, 9.1.9, 9.0.13 and 8.4.17 released

For those using Postgres, a minor release was made yesterday fixing some major security issues ; everyone is strongly recommended to upgrade its postgres server immediatly ; especially if your server is accessible from outside of your network ; if you are hosted internally, it's safe to upgrade but  […]

Lire la suite

Postgres Roundup - 13/3

While skiing this week, you'll only have one blog post from me this week. So, I let you discover the Postgres world with some interesting resources. For those who don't know Postgres, it's an opensource object relational database management system, initiated in 1995 and which know a rise since  […]

Lire la suite

Database : Use the index, luke !

Disclamier : I'm not a SQL Guru, nor DBA but as I saw the document being quoted several times, it should have some revelancy. Use the index is about best practices on SQL indexations and optimisations and content is both in English and French : Use the index, luke (English) Use the index, luke  […]

Lire la suite

Postgres Array type

Beyond traditionnal data types (integer, text, boolean, etc), Postgres support some other interesting types (network, geographical, etc) and one I discovered a few weeks ago : arrays. Idea is simple : instead of storing a single value in a colum, you can store several ones. Yes several ! You don't  […]

Lire la suite

Haut de page