Working with SQLite just got a whole lot easier! Codesphere is happy to announce a new UI for creating and managing your SQLite databases!

Let’s talk about how!

Setting Up Your Database

To create a new database file, navigate to the infrastructure tab in Codesphere’s IDE and select SQLite.

Written by Dan Parry.

Database Management Systems (DBMS), in short, are collections of tools used to access and manipulate the data stored in a database. There are lots of different types of DB management systems but the most widely used are Relational Database Management Systems (RDBMSs).

RDBMSs use the relational model to store data in the form of tables (referred to as relations). Each relation is then further organized into rows (tuples) and columns (attributes). A relation is managed and/or queried using Structured Query Language (SQL).

There are many dialects of SQL, the three most popular of which are SQLite…

Roman is our Senior Software Engineer here at Codesphere, he was recently interviewed on the Ironhack podcast, where he shared his journey from working in his mom’s ice cream shop to becoming the award-winning, self-taught dev he is today — and it’s a story worth hearing so we thought we’d share it with you too.

Written by Dan Parry

We all have a different outlook on life — some of us take a glass half full approach and some of us are ‘who’s drank half my drink’ kinda people — but when it comes to software development, which is the more productive mindset? Is one better than the other?

Let’s talk about the pros and cons of optimism and pessimism in developers.

Experience plays a role in the level of pessimism you might find in a developer. A long history of unexpected problems and catastrophic deployment issues has a tendency to jade a fresh-faced junior…

Earlier this week, we spoke about the relationship between coding productivity and listening to music. If you’re a developer, you know how many different tabs and applications you might have open at once. That’s why today we’re going to create a simple web app to voice control Spotify.

You can check out the demo, deployed on Codesphere, here:

https://18922-3000.codesphere.com/

Project Overview

To do this we’re going to use React, the Spotify Web API, the react-speech-recognition library, and Codesphere.

The flow will look like so:

This GIF obviously doesn’t include sound, but upon saying “pause music”, your Spotify will pause, and upon saying…

Listening to music while coding is a topic I often find myself talking to other developers about and everyone seems to have a different opinion or preference. Some don’t like to listen to anything, needing silence to really focus. Others are into ‘chill beats’ to help them find their flow, and one maniac I know can code to black metal (he’s from Finland).

Conway’s Game of Life has amazed Computer Scientists and Mathematicians for over half a century now. For those who don’t know, the Game of Life is a zero-player game that follows four simple rules and can end in chaotic, beautiful, and mind-blowing outcomes. This simple game can even be used to simulate a Turing machine (you can essentially program using the game).

Today, I’m going to be showing you how you can make this game yourself with only 100 lines of Javascript.

You can get a feel for the game here: https://playgameoflife.com/

What is Conway’s Game of Life?

Conway’s Game of Life starts with a 2d…

Written by Dan Parry at Codesphere

There seems to be a common perception that math and coding are intrinsically linked and to some extent, they are. Whether being good or bad at math affects how good a developer an individual is, however, is a whole other topic worth talking about.

On one hand, there is the school of thought that math is indeed very important because programming involves complex calculations and anyone without a deep understanding of math will struggle to solve problems. …