3

What type of technology is used nowadays in IT companies when it comes to storing, changing, deleting and reading data?
Is SQL still a thing or is it outdated?

Comments
  • 3
    In my experience postgres is still strong...
  • 10
    We write things down on paper, then scan them in, paste them into Word and send it as a response
  • 3
    MariaDB and Postgres are still very strong. It only gets downhill if you're still using Microsoft SQL Server...
  • 7
    SQL Server is definitely still a thing and a really good database solution. You'll find it used in many enterprise organisations.

    PostgreSQL is also really good for relational data.
  • 8
    @kescherRant please explain ;)

    I have used several different sql server brands and microsoft is definitely in the top tier if you need a powerful server and can pay for it.

    Postgresql is also very good and so is mariadb and mysql.

    The only thing remotely bad I know about ms sql server is the price tag which still is less than oracles equivalent.

    And with the latest version it runs under linux again.

    Or is this another bash ms post?
  • 1
    I use pen and paper.
  • 3
    @kescherRant what is sql server cons in your case?

    Also sql will still be popular even if graph database is becoming commons
  • 2
    Depends on the data and usage.

    Yes. SQL is very relevant for managing relational data stored as tables.

    However, maybe a key-value store db like redis will be enough for your needs to store and read data and you will be able to manage queues or scale up with less overhead.

    On the other hand, if you store entire documents in the database and you want to efficiently search and retrieve information based on keywords of said documents, you may need to do a document-store database such as elasticsearch.

    But if you require more complex analytics like querying the relationships between the data and finding meaningful patterns, you may need a graph database like neo4j.

    In short, SQL is very good and still relevant but it all goes down depending on your needs.
  • 1
    Kafka
  • 2
    @Voxera
    Simple things like

    Sensible SQL DBMS:
    create database if not exists <name>;
    MS SQL Server:
    @highlight
    if db_id('<name>') is null
    create database <name>;
  • 2
  • 6
    @kescherRant so, the least used command in an sql server dictates if its a good server?

    I don’t care to much about syntax but more about query performance and capabilities, thats what will make or break a solution.

    And yes, mysql and mariadb has some nice syntax for some commands, but sql server can do the same

    But sql server has query commands that just do mot exist in mysql and that in some cases can reduce query time by 99 % or even more.

    Is an easier create command worth spending 10 times more on hardware ;)

    I rather spend 5 minutes learning the syntax.
  • 0
    @Voxera That was just the simplest example I can think of.
    I have also seen MSSQL servers just randomly telling you to reinstall because something broke. Idk why that happens, but it seems to happen more often than it should.
  • 1
    @kescherRant what?

    I have use sql servers for more than 20 years and never ever even heard anything like that?

    And just for reference, I have use mysql almost as long along with mongodb almost since its conception.

    Sql server is one of the most stable pieces if softwares I have ever worked with.
  • 0
    @Voxera Guess I've just had bad luck then :)
    Perhaps the next time I see a MSSQL server, it goes better
Add Comment