- Joined:
- Apr 16, 2013
- Posts:
- 21,858
- Liked Posts:
- 9,050
Can suck my balls! I feel sorry for people who has to work with it everyday. Its a pain in my mother effing ass!
Microsoft Access!
- Thread starter SilenceS
- Start date
Jester
White Guy
- Joined:
- Aug 21, 2010
- Posts:
- 7,637
- Liked Posts:
- 3,697
Yeah it can do a lot but it is a pain in the arse. I hate how Microsoft rearranges the interface every version, it's fucking annoying.
- Joined:
- Jun 25, 2010
- Posts:
- 20,016
- Liked Posts:
- 9,558
- Location:
- Next to the beef gristle mill
My favorite teams
mySQL FTW
- Joined:
- Aug 21, 2012
- Posts:
- 42,492
- Liked Posts:
- 35,203
Depends on what you are using MS Access for.... for me at work its a nice tool to connect to some of our logging tables or reference tables and it allows me to read/write to those tables much faster and easier than writing queries for every change or read I need to do on those tables.
However, if its all you have for accessing a database.... good god that would be awful.
However, if its all you have for accessing a database.... good god that would be awful.
- Joined:
- Apr 28, 2011
- Posts:
- 7,276
- Liked Posts:
- 4,663
My favorite teams
**** that, Postgres is by far the best RDBMS there is.
- Joined:
- Apr 16, 2013
- Posts:
- 21,858
- Liked Posts:
- 9,050
Learning it for school, but the test wasn't as bad as I thought it would be.
- Joined:
- Jun 25, 2010
- Posts:
- 20,016
- Liked Posts:
- 9,558
- Location:
- Next to the beef gristle mill
My favorite teams
Postgres is a flavor of the month(year to be fair, after a shaky year), and it is indeed good. But it wont have the lasting power of mySQL. This comes from a huge supporter of the Postgresql project(as well as former frustrated hater of the direction mysql was heading in). And both need to look out, mariaDB is cutting all of the fat from both, and outperforming both while retaining compatibility. That's going to be the next flavor of the month when/if its development continues at this pace.
- Joined:
- Jun 19, 2011
- Posts:
- 32,905
- Liked Posts:
- 26,050
If you have a gigantic database, it can be pretty damn nice. Especially if a lot of peon techs are accessing it
- Joined:
- Apr 28, 2011
- Posts:
- 7,276
- Liked Posts:
- 4,663
My favorite teams
Nonsense. 9.3 is amazing. Added JSON support is so nice.
Saying MySQL is on par is nuts. Then add in how nice things like PGpool and PGagent are. MySQL is nice for some things, but if I'm putting up a data mart or data warehouse, it's Postgres all the way. That and does MySQL even do things like Windowing functions?
EDIT: Or CTEs?
EDIT EDIT: Also we've had large production Postgres servers up for years, so flavor of the month? Nah.
- Joined:
- Aug 21, 2012
- Posts:
- 42,492
- Liked Posts:
- 35,203
Aw shit Database throwdown between Crys and Shifty.... I guess I will ref, since I am not sure we have many other Database nerds on the boards 
- Joined:
- Jun 25, 2010
- Posts:
- 20,016
- Liked Posts:
- 9,558
- Location:
- Next to the beef gristle mill
My favorite teams
Aw shit Database throwdown between Crys and Shifty.... I guess I will ref, since I am not sure we have many other Database nerds on the boards
LOL
Well, not fanboying this one. As I said, big fan, user, and at times, developer of both. Like if Shifty responded with "Or Postgres, which I like better", instead of "**** that" when comparing to ....
MS Access :roll:
Access compared to any of the big GPL SQL projects(which dominate and run the internet) is comparing a Sport Motorcycle to a Unicycle with training wheels.
- Joined:
- Apr 4, 2011
- Posts:
- 18,757
- Liked Posts:
- 27,292
- Location:
- Volusia County, FL
My favorite teams
That's probably being generous.
- Joined:
- Apr 28, 2011
- Posts:
- 7,276
- Liked Posts:
- 4,663
My favorite teams
I love Postgres because it makes my job way "easier". Every day I deal with MySQL, Postgres and Oracle servers, from a DBA's perspective, at least mine, Postgres is hands down better. I could see why app devs or web devs would probably not care that much, or at least not utilize a lot of what Postgres offers over some other RDBMS's, but when you're doing the admin, ETL, data modeling, etc, Postgres is just plain better.
As far as Access, yeah that's not even in the race.
My No SQL skills need to get better though. Our app devs have been switching over to Mongo for shunting their data into.
Jerry Cortez211
And1
- Joined:
- Sep 3, 2012
- Posts:
- 2,705
- Liked Posts:
- 271
- Location:
- Chicago
And in my class just started getting into Access, I'm confident about it though
Jester
White Guy
- Joined:
- Aug 21, 2010
- Posts:
- 7,637
- Liked Posts:
- 3,697
Funny you say that, I have been a Database System Administrator for 15 years. I have worked with Oracle, DB2, DB2 LUW, and have been working with Postgres for the past year. It still lacks some of enterprise scale functionality that Oracle and DB2 have, but it can be used as the primary DBMS for 90% of our data needs at a far cheaper cost.
For small and medium size businesses this is 100% the way to go.
- Joined:
- Aug 21, 2012
- Posts:
- 42,492
- Liked Posts:
- 35,203
I wonder if the enormous NSA database storing all of our live's activities is just one gigantic MS Access database :lol:
- Joined:
- Jun 25, 2010
- Posts:
- 20,016
- Liked Posts:
- 9,558
- Location:
- Next to the beef gristle mill
My favorite teams
This message sponsored by Microsoft.
The only reason why anyone uses Access, .net, or any of their garbage development tools, is because of MS sponsorships. Which would be fine, if the tools were half as good as the indoctrinated youths believe when coming out of school.
- Joined:
- Oct 17, 2010
- Posts:
- 15,976
- Liked Posts:
- 6,451
- Location:
- Greenville, NC
I use Open Office Base to put together a simple database to track jobs through the shop. I like it, but I'm not knowledgeable enough to get real fancy.
Iwritecode
Well-known member
- Joined:
- Jun 2, 2011
- Posts:
- 2,002
- Liked Posts:
- 1,094
At my previous job I was given a half-completed Access program and told to see if I could figure out how to make it work. I bought a couple of books and tried to learn it but I couldn't make heads or tails out of it.
Luckily the person that wanted it ended up leaving the company, so I never had to finish it.
Luckily the person that wanted it ended up leaving the company, so I never had to finish it.
- Joined:
- Aug 21, 2012
- Posts:
- 42,492
- Liked Posts:
- 35,203
Ah man that sounds like my first 3 months at my last company... I got hired by possibly the worst manager on the planet, a true Fucktard of all Fucktards.
Everything he wanted me to do was some half thought of, 10-20% complete bullshit that the last guy did not finish cause he got fed up with my old boss and quit within the first month.
I wound up resigning from that job after a year of nonsense, and took a counter to stay under my current manager/director combo, and then the product I work on got bought so we all work for a different company now.
Anyways, I found out recently that there was an office pool on how long it would be before me or the other unlucky dude who got hired under my old fucktard of a boss would last lol. In fact I lasted the year and when I resigned I got the ear of every important Director and VP in the division, cause they wanted me to stay, now I know because they were planning to sell the product and I was the only Operations guy left who knew how to run shit, and I used that to make sure they knew what a clown this manager was. Long story short.... HE GONE