Development

Indentation and Styling Guide

by Karan Gosal, 25 October 2023

Indentation is more than just a matter of aesthetics in coding; in some languages like Python, it holds a semantic value. It’s a fundamental part of how code is structured and readable. It helps to organize your code, making it easier to understand and maintain. In this blog post, we will explore the basic indentation rules for four popular programming languages: JavaScript, HTML, Django, and Python.

Ingestion Made Easy!

by Priya Srinivasan, 11 August 2023

ZooDB already possessed an ingestion script, capable of efficiently processing hundreds of rows of zooarchaeological bone data. This script was traditionally executed from the command line by the developer. However, to enhance the user experience and streamline the ingestion process, we created a user-facing feature to allow the researchers to upload and process their data via the web application. In this article, I describe the crucial parts of this feature and how it was developed.

Workflow Tips

by Nick Wurzer, 2 August 2023

If you’re like me and this is your first exprience coding in the real world, it may take a while to get familiar with Git and GitLab. This may initially slow you down when working on tasks, so I aim to speed up the learning curve by showing some useful features of Git and GitLab. If you’re already familiar, then read on for a good review!

Django development tips

by Archie To, 31 March 2023

This article contains tips that I wish I knew when starting out with Django. Following these tips will help your development process with Django a lot faster and make your code way cleaner. This article assumes you already have basic Django knowledge. (Django’s full documentation can be found here.)

Basics of Openpyxl and Ingestion of data into SQLite database

by Priya Srinivasan, 28 March 2023

In this blogpost, we will be discussing the basics of the python library openpyxl, and about how to ingest an excel spreadsheet data into database such as SQLite.

Get To Know Git

by Priya Srinivasan, 2 March 2023

One of the most commonly used version control systems is Git. One should follow a proper workflow to perform the tasks in a efficient and consistent manner. Git was originally created by Linus Torvalds in 2005. Git has a great support for branching, merging, and rewriting repository history. Git is considered to be a standard for software development.

Researcher Contact Database

by Archie To, 28 February 2023

RCS team members work with researchers and faculty members on multiple projects everyday. Each of these projects involve different people (inside and outside of the university), are at different stages and require different actions. It has become extremely difficult for RCS team members to keep track of these information as the number of projects that they work on rises. Therefore, there needs to be a solution.

Linux Permissions

by Priya Srinivasan, 26 January 2023

One of the most common issues faced while working with linux-based systems is having to handle file permission-based issues. This happens when a user does not assign the right permissions to files or directories. Therefore it is important to understand the need for proper permissions and know how to set permissions on files and directories. This blog introduces to the ways in which permissions of a file/directory can be viewed/changed. The blog also talks about ways to specify shorthand for permissions.

Django App Starter Template

by Archie To, 20 January 2023

Django is a very popular web framework known by many Python developers. RCS ARC Software Team decided to use this framework as the main technology to develop multiple web applications, which will eventually serve the need of researchers, faculty members and employees in the University of Victoria. All of these applications have some identical functionalities such as authenticating users by HTTP request headers, displaying separated pages for normal users and admin users, and providing an about page for web developers. These similar functionalities force developers to rewrite the same code everytime they start a new project. This is obviously a time-consuming and boring process.

Turning a Spreadsheet Into a Postgres Database

by Stephen Neale, 4 November 2022

Hello! Stephen here. From September to October I have been working on a database of excavations and bone counts for the archaeological department here at the University of Victoria–a project dubbed “ZooDB”. In this blog post, I will be going over how I went about one of my first tasks: automatically turning a spreadsheet of data into a Postgres database.