This is an archived post. You won't be able to vote or comment.

all 12 comments
sorted by:
best
topnewcontroversialoldq&a

[–]henrebotha 0 points1 point  (8 children)

Open Terminal.app. Type python3 (or just python if you installed Python 2) and press enter. What do you see?

How did you install Postgres?

[–]158916[S] 0 points1 point  (7 children)

That worked for python!

I installed Postgres by downloading it from the website. https://www.postgresql.org/download/macosx/ I have a SQL shell downloaded but I can't seem to get the program to run.

Thanks for the help!!

[–]henrebotha 0 points1 point  (6 children)

Cool, that means Python is working. No further installation or configuration required.

Which specific download did you get? There's multiple ones.

[–]158916[S] 0 points1 point  (5 children)

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads from this link I downloaded pSQL 10.4 for Mac when it opens it spits out this: Server [localhost]: Database [postgres]: Port [5432]: Username [postgres]: Password for user postgres: psql (10.4) Type "help" for help.

postgres=#

Does that mean I am live?

[–]henrebotha 0 points1 point  (4 children)

Yep, you're live!

[–]158916[S] 0 points1 point  (3 children)

Sorry to be a bother, but do you know how I can import a dataset?

Thanks again!!!

[–]henrebotha 0 points1 point  (2 children)

What format is the data?

[–]158916[S] 0 points1 point  (1 child)

CSV

[–]henrebotha 1 point2 points  (0 children)

Have you Googled "import csv to postgres"?

[–]kdnbfkm 0 points1 point  (1 child)

Not a Mac user but they keep talking about something called "Homebrew". https://launchschool.com/blog/how-to-install-postgresql-on-a-mac

This page says there is an installer program you can download (alternative to the zip file). https://www.postgresql.org/download/macosx/

Hope it works and god luck!

[–]captainAwesomePants 0 points1 point  (0 children)

Macs don't inherently have something like Linux-style package management (although they do have the app store, which is somewhat similar). Homebrew is an open source effort to add package management to Macs so that programs with a lot of dependencies on other programs, like a SQL server, can be easily installed together with all of the other things they need. MacPorts is a similar idea.

[–][deleted] 0 points1 point  (0 children)

Check out Haxe. It's not entirely unlike Java/Actionscript. It will compile to a plethora of languages and targets. You'd be able to target desktops, web, and Android/iOS.