Skip to main content
66
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
A growing list of commands I've used and what they do in no specific order sudo...
Andrew Fletcher
When Solr is displaying results on the site, first step is to log in the server...
Andrew Fletcher
To resolve the CVE-2022-48624 vulnerability on Ubuntu using Nginx, it's crucial...
Andrew Fletcher
In many terminal text editors, you use find command as reference in Terminal...
Andrew Fletcher
In our projects, team members frequently generate new Git branches linked to the same Jira number, resulting in cluttered and disorganised structures that can pose challenges for both current and future developers. For instance: Jira: ABC-123 Ticket work: Reformat headers Over time, these branches accumulate and become disorganised, resulting in names like: ABC-123-reformat-headers ABC-123-format-headers ABC-123-format-header This can lead to a cluttered and inefficient workflow. It's preferable...
Andrew Fletcher
In an environment that is running Ubuntu 20.02 Nginx Solr   The default...
Andrew Fletcher
The error you're encountering indicates an issue with the ffi gem during the...
Andrew Fletcher
You can perform the following steps: Check Apache Modules Apache Struts 2 is...
Andrew Fletcher
These steps are for Drupal 8 and 9.   Export your database Order here is...
Andrew Fletcher
To use OpenAI to summarise text from a PDF using Python 3.11.6, you'll first need to extract the text from the PDF and then send it to the OpenAI API for summarisation.   Preparation   Set-up pip install python-dotenv langchain openai tiktoken pypdf pymupdf  Code The current code is on my Summaries GitHub page.   Elements Adjusting the parameters - you can adjust the max_tokens and temperature parameters in the summarize_with_openai function to control the length and...
Andrew Fletcher
Permission error Traceback (most recent call last): File...
Andrew Fletcher
To set an environment variable on Ubuntu, can be achieved via a few options....
Andrew Fletcher
Whilst installing Python 3.11.6 and running the command 'sudo make altinstall',...
Andrew Fletcher
Ubuntu 20.04 comes with Python 3.8 installed.  If you run the update...