PostgreSQL MVCC How does MVCC work? Write-Ahead Logging (WAL) Log-Shipping Standby Servers PostgreSQL VACUUM Investigating slow PostgreSQL Index Only scans Aufgaben Starte PostgreSQL mit einem Docker Container...
...shell variable PS1 holds your bash prompt. You might want to change it to serve your needs best. Here is how to: General non-printing escape sequences in your prompt...
...a directory index when you access http://yourpage.com/system/attachments. You can configure your apache server to expire file-URLs after some time, so they are only available as long as...
...is a European marketing association which has introduced a standard how advertising can be served to users in line with the General Data Protection Regulation (GDPR). This standard is called...
...to a rough geographic region of the user", or "vendor X is allowed to serve personalized advertising based on user behavior", or "vendor X is allowed to use user data...
...bind '0.0.0.0', 3000, { key: localhost_key, cert: localhost_crt, verify_mode: 'none' } start your server as usual, but go to https://localhost:3000 bundle exec rails s Accept the certificate...
...a validation a malicious user can quickly exhaust the hard drive of your database server. In legacy Rails (or database schemas migrated from legacy Rails), database types :string and :text...
Values in the JavaScript API or when submitting forms to the server will always use a point as decimal separator (i.e. "1.23" even when the browser displays...
...you to log to multiple sinks. You know this behavior from from the rails server command, that both logs to standard out and the log/development.log file. Here is an example...
...ActiveSupport::BroadcastLogger.new(stdout_logger, file_logger) broadcast.level = Logger::INFO config.logger = broadcast end end Sidekiq.configure_server do |config| if ENV['RAILS_ENV'] == 'development' || ENV['RAILS_ENV'] == 'test' stdout_logger = ActiveSupport::Logger.new...
...clients, we want to review all code written before it goes to the staging server. Note: This process is tailored to our specific needs and tools at makandra. While it...
...staging: How to write custom email interceptors, check if you have a local mail server listening, and letter_opener to open mails in the browser instead 📄 Reaching the inbox: E...
...sender address of the application's domain, our operations team will have configured your servers and DNS records to cover the most obvious cases (SPF records, reverse DNS lookup, etc...
...creation on deploy before, you can do it like this: Install geordi on your servers. It brings the dumple script. Store the attached db.rake to lib/capistrano/tasks/. Require it by adding...
...solche manuellen Tätigkeiten möglichst vermeiden. Wie du in den Ansible Kapiteln beim konfigurieren von Servern schon gelernt hast, hat es seine Vorteile, seine Konfigurationen als Code in einem Git Repo...
Note that we prefer not using the Rails asset pipeline at all and serving all assets through Webpack for the sake of consistency. Preparations Remove version locks in Gemfile...
Remove version locks in package.json for webpack and webpack-dev-server Install by calling bundle update webpacker and yarn upgrade Update file contents Work through the Webpacker...
Just like we use gems on the server, we use third party JavaScript libraries in the browser. These typically provide functionality like: General support libraries like Lodash Frontend Frameworks like...
...Look at The cost of JavaScript (2019, 2023) to figure this out. Understand the service Bundlephobia Try to add lodash to MovieDB Use yarn add lodash, then import it in...
...IDENTIFIED BY 'some_password'; GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%'; Adjust MySQL configuration Edit /etc/mysql/my.cnf: server-id = 1 log_bin = /var/log/mysql/mysql-bin.log replicate-do-db = some_project_production replicate-do-db...
...other_project_production replicate-ignore-db = mysql server-id needs to be unique among all connected master and slave servers. When replicate-do-db is provided only the chosen databases...
We use the whenever gem to automatically update the crontab of the servers we deploy to. By default, whenever will update all servers with a matching role (we use the...
...sufficient context is provided. Example Create notification.resolver.ts: Return the state$ property from the notification service: Use an async resolver; Update overview.component.ts: Replace injected notification service: Use @Input() id: number with...
...pattern more frequently than necessary. With experience, it can fully replace manual edits and serve as a solid foundation for correctly specifying requirements and plans in more advanced AI-based...
...Uses a filename from the response URL if no filename is sent by the server. Does not leave the current page when downloading. Works with both static files and send...
Fails the test if the server doesn't respond with a HTTP 2xx status. Works in CI. Limitations The helper cannot inspect downloads that are triggered or created by...
...for, and why schema changes go through migrations instead of manual changes on a server. You can write migrations that change the schema and migrate existing data. You can explain...
Ask your mentor for a dump of the staging target — trainees have no server access — and load it into your local database. In the makandra cards app, load an...
...hardcoded asset hosts in webpack, otherwise all chunks would be loaded through the # Capybara server of the first test process. If that test process hasn't launched a Capybara
...Webpacker.compile That's it. Enjoy! 🎉 Similar scenario: running an application with Webpacker on multiple servers. How to serve identical assets from all servers...
...Aufgaben mit einzelnen Schritten werden in Scripts abgelegt (Bash, Python, Ruby, Go) Konfiguration von Servern verwaltet man mit Configuration Management (Ansible, Puppet, Chef, Saltstack) Cloud Infrastukturen provisioniert man mit Infrastructure...
...used as a baseline within research to compare approach to each other. This can serve as a ground for further research into this topic within this problem domain. Implementation