Rex Chiang[Database] Race conditionA race condition is a type of bug that occurs when multiple transactions (threads or processes) access a shared resource simultaneously…2 min read·Jun 1, 2023----
Rex Chiang[Python] Variable scopesThe Python scope concept is generally presented using a rule known as the LEGB rule.2 min read·Apr 30, 2023----
Rex Chiang[Python] GIL (Global Interpreter Lock)In CPython, the GIL (Global Interpreter Lock) is a mutex that protects access to Python objects, preventing multiple threads from executing…2 min read·Apr 8, 2023----
Rex Chiang[Database] Types of IndexesAn index is a structure within database that is used to quickly retrieve specific rows from a table. An index contains keys built from one…2 min read·Feb 20, 2023----
Rex Chiang[Pytest] MarkerMarkers are used to set various features or attributes to tests, and can use related API to set metadata on tests.2 min read·Feb 5, 2023----
Rex Chiang[Pytest] FixtureFixtures are functions that run before or after tests, like setup or teardown. Fixtures are used for data configuration, initialization…2 min read·Feb 5, 2023----
Rex Chiang[Django_Rest_Framework] Dynamic serializer fieldsDynamic fields in serializer can retrieve the required fields from the model, and speed up the serializing if the query doesn’t need to…1 min read·Jul 18, 2022----
Rex Chiang[Django_Rest_Framework] Eager loadingStraightforward usage of the Django REST Framework and its nested serializers can kill performance of API endpoints. The database is…2 min read·Jul 17, 2022----