Best format (not container 7z, rar, etc) to share DB
by jfxk - Wednesday July 17, 2024 at 05:17 AM
#1
Wondering what would be your opinions on the best file format (SQLite? MySQL dump? other?) to share large (more than 10GB) DB for easier import by users, since large CSV/TXT also big headache to import very large datasets.
Reply
#2
sqlite3 is the best i think?
This forum account is currently banned. Ban Length: (Permanent)
Ban Reason: Selling/posting credit/debit cards is not allowed. It may be posted if it's a part of a database.
Reply
#3
(07-17-2024, 05:17 AM)jfxk Wrote: Wondering what would be your opinions on the best file format (SQLite? MySQL dump? other?) to share large (more than 10GB) DB for easier import by users, since large CSV/TXT also big headache to import very large datasets.

@jfxk i think sqlite is faster for those who know how to use it, mysqldump is good but the problem is that if there is any problem with the dump it's a headach to make work, for the CSV/TXT/JSON they are good for users who doesnt have db skills, 
in my opinion sqlite is good
Reply
#4
The best format is the one that is more convenient for a person to use. No installation of specialized programs it CSV/TXT
Reply
#5
Although few answers, think SQlite seems the best option. 

For use I prefer HeidiSQL Portable (OSS https://www.heidisql.com/download.php ) where I don't need to install in Windows. Just download, unzip and run HeidiSQL.exe then can create a new database file and create database and tables, or easier, use the export to database function to copy it from/to MySQL or other large SQL DB in a breeze without worries about charset support, fields mapping etc like in CSV that demand a lot of time.

Just tried the following in 15 seconds (sample 1k data from known leak in this forum):

https://mega.nz/file/dXlWyabB#R0gDbnndb1...keWWm1YNFw

The DB's I may share in future here in the forum, for sure in SQLite.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  REQUEST looking for Chinese Share Holders Database ravi_22_07 0 771 02-23-2025, 12:34 AM
Last Post: ravi_22_07
  Hash Format futuresneak 14 6,668 02-23-2024, 11:52 PM
Last Post: blackplatypus
  Ask about hash format. teddae 21 9,435 11-16-2023, 10:06 AM
Last Post: teddae

Forum Jump:


 Users browsing this thread: