How can i set a database field to "medium text" via DB Manager

Wappler General Need Help
1

I assume the possible answer to this is you cant but i will ask anyway

I am playing with the forum docs files and importing them into a database.

However, at least 1 of the html is more than 64K characters. As a result ab import dfailes as this exceeds the size of a TEXT field.

I have updated the html field from text (as set by db manager) to medium text via an external db manager however wondered.

Is it possible to do this inside the Wappler dataabase manager?

If not, should it be? Feature request?

2

I would modify the generated migration file to set a custom column type (or medium text in this case, if Knex supports such nomenclature)

There's a feature request for the ability to create custom migration files

3

I was looking for a Wappler visual solution, not a code solution in case i had missed something in the Database Manager

Knex supports medium text. easy enough to edit knex files. I dont see the solution as having to mess about with migration files as that, in my mind, defeats the whole concept of a Visual App Builder.

Unless anyone else knows an answer i guess it's a FR to add it to the interface.
For the meantime it's an easy change with an external editor as a one off.

1 Like