Re: SQL Database Client GUI for Firebird?
On Fri, May 29, 2020 at 11:39 PM linux guy <linuxguy123(a)gmail.com> wrote:
Hi people.
I have a huge CSV spreadsheet. I need to do a bunch of light duty data manipulation.
Sort, total, export, that sort of thing. I could almost do it in the spreadsheet, but it
would be too much copy/paste and the combinations of data I want to get out are
exhaustive.
I'm thinking of importing it into Firebird. I'm looking for a good GUI SQL
client.
Thoughts/ advice ?
TOar ?
DBEaver ?
Good GUI client, you could use it with SQLite and get the job done effectively
Something else ? (Python?)
I prefer Python, particularly Pandas.
import pandas as pd
df = pd.read_csv("/path/to/giant.csv", <other options, but usually
not required>)
Then you can use the Pandas API to do whatever you like really (see
the official docs, very thorough, and easy to understand, full of
examples). If you prefer an SQL interface, you can try installing
`sqldf` alongside pandas, and run SQL inside the pandas DataFrame.
HTH,
--
Suvayu
Open source is the future. It sets us free.