1. Formicola
  2. Pres-sale questions about Droptables
  3. Wednesday, 04 December 2019
  4.  Subscribe via email
I'm a curious about how the data from sheets/tables are stored. For my application I'd like the ability to query the data collected from the sheets tables/later in mysql. Is the data stored in a manner that will allow for this?
Responses (3)
Accepted Answer Pending Moderation
Hi,

Thanks for contacting us here about this extension.

I'm a curious about how the data from sheets/tables are stored. For my application I'd like the ability to query the data collected from the sheets tables/later in mysql. Is the data stored in a manner that will allow for this?

Yes, the data will be stored in the table with the prefix droptables_ so you can query data in mysql.
However, be careful with the query, it could damage your database.

Thanks a lot!
Cheers,
Accepted Answer Pending Moderation
Thanks! But it seems all of the data for an entire sheet ends up in one field in the database, can that be right? The data for the entire sheet is in the "datas" column/field of "droptables_tables" table? Is that right?

IS that the best way to layout the data? What is the approximate max number of records a sheet can handle?

Thanks!
Accepted Answer Pending Moderation
Hi,

Thanks for getting back to me with more information.

But it seems all of the data for an entire sheet ends up in one field in the database, can that be right? The data for the entire sheet is in the "datas" column/field of "droptables_tables" table? Is that right?

IS that the best way to layout the data? What is the approximate max number of records a sheet can handle?


Yes, all data is stored at datas columns. Our droptables could handle approximate 10k cells.
I'm not sure about the technical issues, if you confuse something, please drop us a ticket (menu Support > Ticket support).
Our developer in charge will take a look at that.

Thanks a lot!
Regards,
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!