Comments (16)
@jellelicht @bwbroersma As we get closer to production the focus changes.
For this we're relying on the 247x ops of the Belasting dienst, existing dual DC environment, Security Operations Centres, monitoring, backups, etc, etc.
In that environment it is MS SQL Server that is the norm. And our timelines/priorities dictate that we go as fast as we can; so re-training and retooling 24x7 staff in PostgreSQL, getting that monitored, etc, is simply too much risk.
Which means SQL Server. And only that.
So while PostgresSQL served us well during dev, field and test - it is no longer important as we go life.
However - we'll try to accept patches if people want to keep things compatible. But for now - getting in production & dealing with Covid is our priority.
(@dirkx - die zelfs IIS boven apache prefereert als het ons sneller in prod krijgt).
from nl-covid19-notification-app-backend.
We discontinued the support for PostgreSQL. The docker image is configured with MSSQL.
from nl-covid19-notification-app-backend.
So you now need Windows Server and MSSQL licenses to deploy this - because it's easier for a few select individuals. We end up with a static, old school infrastructure that requires expensive commercial licenses and isn't easy to port to OSS.
from nl-covid19-notification-app-backend.
I had high hopes for all of this stuff to be open and transparent. But step by step things appear not to be so open...
from nl-covid19-notification-app-backend.
Where does that stop? Do you want to drop C#/.NET too? What about the server it's running in? I suppose you also don't want it to be using a proprietary OS, so that leaves Linux (but who's using that, right?) with only open-source drivers.
Next the software needs to run on some kind of hardware. You can't use a proprietary cloud, so let's put a server in a rack somewhere. Oh, Intel and AMD server CPUs aren't open source either. God knows what these CPUs might be doing in the background!
So to make the whole stack open source, we first have to design our own hardware. Also, how can we be sure the open source version we've access to is the same thing the software is running on?
from nl-covid19-notification-app-backend.
If "speed" was the major concern, you would've found a way to do more work out in the open 😉 . That predictable speed + legal compliance outweigh some perceived purity/ideological shenanigans is completely understandable though. Thank you for your explanation @dirkx , it would have been nice to have something of the sorts shared at the same time as the decision.
from nl-covid19-notification-app-backend.
Sure, that is a great thing. I just don't understand why any dev would pick SQL Server when Postgres is a option. Would save them a lot of future headaches!
from nl-covid19-notification-app-backend.
Happy?
from nl-covid19-notification-app-backend.
Nice! Approved them twice :-).
from nl-covid19-notification-app-backend.
So much for open-source...
from nl-covid19-notification-app-backend.
I'm just happy the app(s) are on Github! A great step towards better software for our country. I hope this becomes the new standard.
from nl-covid19-notification-app-backend.
I never had any headaches with using SQL Server, PostgreSQL, MySQL or SQLite. They're all just fine. Just use whatever you're most experienced with, I suppose.
I suppose SQL Server plays nicely with C#/.NET?
I would use PostgreSQL as well, because I'm most experienced with PostgreSQL. but I would also not use C#, since I'm more experienced with other tools. The best tool is almost always one you're most familiar with.
from nl-covid19-notification-app-backend.
DX issues aside, as a citizen I don't feel comfortable knowing that my data might end up in a proprietary database.
from nl-covid19-notification-app-backend.
We discontinued the support for PostgreSQL. The docker image is configured with MSSQL.
@rkops-bd Can you elaborate on this decision? Maybe if you share the issues, the community can either better understand, or help with a solution.
from nl-covid19-notification-app-backend.
@rkops-bd any chance you could elaborate a bit on why y'all decided to move database implementations in the end?
from nl-covid19-notification-app-backend.
BD is no longer in the picture as far as I understand it, so please reconsider this decision, or explain why it would still be the most strategic choice to stick with MSSQL for now.
from nl-covid19-notification-app-backend.
Related Issues (14)
- remove the private key from the repository HOT 3
- You might not want to store private keys on github HOT 1
- Private key visible inside the sources HOT 2
- Consider serving a security.txt file HOT 8
- Scope of this project HOT 4
- Developer level connection strings/credentials should be generated HOT 10
- Concerns on scalability and security
- 2020-08-19: [VWS/Covid19NotificationApp] HOT 4
- Concern : In the unit-tests, run WireMock.Net on a random port instead of fixed port HOT 2
- Decoy probability constant HOT 1
- Using docker-compose fails HOT 2
- Running in Docker on Linux fails HOT 2
- docker build HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nl-covid19-notification-app-backend.