What is the quickest way to import thounsand records to a table?


#1

I’m newbie in DreamFactory,
I have created some schema tables, now I see that we can insert every line to our table. But what if I have thoundsand of record?
I think there is a way to do this better… (I have do some search on Google but can’t find any way to do this)
Thanks for any help.


#2

Hi @nampdn,

DF has phpmyadmin (http://ADDRESS:PORT/phpmyadmin/) its the fastest and easy way. Use user root and the password you chose during installation.


#3

Thanks, but what if I store data as SQLite type?


#4

To perform more “advanced” database operations, I think you must use your server console, web admin and any other DB administration software like DB Browser for SQLite or SQLiteStudio.
In my humble opinion, DF is not a tool for database administration.


#5

Thanks you so much. But will the SQLite Restful API lock for multiple connection at the same time ? (For SELECT only)


#6

Sorry, I dont know.
But, I think the DF doesn’t interfere in DB default behavior (although, it can).

SQLite docs says:

Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.

I hope this helps you. :slight_smile: