Hadith SQL database dump for Sanad, collected from various sources including Islam Ware Compiled by Hendy Irawan.
Sources:
Copyright (C) 2006-2014 Islam Ware
Hadith files signed by Hendy Irawan using Hendy Irawan [email protected] key 5A9AC703 are available at https://github.com/ceefour/hadith-islamware
-
Install PostgreSQL 9.5 or later.
-
Extract
literal-hadith.tsv.xz
. You can use 7-Zip or XZ Utils. -
Create the necessary tables using https://github.com/soluvas/sanad SQL schema migration tools. For PostgreSQL you can quickly use https://github.com/soluvas/sanad/blob/master/export/sanad.schema.sql
-
Import data using
psql
andCOPY
(PostgreSQL server's) or\copy
(locally) command:\copy sanad.hadithcollection from 'hadithcollection.tsv' (format csv, delimiter E'\t', header false, escape E'\\', encoding 'UTF-8') \copy sanad.hadith from 'hadith.tsv' (format csv, delimiter E'\t', header false, escape E'\\', encoding 'UTF-8') \copy sanad.literal from 'literal-hadith.tsv' (format csv, delimiter E'\t', header false, escape E'\\', encoding 'UTF-8') \copy sanad.spellingproperty from 'spellingproperty-hadith.tsv' (format csv, delimiter E'\t', header false, escape E'\\', encoding 'UTF-8') \copy sanad.authenticityproperty from 'authenticityproperty-hadith.tsv' (format csv, delimiter E'\t', header false, escape E'\\', encoding 'UTF-8')