pagila VS codewars.com

The tutor told us that he wrote the whole file for us, but now thanks to both your leads I have found out that the file PAGILA is a GIT project at https://github.com/devrimgunduz/pagila , the "translation" of Sakila training database for MySQL.

One day, I was puzzled about how to generate some random data for development and testing without leaving my warm SQL console (in my case, psql). That’s when this set of SQL-scripts was born to generate a large amount of data for Pagila, a popular PostgreSQL sample database. You can find these scripts here: https://github.com/synthesized-io/pagila-data-generation (in "sql" folder) – and adapt them to your database schemas. I would be extremely grateful for any advice and ideas.

Create HTTP and/or gRPC server for pagila database (DVD rental database). Each server should expose metrics for scraping as well as emit traces (either to Zipkin or Jaeger, or if you feel adventurous you can support both). Start with either HTTP or gRPC and first implement just Customer service that would return customer by ID and allow inserting new one, that should be good start. When done with server(s) create GUI applications, one native, one for web (Rust + WebAssembly). Everything should be pushed to GitHub, have GitHub Actions configured for tests and build.

You can get interesting sample db here: https://github.com/devrimgunduz/pagila - it uses quite a lot of different features of pg, including fkeys.

Would running a sample database in a container also be too much? You could have some example images with a schema like Pagila loaded into them.

I did some traveling around the western US in late 2022 to take stock of where my life was and where I was going. During that time I decided that I would go all-in with my coding education, and committed to learning the remaining material listed on those bootcamp syllabi that I had not yet studied – namely, connecting the pieces of the MERN stack; learning about automated testing and data structures & algorithms; and studying development paradigms & methodologies like Agile, Scrum & Kanban, and OOP design patterns & principles – as well as continue to develop my programming fundamentals on platforms like Leetcode and Codewars.

My first encounter with regular expressions was in a solution for a coding problem on Codewars, specifically Count the smiley faces! Which asks you to count the number of smiley faces in a given array but the catch is each smiley can have 1 of 2 kinds of eyes (: or ;), may or may not have a nose represented by 1 of 2 symbols (- or ~), and 1 of 2 symbols (D or ) ) for the smile. In total there are 12 different combinations that are a valid smiley. I, being the young and naive programmer I was, hard coded all 12 of those faces and checked every element against that list. And it worked! But the top solution included some strange syntax that I had never seen before

Embrace Challenges: Challenge yourself with platforms like Exercism and Codewars that offer a wide range of coding challenges of varying difficulty levels. Additionally, consider exploring niche topics through courses on platforms like Coursera and edX.

@OP DO NOT go on the path of perfecting it and parting with your time and money. Go with Jake Vanderplas's whirlwind tour of python whirlwind tour of python to get some basics and then jump into the river codewars and swim upstream daily and religiously until you reach to katas level 5. You will be good to go. My personal experience.

Codewars: Codewars

You can try Codewars, they have a diverse range of practice problems(Cryptography, Data Science, etc.). Basically if you wanna get good in a programming language, you have to work on a lot of projects and practice problems.

Codewars is a good platform. Here you can practice code kata's daily in your preferred programming language. Link: https://www.codewars.com/

If you're looking for something that is closer to a combat style game you could try https://www.codewars.com/