developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
25
results
Andrew Fletcher
•
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state.
Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Install the CKAN package
Begin by cleaning up your server environment....
Andrew Fletcher
•
If you're planning to create extensions, generating CKAN from source is the...
Andrew Fletcher
•
CKAN extensions - adding to your installation
Following the information...
Andrew Fletcher
•
Goal: Restrict content access through username and password entry on an Nginx server.
1: Apache Utilities Package
First, update your server’s package index:
sudo apt updateCheck if the utilities package exists in your environment by executing the command
dpkg --get-selections | grep apacheResponse:
apache2-utils install
libapache-pom-java installSo it exists. But what do you do if it doesn't exist?
How come I need to install apache-utils? To restrict access you will be using...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
Find by file name
To perform a find command in terminal use
find / -name...
Andrew Fletcher
•
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
•
Location of the base templates
cd...
Andrew Fletcher
•
An approach to generating a backup server is using a shell script. A script can define directories to backup, and pass those directories as arguments to the tar utility, which creates an archive file. The archive file can then be moved or copied to another location.
Example Shell Script
#!/bin/bash
#
# Backup script
#
# NAME: daily-backup.sh
# PATH: /mnt/e/bin
# DESC: Backup scripts, documents and configuration files to .tar
#
# What to backup
# backup_files="/home...
Andrew Fletcher
•
Finding the issue with a server 500 error
The Nginx error logs are showing too...
Andrew Fletcher
•
Focusing on the ckan.ini file (/etc/ckan/default/ckan.ini). When I run the...
Andrew Fletcher
•
Following the instructions on CKAN DataStore with a little...
Andrew Fletcher
•
Working through a CKAN installation on Ubuntu 20.04
User sees a server 500...