bustub
PostgreSQL
Our great sponsors
bustub | PostgreSQL | |
---|---|---|
13 | 404 | |
3,649 | 14,619 | |
4.0% | 3.1% | |
8.6 | 9.9 | |
7 days ago | 5 days ago | |
C++ | C | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
bustub
-
Can we create a thread for some of the best materials on CS available online?
Introduction to Computing"
# Programming Language Theory:
"Programming Languages: Application and Interpretation"
# Compilation:
"Essentials of Compilation: An Incremental Approach in Python"
https://github.com/IUCompilerCourse/Essentials-of-Compilatio...
# Database Systems:
"CMU: Intro to Database Systems"
https://15445.courses.cs.cmu.edu/
"CMU: Advanced Database Systems"
https://15721.courses.cs.cmu.edu/
# Calculus I/II & Real Analysis
"A Course in Calculus and Real Analysis"
https://link.springer.com/book/10.1007/978-3-030-01400-1
"A Course in Multivariable Calculus and Analysis"
https://link.springer.com/book/10.1007/978-1-4419-1621-1
# Linear Algebra & ML:
* A Series of books by prof. Joe Suzuki without using any external library for the implementations *
"Statistical Learning with Math and Python"
https://link.springer.com/book/10.1007/978-981-15-7877-9
"Sparse Estimation with Math and Python"
https://link.springer.com/book/10.1007/978-981-16-1438-5
"Kernel Methods for Machine Learning with Math and Python"
https://link.springer.com/book/10.1007/978-981-19-0401-1
# Discrete Mathematics:
"CMU 21-228 Discrete Mathematics (prof. Poh-Shen Loh"
https://www.math.cmu.edu/~ploh/2021-228.shtml
# Cryptography:
"Serious Cryptography: A Practical Introduction to Modern Encryption"
https://nostarch.com/seriouscrypto
# Problem Solving:
"Math 235: Mathematical Problem Solving"
-
const/smart pointer confusions
The relevant classes are: https://github.com/cmu-db/bustub/blob/master/src/primer/trie.cpp and the header https://github.com/cmu-db/bustub/blob/master/src/include/primer/trie.h (you can look at the root github's repo README how to compile)
-
Any DSA resources that are NOT boring?
Take for example CMU's bustub DB. Great lecture material, but their own pedagogical database where you implement parts of the database.
-
The “Build Your Own Database” book is finished
This seems like a fairly shallow course: if you’re interested in some real awesome database hacking, I highly recommend bustub. It’s great and educational.
- 15-445 Projects source code
-
What's everyone working on this week (9/2023)?
Not a tutorial but I completed all the assignments for CMU Database System course (link) and watched all their youtube videos before I started it (I highly recommend it, it's a great course and it's possible to submit the solutions even if you're not a CMU student. The entry code to gradescope is in the FAQ). Though, what I do is not re-writing bustub in Rust, as bustub uses 2 phase locking to achieve transaction isolation, and this uses MVCC, pretty much like Postgres (though currently much simpler). I used this resource as a starting point how it works.
- The BusTub Relational Database Management System (Educational)
-
SimpleDB: A Basic RDBMS Built from Scratch
There is also BusTub from CMU which I stumbled upon earlier today:
-
Online courses to learn more about databases and the concepts taught in Week 7?
check this course from cmu
- C++ Project Ideas
PostgreSQL
-
Understanding SQL vs. NoSQL Databases: A Beginner's Guide
SQL (Structured Query Language) databases are relational databases. They organize data into tables with rows and columns, and they use SQL for querying and managing data. Examples include MySQL, PostgreSQL, and SQLite.
-
From zero to hero: using SQL databases in Node.js made easy
Node.js, MySQL and PostgreSQL servers installed on your machine
-
I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC)
Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).
-
How to dump and restore a Postgres DB with new table ownership
I've used MySQL for years. But recently, I found myself working PostgreSQL and simple things like dumping and restoring a database are different enough that I decided to document the process. It's straightforward enough once I knew how.
-
Test Driving a Rails API - Part One
A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:
-
Um júnior e um teste técnico: The battle.
PostgreSQL
-
How to choose the right type of database
PostgreSQL: Offers a robust feature set and strong compliance with SQL standards, making it suitable for a wide range of applications, from simple to complex, particularly where data integrity and extensibility are key.
-
NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB
FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.
-
Preventing SQL injection attacks in Node.js
To better understand how SQL injection works, let's quickly create a vulnerable app using Node.js, Express, and a PostgreSQL database. The application takes user input from a form, constructs a SQL query, and executes it against the database to fetch some data.
-
Full Stack Chat App with Socket.io
We'll use PostgreSQL, and first of all, you need to install PostgreSQL if you haven't installed it yet. https://www.postgresql.org/
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
psycopg2 - PostgreSQL database adapter for the Python programming language
ClickHouse - ClickHouse® is a free analytics DBMS for big data
toydb - Distributed SQL database in Rust, written as a learning project
phpMyAdmin - A web interface for MySQL and MariaDB
LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
Firebird - FB/Java plugin for Firebird
dbdoc - Document your database schema, because your team will thank you, and a single text file makes it easy. Works well with PostgreSQL and others.
Adminer - Database management in a single PHP file
MongoDB - The MongoDB Database
SQLAlchemy - The Database Toolkit for Python