0

I have uploaded my csv file to https://sqliteonline.com/ and it is currently available as a table. I need to export this data to .db file to use it elsewhere. I tried exporting the table, but I only have choices to export as jason, sql, etc, and not db.

I tried running the command

  create database test;

to try to move the table under it and export but create database test; generated errors. Could you please help me export this as a db file? Alternatively, if you recommend other tools that can get this done that would be great too.

5
  • 1
    That's just a free 3rd party website someone made to allow you to interact with databases online (akin to dbfiddle.uk) for playing around and testing. I don't think anyone here can offer much advice on how to use it other than you shouldn't use it for actual work you want to save - rather you should use a real database instance, such as running SQLite locally. Regardless, it does look like under File there's a Save DB option which downloads a DB file.
    – J.D.
    Oct 3, 2023 at 12:27
  • @J.D. thanks for your feedback. I am working on a research project with limited budget. Do all local database programs have the option to export .db file?
    – User 19826
    Oct 3, 2023 at 15:20
  • 1
    "I am working on a research project with limited budget." - SQLite is free. So is SQL Server Express Edition if you want a centralized server. "Do all local database programs have the option to export .db file?" - When not running them in the cloud, sure, you should have access to the DB files. SQLite is generally a single DB file on your local device that you can copy and move as needed. Not sure what your goal is with exporting it though.
    – J.D.
    Oct 3, 2023 at 15:35
  • @J.D. thanks, would you like to share your answer so that I can accept it?
    – User 19826
    Oct 4, 2023 at 4:59
  • Sure, answer Posted. Thanks!
    – J.D.
    Oct 4, 2023 at 12:04

1 Answer 1

1

I have uploaded my csv file to https://sqliteonline.com/ and it is currently available as a table. I need to export this data to .db file to use it elsewhere.

That's just a free 3rd party website someone made to allow you to interact with databases online (akin to dbfiddle.uk) for playing around and testing. You should use a real database instance, such as running SQLite locally. Regardless, it does look like under File there's a Save DB option which downloads a DB file.

I am working on a research project with limited budget.

SQLite is free. So is SQL Server Express Edition if you want a centralized server.

Do all local database programs have the option to export .db file?

When not running them in the cloud, sure, you should have access to the DB files. SQLite is generally a single DB file on your local device that you can copy and move as needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.