d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Postgre Sql Database
Add Reply New Topic New Poll
Member
Posts: 12,080
Joined: May 3 2017
Gold: Locked
Trader: Scammer
Jun 14 2017 07:06pm
Anyone know what this does?
Member
Posts: 8,110
Joined: Sep 23 2006
Gold: 3,558.23
Jun 14 2017 07:58pm
It's a database... It holds data.
Member
Posts: 12,080
Joined: May 3 2017
Gold: Locked
Trader: Scammer
Jun 14 2017 08:02pm
Quote (Qord @ Jun 14 2017 09:58pm)
It's a database... It holds data.


Ya but how does it work?
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
Jun 14 2017 08:08pm
Quote (Zekdawg @ Jun 14 2017 10:02pm)
Ya but how does it work?


with regards to what? are you asking how you use it? it's a relational model and you can use sql.

if you wanna know the inner workings, i have good news. it's open source. https://www.postgresql.org/docs/devel/static/git.html
Member
Posts: 12,080
Joined: May 3 2017
Gold: Locked
Trader: Scammer
Jun 14 2017 09:42pm
Quote (carteblanche @ Jun 14 2017 10:08pm)
with regards to what? are you asking how you use it? it's a relational model and you can use sql.

if you wanna know the inner workings, i have good news. it's open source. https://www.postgresql.org/docs/devel/static/git.html


Storing large quantities of numbers and outputting usable data into categories to interpret the numbers

For example:
Marathon splits
Poker hands
Late minutes
Weight gain/loss

This post was edited by Zekdawg on Jun 14 2017 09:48pm
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
Jun 14 2017 11:31pm
Quote (Zekdawg @ Jun 14 2017 11:42pm)
Storing large quantities of numbers and outputting usable data into categories to interpret the numbers

For example:
Marathon splits
Poker hands
Late minutes
Weight gain/loss


so you're asking how to use sql? that's progress. you can look up tutorials on how to use sql (create table, insert, select). what kind of analysis are you trying to do? how much data are we talking about; hundreds, millions, trillions of data points? i assume you have some other language (eg: python) you're going to use to "interpret" the data?
Member
Posts: 374
Joined: Mar 13 2017
Gold: 1,070.70
Jun 15 2017 03:11am
It`s just a database management system like many others (from an external standpoint)
Learning how it actually works is like understanding how the brain of an archivist works when he`s on duty, won`t really help with your needs given the kind of questions made here. What you need is to have and make use of an archive (db), not understand the deep logic beneath.
Member
Posts: 36,123
Joined: Jul 18 2008
Gold: 2,407.00
Jun 15 2017 03:45am
Quote (Zekdawg @ Jun 14 2017 10:42pm)
Storing large quantities of numbers and outputting usable data into categories to interpret the numbers

For example:
Marathon splits
Poker hands
Late minutes
Weight gain/loss



Structured Query Language (SQL) is a standard for storing data in individual tables and linking them together based on shared attributes. PostgreSQL is a database that uses the SQL standard. To learn how to use Postgres you will need to learn SQL.
Member
Posts: 18,087
Joined: Dec 10 2007
Gold: 5,639.46
Jun 16 2017 11:45am
I have a access to stata v14 license if needed, pm me. (assuming you need to crunch an insane amount of obs.)

however I'm assuming you know what parameters to sort it by, not a programmer so unsure what SQL is about.

This post was edited by Arcolithe on Jun 16 2017 11:52am
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll