1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
|
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="../../docs-assets/ico/favicon.png">
<title>pgloader</title>
<!-- Bootstrap core CSS -->
<link href="dist/css/bootstrap.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="dist/carousel.css" rel="stylesheet">
</head>
<!-- NAVBAR
================================================== -->
<body>
<div class="navbar-wrapper">
<div class="container">
<div class="navbar navbar-inverse navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">pgloader</a>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Home</a></li>
<li><a href="howto/quickstart.html">Quick Start</a></li>
<li><a href="howto/pgloader.1.html">Reference documentation</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Advanced HowTos <b class="caret"></b></a>
<ul class="dropdown-menu">
<li class="dropdown-header">Plain Files</li>
<li><a href="howto/csv.html">CSV</a></li>
<li><a href="howto/fixed.html">Fixed format</a></li>
<li><a href="howto/geolite.html">Geolite</a></li>
<li class="divider"></li>
<li class="dropdown-header">Databases</li>
<li><a href="howto/dBase.html">dBase</a></li>
<li><a href="howto/sqlite.html">SQLite</a></li>
<li><a href="howto/mysql.html">MySQL</a></li>
</ul>
</li>
<li><a href="download.html">Download</a></li>
<li><a href="sponsors.html">Sponsors</a></li>
<li><a href="pgloader-moral-license.html">License</a></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<!-- Carousel
================================================== -->
<div id="myCarousel" class="carousel slide" data-ride="carousel">
<!-- Indicators -->
<ol class="carousel-indicators">
<li data-target="#myCarousel" data-slide-to="0" class="active"></li>
<li data-target="#myCarousel" data-slide-to="1"></li>
</ol>
<div class="carousel-inner">
<div class="item active">
<img data-src="holder.js/900x400/auto/#777:#7a7a7a">
<div class="container">
<div class="carousel-caption">
<h1>Load data into PostgreSQL. Fast.</h1>
<p>Pgloader loads data into PostgreSQL using the
COPY <b><i>streaming</i></b> protocol, and doing so with
separate threads for reading and writing data. Asynchronous
IO, compiled to the metal programming language.</p>
</div>
</div>
</div>
<div class="item">
<img data-src="holder.js/900x400/auto/#666:#6a6a6a">
<div class="container">
<div class="carousel-caption">
<h1>Load data into PostgreSQL. Any Data.</h1>
<p>pgloader knows how to read data from MySQL, SQLite or dBase
databases, and knows how to discover the schema and properly
cast data types over. It also knows how to read CSV files in
several definitions of CSV, and fixed columns files.</p>
</div>
</div>
</div>
</div>
<a class="left carousel-control" href="#myCarousel" data-slide="prev"><span class="glyphicon glyphicon-chevron-left"></span></a>
<a class="right carousel-control" href="#myCarousel" data-slide="next"><span class="glyphicon glyphicon-chevron-right"></span></a>
</div><!-- /.carousel -->
<!-- Marketing messaging and featurettes
================================================== -->
<!-- Wrap the rest of the page in another container to center all the content. -->
<div class="row">
<div class="col-md-3"> </div>
<div class="col-md-6">
<h2>Why did pgloader get so much faster?</h2>
<video id="pg-lt" width="100%" controls data-title="Lightning Talks">
<source src="http://medias.ircam.fr/stream/ext/video/files/2014/05/13/ELSAA_6_mai2.mov.webm#t=57,357" type="video/webm" />
<source src="http://medias.ircam.fr/stream/ext/video/files/2014/05/13/ELSAA_6_mai2.mov.mp4#t=57,357" type="video/mp4" />
<source src="http://medias.ircam.fr/stream/ext/video/files/2014/05/13/ELSAA_6_mai2.mov.ogg#t=57,357" type="video/ogg" />
</video>
</div>
</div>
<div class="container marketing">
<!-- START THE FEATURETTES -->
<!-- <hr class="featurette-divider"> -->
<div class="row featurette">
<div class="col-md-7">
<h2 class="featurette-heading">Migrate from MySQL to PostgreSQL. <span class="text-muted">In one command.</span></h2>
<p class="lead">Given a MySQL connection string, pgloader query
the catalogs to list your tables, constraints and indexes and know
how to transform this schema into a PostgreSQL equivalent,
applying advanced casting rules that you can edit in the
command.</p>
<p>Migrate some <i>tinyint<i> to <tt>boolean</tt> and some others
to <tt>smallint</tt> all from the same tool!</p>
<p><a class="btn btn-default" href="howto/mysql.html" role="button">View details »</a></p>
</div>
<div class="col-md-5">
<img class="featurette-image img-responsive" src="img/type-casting-machine.500.jpg" alt="MySQL to PostgreSQL with Custom Type Casting">
</div>
</div>
<hr class="featurette-divider">
<div class="row featurette">
<div class="col-md-5">
<img class="featurette-image img-responsive" src="img/csv_text.png" alt="CSV data format">
</div>
<div class="col-md-7">
<h2 class="featurette-heading">Load any CSV file. <span class="text-muted">Real quick.</span></h2>
<p class="lead">The current version of pgloader is up to <b><i>ten
times faster</i></b> than the previous one. The new command syntax
is really powerful, and as it's different enough from the previous
version, pgloader includes a command line switch to upgrade your
setup for you.</p>
<p><a class="btn btn-default" href="howto/csv.html" role="button">View details »</a></p>
</div>
</div>
<hr class="featurette-divider">
<div class="row featurette">
<div class="col-md-7">
<h2 class="featurette-heading">Transform your data. <span class="text-muted">While streaming.</span></h2>
<p class="lead">pgloader includes reformating modules allowing you
to reformat your data, such as transforming a couple of integer
columns into a single <i>ip address</i>, or a couple of floats
into a single <i>point</i>. Of course, you can add any
transformation you like and easily get to use it with
pgloader loading your code!</p>
<p><a class="btn btn-default" href="howto/geolite.html" role="button">View details »</a></p>
</div>
<div class="col-md-5">
<img class="featurette-image img-responsive" src="img/huge-full-outer-join.gif" alt="Transform Data">
</div>
</div>
<hr class="featurette-divider">
<!-- /END THE FEATURETTES -->
<!-- FOOTER -->
<footer>
<p class="pull-right"><a href="#">Back to top</a></p>
<p>© 2013-2014 Dimitri Fontaine. ·</p>
</footer>
</div><!-- /.container -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
<script src="dist/js/bootstrap.min.js"></script>
<!-- <script src="docs-assets/js/holder.js"></script> -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-47059482-2', 'tapoueh.org');
ga('send', 'pageview');
</script>
</body>
</html>
|
