Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

duckdb import script #948

Open
adsharma opened this issue Jan 10, 2025 · 0 comments
Open

duckdb import script #948

adsharma opened this issue Jan 10, 2025 · 0 comments

Comments

@adsharma
Copy link

Thank you for maintaining this database.

I created an import to duckdb script. Leaving it here just in case someone finds it useful.

The db is about 10% smaller:

 18M	world.db
 20M	world.sqlite3

Two notes:

  • inserting created_at/updated_at into duckdb directly from sqlite errors out due to an issue I don't completely understand
  • I rewired all the ids to a global_seq, like wikidata. This was necessary for my use case.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant