/biz/ - Business & Finance

PostgreSQL.

>>8171840
Postgresql, MySQL, honestly probably SQLite or fucking mongo lel. Oracle? Come on dude grow up

>>8171904
unironically this

you have 2 choices for a traditional RDBMS: MySQL and PostgreSQL. That's it.

>>8171904
>Come on dude grow up
Fuck you I'm afraid of change.

>>8171933
Between those two, which is an overall better choice and why?

>>8172015
it depends on what you need lol

MongoDB
unless you need indexing

>>8172015
Based on my googling, Postgres is slightly better in terms of performance, but MySQL has a way bigger community. But this is only from reading a few different articles that I just googled.

>>8172209
This is the first answer for noSQL. Why?

>>8172209
You can index on mongo

Why is people sugesting nosql dbs to someone using oracle without first asking his use case?

>>8172273
Sorry I should have been more precise. Unless you want a full-text index. Mongo does not support full text for very large amounts of data (a couple gigabytes max iirc)

>>8172241
This isn't /g/
Relational databases are still by large the most commonly used
Mongo is good and fast in general but will suck compared to RDBMS for certain tasks. It really depends on what you need.

I also like ArangoDB which is both a graph database and a document store. But I've only used it on small projects so I'm not sure how well it would scale. I hear DGraph is great, super fast and distributed but I haven't tried it yet.

>>8171840

So it sounds like everyone here is still under 25.

Just stick with Oracle. You can run subs much easier, cron it up, and basically do anything. It's a perfect database albeit complicated. Great platform to learn and become and expert in.

>>8171859
x100 this if you want an RDMS Op. It's amazing, much better than MySQL etc. Otherwise, what's your use case? If it's something like some big bulk tables, just shove it into MongoDB. Or check out GraphDBs - some cool things emerging there too.

>>8172273
>without first asking his use case?
My use-case is
>pretty simple records the consist of names, timestamps, and a couple other numbers
>entering ~100,000 new records per minute
>a ton of sorting and retrieving sorted results
>retrieving large chunks of the dataset very often

That's basically the gist of it. I'm not storing documents.

>>8172376
Yes. Tech improves. There's a reason no one uses COBOL anymore

>>8171840
Postgresql is fine. Mysql is same same but different.

>>8172360
>This isn't /g/
No shit, I came here to find people who might actually know the technology should be used. I didn't come here with a pic of my desktop or new LEDs for my mouse.

>>8172446
Switch to Mongo

>>8172446
Ok, just roll Mongo then. No complex schema needed for that use case, just a basic key value store type deal.

If in doubt, I'd still recommend Postgres though.

Just buy chainlink and quit your shit IT job

>>8172483
Here's a benchmark comparing the performance for Mongo, Postgre and a bunch of GraphDBs.

https://www.arangodb.com/2015/10/benchmark-postgresql-mongodb-arangodb/

Mongo will work best for your use case

>>8172496
Fuck off pajeet. Grown ups are talking. And who do you think makes all your shitcoins? Coders. What do coders do before we invent a shitcoin and retire to Portugal to shitpost and do blow all day? We work on shit like databases.

Try Orbit-db.
https://github.com/orbitdb/orbit-db

>>8172496
>>8172536
I meant to mention in OP but forgot, I only wrote this program to make it easier for me to become a whale and swim in shitcoins. I have no interest in becoming an expert in databases. Back-end programming only,

I usually leave database shit to the pajeets, but this is my own project in the early stages.

>>8172530
Agreed. Do it OP.

>Arangodb
I really need to play with this much more, I keep meaning to but haven't had a project pop yet that's given me a reason. Need to make the time I think.

>>8172453

Yeah, but Windows is still the most versatile OS because most programs run on it.

Like Oracle.

>>8172580
Ha! Fucking well done lad. I think we've all got similar projects right now kek. That blow in my future hacienda isn't going to do itself.

>>8172586
Your metaphor collapses when you consider the installation/portability. Windows is easy as shit to install, and all it's features easily port between platforms

Installing oracle or moving a DB to a different platform is like trimming your pubes with a chainsaw, in the dark.

>>8171840
MySQL or even Mssql Express (free mssql tools for all your importing etc). Last time I used the others msft was hard down near studio / dts tools etc

>>8172586
........even OSX is better then Windows for coding these days. Nice try. MSCE pajeet detected.

He just needs a basic key value store. So it's Mongo he needs. Not our fault if you haven't kept up with developments.

>>8171840
use the same database discord uses, i forgot its name, its all the rage now

>>8172725
Cassandra

>>8172648
>>8172662

You kids jump to anything "new" and "improved" without mastering anything.

It's why I'm sitting on fat stacks of BTC and ETH that I'll never sell while you fags keep jumping to the next shitcoin that's "new and improved".

This is also why I have a better job with deep understanding of advance techniques with complex systems, while you kids keep hoping to the "easy and faster" stuff.

As always, stay pleb and stay poor.

>>8172761
>>8172725
If OP wants to avoid headaches and issues I would advise to stay the fuck away from all Apache software

>>8172813
Not sure why you're aiming your rant at me, Wilbur, I'm using Oracle in 2018

>>8172813
Implying BTC and ETH weren't new in their time.
BTC and ETH are good store of values if you want to safely keep on increasing your crypto wealth

but if you expect to pull a x100 on your initial investment you'd be retarded to get into either of those two now.

I'm not even that young. 35, started coding in assembly, c and delphi in the 90's. I remember when web dev made the switch to Javascript, all the PHP people felt JS was a meme because they thought it was just a glorified <blink> tag that could only add snowflakes to a personal webpage. Incidentally I don't see that many good PHP jobs being posted around anymore.

>>8171904
>>8171840
MySQL is so easy to port
And I like MySQL workbench if you just want to mess around with the data
https://www.mysql.com/products/workbench/

>>8172813
Uhhhh I've been working w SAL Server for a decade. And MySQL and Postgres a bit along the way.

Thinking that complicated is important when it could be simple is why I hate my job.

>>8173335
100% this. RDBMS are great when you need them, but honestly if you just have one or two flat tables just go Mongo or some other noSQL solution. People need to stop overcomplicating shit.

>>8172912
38 here. Agreed. Any coder that isn't staying current isn't doing their job. There's fundamental improvements that take place all the time - if a new language, library or framework can let me be more productive, I use it. There's a reason we don't build websites with fucking punch cards.

Fucking Blub paradox at work...

>>8172446
Your database is pretty simple, Sqlite3 can handle that with ease. You don't need RDMS like mysql or portgres with that. Sqlite3 will be faster and better for your use case.

Microsoft Access

>he didn't use data pump

is it dumb to ask why an individual would have sql databases?

>>8173965
dbs are to organize your info so its easy to search.

with sql you can ask the question "Show me all customers who have $10k in purchases, but only from spring months on diaper products and sort that by their last name" with one easy query.

>>8174013
i said individual ding dong

>>8172912

Theres actually a lot of money to be made in legacy if you know youre shit. I know a few peeps making bank off their knowledge of Perl and even one dude whos entire job is working with ALGOL.

>>8174031
yes, then the answer is yes, you're a dipshit.

>>8173508
SQLite is an RDMS

>>8174051
you're the one that responded with a business anecdote
op's usecase sounds like he's operating some kind of business too

>>8171904
>database that isn't Oracle
>MySQL

You're fucking retarded

>not using a proper document store like MarkLogic
>not querying your data with xpath

everyone here is fucking stupid don't listen to them. use mongodb

Get MSSQL in Azure

>>8174591
>mongodb
it is webscale

>>8172453
>no one uses COBOL anymore

But ya fuck COBAL, fuck high paying COBAL positions, fuck companies who won't pay to transition from COBAL, and fuck the autistic COBAL programmer who always fucked me over as an intern.

>>8172698
>even OSX is better then Windows for coding these days. Nice try.

writing code =/= actual use

Neo4j is the future.

SQLite, all the shit sits in a single file you can just move from machine to machine.