Skip to content

Migrate a MySQL database with the Asagi Schema to SQLite.

Notifications You must be signed in to change notification settings

sky-cake/Meteor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Meteor

Asagi schema support only.

  • Download MySQL database tables to CSVs
  • Import CSVs into SQLite

Install

python3.12 -m pip install sqlalchemy tqdm

Use

  • Configure the script in the bottom of main.py
  • python3.12 main.py

Benchmarks

Python 3.12.4 can insert 1.56 million 4chan posts, including board, images, and threads tables, into SQLite in ~13 seconds.

Reading tables for: g
Pushing board: g
     286,728 it [00:00, 406,030 it/s] # image
      32,881 it [00:00, 252,819 it/s] # thread
   1,562,466 it [00:13, 112,709 it/s] # board
Done

About

Migrate a MySQL database with the Asagi Schema to SQLite.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages