-
Going SQL: Postgres (3/3) – Now with R
For the past two Blog entries, we spent time preparing for today: We want to use a Postgres SQL Database backend to work with our JSON data, from R. Before we continue… We’re still missing one piece: the table(s) in the Database. Let’s tackle that very quickly for today, as the focus will be on…
-
Going SQL: Postgres (2/3)
Last week we got a Container up and running with a Postgres SQL Server in it. We’re going to need a Database client to check it. At this point, in theory, we could use some R package (more on that later) to interact with our DBMS container, but instead we’ll go for a Visual client…
-
Going SQL: Postgres (1/3)
Intro We tested (very quickly) a MongoDB “No SQL” backend in a former post. But many a time, good’ol SQL will be just good enough for a Backend. In the “Data Science” world, SQL is right up in the top list of key concepts. So let’s make a point to consider it in this Blog.…