I think this is probably by using a COPY command. Assuming the file is on the same server as Postgres. But from a windows/linux machine, if a user wants to upload the CSV file, I don't see any options in the market.
Ok, but what if we create an analytics dashboard for them. Basically the user will upload a CSV and a dashboard with charts will be created. I too don't know the use case exactly. Just thinking loud here.
Sure, but then you are stepping into the same arena as PowerBI and Tableau if you go that route. Definitely a valid use case, if you are ready to go up against large, well-established players. If you are going there, you'd really need to understand the market and have some solid differentiators -- "You can upload a CSV" won't be one.
even analytics or dashboards are likely still too abstract
you are selling them reduced costs, or ideally more income, based on said analytics. Are they going to be able to make sense of the dashboards to make business decisions? I suspect this is where the gap is
Brick and mortar are more concerned with the day-to-day and prefer to outsource secondary operations they are not experts in. They are generally tech shy, so selling them a analytics solution is difficult
I just found out about this extension that runs your Pg Queries in the background and returns a job id. You can come back later and get results from that job id.
I'm still looking for ways in which this is better than ChatGPT. It says that it's different in the sense that it doesn't shy away from giving you malicious content that might otherwise be useful in harming someone or some system. Let me know how you found it different than the normal GPT.
I trained a chatbot on the Godfather script for example and asked Open AI to give the exact response to a dialogue in the film. I'll open-source that too pretty soon if you guys are interested.
