dawdle: Generates DDL suggestions based on a CSV file

[ database, library, mit, program ] [ Propose Tags ]

Generates DDL suggestions based on a CSV file

[Skip to Readme]


Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees


  • No Candidates
Versions [RSS],,
Dependencies base (>=4.8 && <4.9), dawdle (==, filepath (>=, parsec (>=3.1.8 && <3.2), pretty (>=1.0 && <1.2), text (>= && <1.3), time (>=1.4 && <1.6) [details]
License MIT
Author Arnon Shimoni
Maintainer arnon.shimoni@gmail.com
Category Database
Home page https://github.com/arnons1/dawdle
Source repo head: git clone https://github.com/arnons1/dawdle.git
Uploaded by arnon at 2015-12-05T22:58:40Z
Distributions NixOS:
Executables dawdle
Downloads 2021 total (1 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs available [build log]
Last success reported on 2015-12-05 [all 1 reports]

Readme for dawdle-

[back to package description]

Dawdle - the DDL suggestor tool

Meant as a tool for analyzing CSVs and suggesting a DDL. Generates an executable called dawdle once installed.

Usage examples

$ dawdle --input="example_with_comma.csv" --with-header -s "," This means analyze the file example_with_comma.csv, assume the first line is the header and use a comma as a separator. The example output is

create table example_with_comma (id int not null,
                                 name varchar(65) not null,
                                 created_at datetime not null,
                                 updated_at datetime not null)

To see all command line flags, run $ dawdle --help.


Currently, the syntax is basic(-ish) SQL. Supported types are:

  • tinyint
  • smallint
  • int
  • bigint
  • real
  • float
  • date
  • datetime (==timestamp)
  • varchar