Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

postgres rules everything around me

also get out you're a fuckin terrible poster

Adbot
ADBOT LOVES YOU

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

graph im requestin' a pity ban for the op here

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

LP0 ON FIRE posted:

who cares, sql is shite that needs to be used sometimes, and it's very boring

SQL is more important to the modern economy than anything you do on the reg

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

im enjoying* the op taking the anti-shaggar gimmick in one thread and the shaggar gimmick in another



*not in the least

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

BangersInMyKnickers posted:

mongodb, the database of idiots who think fat32 permissions are too complicated

write permission equivalent to /dev/null, read permission equivalent to /dev/zero

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

Smythe posted:

This thread while Tori is probed? Cowardly move, bitch.

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

qhat posted:

this has nothing to do with gimmicks. to tell you the truth i really don't like windows poo poo but i have to hand it to microsoft, SQL Server is ridiculously versatile.

you're out of your depth.

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

qhat posted:

sounds like you have something interesting to say about this database technology. let's hear it then
I will GRANT that mssql is better than your posts

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

paying for oracle DB indirectly contributed to a federal judge learning java, so that's a mega argument in one column or another for oracle, but I can't tell which tbqh

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

yeah man gotta compress those tables so they fit in the pipes better

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

spectres of autism posted:

more like blunderdome

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

wish the OP would denormalize he self

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

my org actively uses FileMaker, and not as legacy software

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

Bloody posted:

we use a combination of xlsx, cvs, and mat files stored in SVN

lomarfdb

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

Shaggar posted:

sql express is fully featured sql server w/ a 10gb/db limit. its real good for small timey personal things

sql express train directly into my ballsack

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

qhat posted:

one thing that annoys me about sql server is SSMS 2014 is horse poo poo and doesn't save connection parameters in the dialog box so the program disconnects from the DB every 5 minutes and you have to type out the loving connection string again.

SSMS 2016 fixed that though so once again SQL server is the best

.csv files don't need connection strings and as such are superior

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

zen death robot posted:

oh yeah when you've got a huge DB and you're concerned about every bit of performance you can get you need to


Is this the sort of thing that sounds interesting because I don't know anything about it orrrrrr

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

JewKiller 3000 posted:

"but jewkiller, you racist gently caress, surely it must also be easy to make a custom aggregate function in oracle to do products, right?" you bet!


ENTERPRISE! :captainpop:

i've been reliably informed that you picked the dumbest possible way to illustrate this

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

sproc out with you're cock out

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

YeOldeButchere posted:

no. i don't need more poo poo on my reading list

if you don;t want to read teffort posts get the gently caress out of yospos forever

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

Tiny Bug Child posted:

you can do both of those things w MySQL and it's not hard

Your expertise is in hard dicks not hard dbs

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

pointsofdata posted:

it's like map of temperatrues, where you have distance x and distance y on different axis and in the cells you have the temperature values. Except maybe you also have height on the z axis and it represents temperature in volumes of the atmosphere, so now you have a cube. And maybe you also have an other axis which represents time, so now you have a hypercube showing temperatures in volumes of the atmosphere over time (don't try and visualise this). etc

Then there are loads of ways of extracting subsets of the information. You might only want to know temperature at 8km up, or maybe just how it changed over time at a specific point in time.

this sounds insane but also cool

Adbot
ADBOT LOVES YOU

Captain Foo
May 11, 2004

we vibin'
we slidin'
we breathin'
we dyin'

the talent deficit posted:

you can make all the same queries, they're just gonna be slow if you don't do the transformation to a cube or star schema

Just lmao if u don't set up a token ring schema

  • Locked thread