pgloader.io

pgloader.org

pgloader

http://www.pgloader.org/howto/sqlite.html

Loading SQLite files with pgloader. The SQLite database is a respected solution to manage your data with. Its embeded nature makes it a source of migrations when a projects now needs to handle more concurrency, which PostgreSQL. Is very good at. pgloader can help you there. To load data with pgloader. You need to define in a. The operations in some details. Here's our command:. You can see the full list of options in the pgloader reference manual. With a complete description of the options you see here.

pgloader.org

pgloader

http://www.pgloader.org/howto/geolite.html

Loading MaxMind Geolite Data with pgloader. Provides a free dataset for geolocation, which is quite popular. Using pgloader you can download the lastest version of it, extract the CSV files from the archive and load their content into your database directly. To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading the Geolite data:. You can see the full list of options in the pgloader reference manual. Note that while the. Datatype, so the pgload...

pgloader.org

pgloader

http://www.pgloader.org/howto/fixed.html

Loading Fixed Width Data File with pgloader. Some data providers still use a format where each column is specified with a starting index position and a given length. Usually the columns are blank-padded when the data is shorter than the full reserved range. To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading Fixed Width Data, using a file provided by the US census. You can find more files from them at the Census 2000 Gazetteer Files.

blog.tapoueh.org

Expertise PostgreSQL

http://blog.tapoueh.org/blog/2015/02/09-back-from-fosdem-2015

Monday, February 09 2015. My First Slashdot Effect. A pgDay in Paris! Back From FOSDEM 2015. Edition has been awesome this year, the usual mix of meeting with old friends, talking about interesting topics, seeing tremendous activity in all Open Source domains, and having Belgium beers in the evenings. On the Friday before the real FOSDEM event our own PostgreSQL Europe. Organized a one-day event, the FOSDEM PGDAY. In the context of dealing with database migrations. PostgreSQL User Group, Paris Meetup.

blog.tapoueh.org

Expertise PostgreSQL

http://blog.tapoueh.org/blog/2015/05/02-ql-to-deb

Saturday, May 02 2015. PostgreSQL au JUG de Montpellier. Common Lisp users are very happy to use Quicklisp. When it comes to downloading and maintaining dependencies between their own code and the librairies. Sometimes I am pointed that when compared to other programming languages Common Lisp is lacking a lot in the. Area After having had to package about 50 common lisp librairies for debian. I can tell you that I politely disagree with that. It's all automated in the ql-to-deb. Vagrant/build/bin/ql-to-d...

blog.tapoueh.org

Expertise PostgreSQL

http://blog.tapoueh.org/conferences

I've now been presenting my development or activities at a bunch of Conferences. Often enough that I though I would list them here. Image from http:/ commons.wikimedia.org/wiki/File:BlankMap-World-2009.PNG. Dimitri Fontaine is a PostgreSQL Major Contributor. Design, review, Extensions. He contributes to Skytools. PGQ, Londiste) and develops pgloader. Mostly related to PostgreSQL. Or both). Dimitri works at 2ndQuadrant. Postgresql meetup, paris, france. Between now and then! All Your Base Conference 2015.

pgloader.com

pgloader

http://www.pgloader.com/howto/dBase.html

Loading dBase files with pgloader. The dBase format is still in use in some places as modern tools such as. Offer some level of support for it. Speaking of support in modern tools, pgloader is right there on the list too! To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading a dBase file, using a file provided by the french administration. You can find more files from them at the Insee. With a complete description of the options you see here.

pgloader.com

pgloader

http://www.pgloader.com/howto/fixed.html

Loading Fixed Width Data File with pgloader. Some data providers still use a format where each column is specified with a starting index position and a given length. Usually the columns are blank-padded when the data is shorter than the full reserved range. To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading Fixed Width Data, using a file provided by the US census. You can find more files from them at the Census 2000 Gazetteer Files.

pgloader.org

pgloader

http://www.pgloader.org/howto/dBase.html

Loading dBase files with pgloader. The dBase format is still in use in some places as modern tools such as. Offer some level of support for it. Speaking of support in modern tools, pgloader is right there on the list too! To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading a dBase file, using a file provided by the french administration. You can find more files from them at the Insee. With a complete description of the options you see here.

pgloader.com

pgloader

http://www.pgloader.com/howto/geolite.html

Loading MaxMind Geolite Data with pgloader. Provides a free dataset for geolocation, which is quite popular. Using pgloader you can download the lastest version of it, extract the CSV files from the archive and load their content into your database directly. To load data with pgloader. You need to define in a. The operations in some details. Here's our example for loading the Geolite data:. You can see the full list of options in the pgloader reference manual. Note that while the. Datatype, so the pgload...