4 ms·
Ask HN: How do you manage long list of emails?
I have 2 databases, one for registered users and one for all purchases ever done. I get an updated csv weekly for each one, yeah I know.
I'm looking for an easy to use tool where I could load both csv files and visually do queries to answer questions like:
"Show me all emails from registered users that completed purchases in the last 30 days"
or
"Show me all users that never purchased anything"
Currently I load these 2 in a database and perform queries manually. Another colleague just load them on Excel and do lots of VLOOKUP calls.
Is there a tool available to do this kind of analysis quickly and easy, preferably visual?
- moron4hire 12y agoMicrosoft Access is built for this sort of work. Or so I've been told. I don't use it. I usually start with a SQL database myself. But you said you wanted something visual.
- jesusmichael 12y agoHow would any tool know what report you need? MySQL is free and has reporting tools, so you can build reusable reports
- bluerail 12y agoEvery database provides an way to generate queries and reports.. It will be an GUI tool to make admin tasks more easier.. Install Yours..