Profile

Cover photo
Jake Charles
Works at University of Nebraska-Lincoln College
Attends University of Nebraska
34 followers|13,626 views
AboutPostsPhotosVideos

Stream

Jake Charles

Discussion  - 
 
cool any linux gamers?
1
Add a comment...
In his circles
114 people
Have him in circles
34 people
Cleiton Santos Reis's profile photo
Jason Murphy's profile photo
Hari Kumar's profile photo
Riku Kenshi's profile photo
Tyler Keohane's profile photo
Aleksandar Savic's profile photo
海 棠's profile photo
Charlie Perez's profile photo
 
Hello, I've never looked into postgreSQL, but this group seems to highlight it well. Can someone tell me all the advantages/disadvantages of it? Currently I use MySQL mainly because it was thrown with php when I was learning php. Thanks :)
1
Bernard Fischer's profile photoMarco Schilling's profile photoMichael Maraist's profile photoHolger Mitterwald's profile photo
5 comments
 
Mysql v.s. postgres (my take)

Postgres Pros:
* It's GIS plugin is the most complete I've seen of even commercial tools.
* The advanced index support [now] bests myql (at least as of 9.2, which finally supported covering indexes).  I'm sure Oracle has a couple advantages for specialized needs, but I'm not familiar enough with Oracle.
* The system defaults to highly-robust, but can be tuned down (based on hardware / risk-tolerance) to higher performance
* Using RDBMS raid solutions, you can scale moderately
* Using classic sharding techniques, you can scale along with NoSQL solutions (of course, this isn't postgres specific)
* VERY good graphic editor (pgadmin), gives VERY good remote diagnostic support.
* Pretty good integration with 3rd party credential systems
* Great support for schema's (e.g. namespaces) "select * from project.mytable", unlike mysql which only supports databases
* Great stored-procedure-language support
* NO LICENSE ISSUES!!! (for commercial products this is a god send)

Mysql Pros:
* pluggable data-stores (gzip,csv,blackhole,commercial,custom)
* NoSQL back-doors (e.g. with INNODB)
* optional single-file consolidated data-store (INNODB) (postgres produces THOUSANDS of files which have a latency for file-open operations)
* linear append of "table-space" across raw partitions
* RDBMS "cheats" that help performance when you need it (can corrupt data if you don't know what you're doing)
* can store rows in primary key order (avoids 1 extra index)
Add a comment...
People
In his circles
114 people
Have him in circles
34 people
Cleiton Santos Reis's profile photo
Jason Murphy's profile photo
Hari Kumar's profile photo
Riku Kenshi's profile photo
Tyler Keohane's profile photo
Aleksandar Savic's profile photo
海 棠's profile photo
Charlie Perez's profile photo
Work
Occupation
Game/Software/Web developer
Employment
  • University of Nebraska-Lincoln College
    Transit and Parking Troll, 2013 - present
  • Delta Club
    CEO, 2011 - 2013
Basic Information
Gender
Male
Story
Tagline
Computer nerd, gamer, motorcycle lover
Introduction
This is possibly Jake, hopefully. You know, the dude that enjoys trolling and messing around with people :D
Bragging rights
I'm more crazier than you
Education
  • University of Nebraska
    Computer Science, 2013 - present
Links