[DiscordArchive] You find mssql is better in some way than mysql/oracle?
[DiscordArchive] You find mssql is better in some way than mysql/oracle?
Original source
Anyone who created any of these technologies we now take for granted is likely a boomer <:reynolLUL:428789513154723850>
rektbyfaith
02-08-2024, 10:00 AM #11Archived author: ReynoldsCahoon • Posted: 2024-02-08T10:00:57.627000+00:00
Original source
Anyone who created any of these technologies we now take for granted is likely a boomer <:reynolLUL:428789513154723850>
Original source
I'm not sure what the ATOMS transaction architecture is, but apparently he's the guy who created it.
rektbyfaith
02-08-2024, 10:02 AM #12Archived author: ReynoldsCahoon • Posted: 2024-02-08T10:02:23.782000+00:00
Original source
I'm not sure what the ATOMS transaction architecture is, but apparently he's the guy who created it.
Original source
Oh. I do know what it is, I just haven't heard it called that.
rektbyfaith
02-08-2024, 10:03 AM #13Archived author: ReynoldsCahoon • Posted: 2024-02-08T10:03:12.156000+00:00
Original source
Oh. I do know what it is, I just haven't heard it called that.
Original source
atomic transactions is what you mean i think.
atomic (meaning ~ indivisible) in that case refers to transactions which have to go through completely (begin transaction/commit transaction/rollback transaction).
for example: when processing a customer order in your db... you might have to do multiple edits like updating the count of available items, inserting order lines, inserting notifications to be processed, etc.
such things have to go through completely, or not at all (in case of hard errors and so on)... doesn't make sense to do only half of the stuff you need to do, since this would lead to a fucked up state and leaves you with bad data.
rektbyfaith
02-08-2024, 10:10 AM #14Archived author: 4bhorrent • Posted: 2024-02-08T10:10:24.890000+00:00
Original source
atomic transactions is what you mean i think.
atomic (meaning ~ indivisible) in that case refers to transactions which have to go through completely (begin transaction/commit transaction/rollback transaction).
for example: when processing a customer order in your db... you might have to do multiple edits like updating the count of available items, inserting order lines, inserting notifications to be processed, etc.
such things have to go through completely, or not at all (in case of hard errors and so on)... doesn't make sense to do only half of the stuff you need to do, since this would lead to a fucked up state and leaves you with bad data.
Original source
Constantly getting told to use Redis instead of MySQL for a lot of persistence at work, then we run into scenarios where Redis replies that the write failed when actually it succeeded... so we retry and end up with duplicate data written. There's a reason this old tech has been used for so long. Transactional guarantees are much needed
rektbyfaith
02-08-2024, 10:14 AM #15Archived author: stoneharry • Posted: 2024-02-08T10:14:43.143000+00:00
Original source
Constantly getting told to use Redis instead of MySQL for a lot of persistence at work, then we run into scenarios where Redis replies that the write failed when actually it succeeded... so we retry and end up with duplicate data written. There's a reason this old tech has been used for so long. Transactional guarantees are much needed
Original source
I've used MSSQL for a few years at my old job. It's really good and also has really neat tooling
rektbyfaith
02-08-2024, 10:22 AM #16Archived author: Kaev • Posted: 2024-02-08T10:22:42.493000+00:00
Original source
I've used MSSQL for a few years at my old job. It's really good and also has really neat tooling
Original source
I tend to avoid Microsoft products except for Windows (for gaming). Github doesn't count because they didn't make it they bought it. <:reynolLUL:428789513154723850>
rektbyfaith
02-08-2024, 10:29 AM #17Archived author: ReynoldsCahoon • Posted: 2024-02-08T10:29:24.670000+00:00
Original source
I tend to avoid Microsoft products except for Windows (for gaming). Github doesn't count because they didn't make it they bought it. <:reynolLUL:428789513154723850>
Original source
I don't know the particular costs/benefits of Oracle/MySQL as it compares to MS SQL.
rektbyfaith
02-08-2024, 10:30 AM #18Archived author: ReynoldsCahoon • Posted: 2024-02-08T10:30:19.017000+00:00
Original source
I don't know the particular costs/benefits of Oracle/MySQL as it compares to MS SQL.
Original source
just roll with mysql/mariadb or postgres for your private projects... should be more than enough.
or sqlite if the context allows it
rektbyfaith
02-08-2024, 10:31 AM #19Archived author: 4bhorrent • Posted: 2024-02-08T10:31:02.867000+00:00
Original source
just roll with mysql/mariadb or postgres for your private projects... should be more than enough.
or sqlite if the context allows it
Original source
The majority of software we use at work uses mssql
rektbyfaith
02-08-2024, 10:51 AM #20Archived author: Foe • Posted: 2024-02-08T10:51:27.113000+00:00
Original source
The majority of software we use at work uses mssql
1 Guest(s)
1 Guest(s)