PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

25 November 2022
25 November 2022

Express.js or Next.js for your Backend Project

In this article, I will introduce two JavaScript frameworks that can be used to build backend projects. Backend development is the development of server-side logic that powers websites and apps from behind the scenes. It typically includes all the code needed to build out the database, server, and application. From database migrations to API integrations to set up the server-side technologies that make a website tick.… Read more
12 November 2022
12 November 2022

Introducing the MySQL DELETE statement

0
1
In the last few articles in this series, you learned about three important data manipulation language (DML) statements: SELECT, INSERT, and UPDATE. The statements make it possible to retrieve, add, and modify data in a MySQL database. Another DML statement that is just as important is DELETE, which lets you remove one or more rows from a table, including temporary tables. In this article, I focus exclusively on the DELETE statement to help round out our discussion on the core DML statements in MySQL. Overall, the DELETE statement is fairly basic, but one that’s no less necessary to have in your arsenal of DML tools. … Read more
05 November 2022
05 November 2022

How to Use Any SQL Database in GO with GORM

Object Relational Mapping is a database abstraction technique that aids developers in manipulating and interacting with SQL databases using the data types provided in the programming language. ORMs (Object Relational Mappers) are tools (libraries, modules, packages) that provide the functionality for interacting with SQL databases. Popular ORMs are the Prisma ORM for JavaScript, TypeScript, Hibernate … Read more
01 November 2022
01 November 2022

Calling all leaders: People matter

At the turn of the millennium, I was a young adult, just finished education and starting my very first job at a software company. I was excited, enthusiastic, and felt well-prepared for a life of “Office 9 to 5” and was looking forward to earning my keep. But I was naïve when it came to … Read more
26 October 2022
26 October 2022

Oracle optimizer Or Expansion Transformations

0
3
The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for “Or Expansion” and “Join Factorization”. In this instalment, it’s time to take a closer look at Or Expansion and we’ll move on to Join Factorization in the next instalment.… Read more
14 October 2022
14 October 2022

Backing up MySQL Part 1: mysqldump

0
3
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this … Read more
07 October 2022
07 October 2022

Introducing the MySQL INSERT statement

0
3
In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both … Read more
01 September 2022
01 September 2022

Do not be surprised

For the first time in eleven years of travel, I became profoundly sick while on the road. No, I’m not sharing details of any kind. What I will share is just this; I wasn’t prepared. When I travel, I look at the weather, where I’m going, how long, and I pack accordingly. I have my … Read more
03 August 2022
03 August 2022

Technology is hard

I book my travel almost exclusively through a single airline and its affiliates. There are a lot of reasons for this, but the big one is status. And no, not so I get upgrades (although they are very nice), but so when things go wrong, I have a hotline to getting them fixed. However, I … Read more
15 July 2022
15 July 2022

Let’s talk about salary

Said no manager ever. Money is the one thing every candidate at any job interview is advised never to mention. The salary on offer for the role is treated almost like a *dirty secret. Job advertisements only reveal a band or range, which makes sense to a certain extent, given that the candidate may be … Read more