Version 3.6.0
Qt Version 4.8.6
SQLite Version 3.8.9
Mac OS X 10.10.3
With large CREATE TABLE statements, the interface kinda messes up in those two interfaces (Database Structure tab, and the right side window, DB Schema), as it tries to show the full CREATE TABLE statement with all the newlines, tabs and spaces included. These CREATE TABLE statements are created by SQLAlchemy, so thats why they are formatted that way, but it theoretically could happen with manual written statements too if people like them to look pretty in the code.
Easier to show a screenshot: http://i.imgur.com/8bCmexZ.png
I would suggest making it so that the Database Structure tab, all the 'tables' are not so far apart (as it shows the large Create Table statement by default, and maybe have that as a drop down arrow as a child of the table, so it doesn't mess up the formatting/spacing of the table by default?
And also for the DB Schema side window on the right, i dont think there is a need to show the full CREATE TABLE statement anyway, as you are already parsing out the individual columns anyway and showing the relevant part (per the column) right next to the column anyway. Maybe add entries for Foreign Keys and you won't need the whole CREATE TABLE statement?
With large CREATE TABLE statements, the interface kinda messes up in those two interfaces (Database Structure tab, and the right side window, DB Schema), as it tries to show the full CREATE TABLE statement with all the newlines, tabs and spaces included. These CREATE TABLE statements are created by SQLAlchemy, so thats why they are formatted that way, but it theoretically could happen with manual written statements too if people like them to look pretty in the code.
Easier to show a screenshot: http://i.imgur.com/8bCmexZ.png
I would suggest making it so that the Database Structure tab, all the 'tables' are not so far apart (as it shows the large Create Table statement by default, and maybe have that as a drop down arrow as a child of the table, so it doesn't mess up the formatting/spacing of the table by default?
And also for the DB Schema side window on the right, i dont think there is a need to show the full CREATE TABLE statement anyway, as you are already parsing out the individual columns anyway and showing the relevant part (per the column) right next to the column anyway. Maybe add entries for Foreign Keys and you won't need the whole CREATE TABLE statement?