search

electroly / sqlnotebook

Casual data exploration in SQL
https://sqlnotebook.com
MIT License
596 stars 35 forks source link

Column datatype assignment #45

Closed ohmh closed 2 years ago

ohmh commented 2 years ago

It would be great if the datatype of multiple columns can be changed in bulk instead of clicking on each column and changing the datatype when importing csv files for that becomes very tedious with tables of many columns

electroly commented 2 years ago

Hi @ohmh, that is a good idea. I have some ideas for how this could be implemented. I've also considered having it auto-detect the initial data types (while still allowing you to change them) but I'm unsure whether that's desirable behavior.

ohmh commented 2 years ago

Automation would be great but also the ability to manually configure things in an efficient manner is crucial.

electroly commented 2 years ago

This issue should now be fixed in version 1.2.0. Please give it a try. Thanks!