stackexchange-dump-to-postgres icon indicating copy to clipboard operation
stackexchange-dump-to-postgres copied to clipboard

Python scripts to import StackExchange data dump into Postgres DB.

Results 6 stackexchange-dump-to-postgres issues
Sort by recently updated
recently updated
newest added

Bumps [lxml](https://github.com/lxml/lxml) from 4.6.3 to 4.9.1. Changelog Sourced from lxml's changelog. 4.9.1 (2022-07-01) Bugs fixed A crash was resolved when using iterwalk() (or canonicalize()) after parsing certain incorrect input. Note...

dependencies

I just want to generate the SQL files from XML. Is that possible? I ran the below command. ``` $ python3 load_into_pg.py -t Badges -f Badges.xml This will drop the...

This is a feature request. The current behavior is that a confirmation prompt is shown whenever the script is used. I think that it would be less redundant if the...

This is a feature request. I think this would be useful for those users that have a very slow computer and are loading a big file (e.g. The Stack Overflow...

# Prologue I've noticed that `*_pre.sql` files have two statements: `DROP TABLE` and `CREATE TABLE`. See some examples below. https://github.com/Networks-Learning/stackexchange-dump-to-postgres/blob/49d8358a83bb573c63c2715b122afb2fca98376c/sql/Users_pre.sql#L1-L2 https://github.com/Networks-Learning/stackexchange-dump-to-postgres/blob/49d8358a83bb573c63c2715b122afb2fca98376c/sql/Badges_pre.sql#L1-L2 https://github.com/Networks-Learning/stackexchange-dump-to-postgres/blob/49d8358a83bb573c63c2715b122afb2fca98376c/sql/Tags_pre.sql#L1-L2 These files are executed in the `public` schema...

Hi Team, Could you please help me with the below error when trying to run python load_into_pg.py? Am I missing something? Traceback (most recent call last): File "load_into_pg.py", line 413,...