search

jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
153 stars 28 forks source link

Table Name in File Tab and Drop Table Button #14

Open birdwing opened 6 years ago

birdwing commented 6 years ago

Would it be possible that in the file tab on notepad++ to display an icon when the file has been read into a database (and possibly show the table name). I know this might be problematic for those of use that run update and delete functions against the table, because then the file and the table are no longer the same, perhaps an icon to indicate that as well?

After working with a lot of different files I noticed that the number of tables keeps going up. There is no easy way to remove a table from the database after you no longer need it.

I'm not suggesting the table automatically be dropped when the file is closed, I recognize there is a use case for having them stay.

Maybe add a button to drop the files associated table from the SQLite database? Right now you have to list the files, then find the table that corresponds to the file you want and drop it manually.

jokedst commented 6 years ago

Hmm good point. There is an obvious memory leak here.

Perhaps a submenu below / instead of "list parsed files" that shows all parsed files, the table name and if the file itself is closed, which allows you to remote it (or all files) from the DB.

Modifying the N++ tab itself I'd have to research

birdwing commented 6 years ago

I've never worked with N++ plugins so I don't know about modifying the tab. A sub-menu might work. Perhaps you could add another window pane along with the CSV Query one like "CSV Tables" that lists all the relative information.

Or maybe adding tabs to the CSV Query pane one for "SQL" and another for "Tables"?