For this project I seem to have ended up with: Oracle Database on my local Machine Snowflake DB through Keboola, cloud hosted on Snowflake MySQL DB through free MySQL database website hosted in the clod. PostgrelSQL through Elephant SQL. Plus ended up with a test DB on SQLLite. Whilst this is great fun logging into lots of different sites and browsers and tools to access all the different databases was a pain, especially as I am sure to working purely in SQL developer. After a quick Google I found DBeaver . As you can see from the above screenshot I have successfully connected to all the above databases from one tool. The tool even handled the downloading and installation of the drivers, I just had to work out the basic stuff and I was in. Now I just need to work out what I want to build in each database and how it fits into the overall project I am working on.
Posts on Gen AI, Data Warehousing, automation, DBs, ETL tools, tuning and streamlining.