Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Edward Glaister 6 posts 36 karma points
    Aug 01, 2023 @ 15:28
    Edward Glaister
    0

    Does It Matter What Type Of Database To Use?

    When installing the latest version of Umbraco I noted all the various database versions - including new SQLite!

    My question to the community is does it matter what database is used?

    Why might you use one over another?

  • Simon Justesen 74 posts 193 karma points
    Aug 02, 2023 @ 14:32
    Simon Justesen
    0

    This thread on StackOverflow has an interesting discussion about the advantages/disadvantages regarding SQLite.

    TLDR; Great at handling concurrent reads... Writes - not so much due to exclusive locking. https://stackoverflow.com/questions/4060772/sqlite-concurrent-access

  • Edward Glaister 6 posts 36 karma points
    Aug 03, 2023 @ 09:25
    Edward Glaister
    0

    Thank you kindly for your answer. Have added this to my reading list :-)

  • Edward Glaister 6 posts 36 karma points
    Aug 02, 2023 @ 19:57
    Edward Glaister
    0

    I have gone ahead with installing Umbraco with a SQL Server Database for the time being -

    I have used SQL Server for no other reason other than the fact that SQL Server is what I know!

    ... Is this perhaps the whole reason why Umbraco can connect to so many different database types? To make it more accessible to developer from different background who prefer different databases?

    Can't really find an answer. Just curious to hear what other databases developers on here connect Umbraco to and why!

  • Huw Reddick 1929 posts 6697 karma points MVP 2x c-trib
    Aug 03, 2023 @ 07:44
    Huw Reddick
    100

    I generally use SQL Server on my webservers, but if I want to fire up a quick clean umbraco in VS for testing then I tend to use SQLLite

  • Edward Glaister 6 posts 36 karma points
    Aug 03, 2023 @ 09:24
    Edward Glaister
    0

    Just the answer I was looking for - and from a MVP / C-Trib it gives me the piece of mind I was looking for. Thank you!

    Reading between the lines the database choices available are mostly about personal preference than anything else. Although further up the line performance may be a factor (eventually)

    I hope that this thread will help others in the future who are unsure of which database to select when installing Umbraco.

  • Daniel Oberlechner 6 posts 36 karma points
    Oct 19, 2023 @ 12:29
    Daniel Oberlechner
    0

    I had to ask this question myself because I run UmbracoCMS on Linux. People told me that MS SQL Server on Linux is far behind and not so "good" therefore I use now SQLite. As it seems in the stackoverflow questions everything below 100.000 page views a day SQLite handles it quite fine ...

    For Linux users out there then I would probably recommend SQLite because you don't have to manage a MS SQL server docker container ...

    Kind regards Daniel

Please Sign in or register to post replies

Write your reply to:

Draft