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!
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.
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 ...
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?
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
Thank you kindly for your answer. Have added this to my reading list :-)
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!
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
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.
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
is working on a reply...