Database design and optimization (SQLite/PostgreSQL).
As part of the portal development, I designed the database structure to ensure quick access to publications and their categories. I set up many-to-many relationships for tags and one-to-many relationships for authors. I worked on optimizing queries to reduce server load.
Stack: SQL, PostgreSQL, Django ORM.
Stack: SQL, PostgreSQL, Django ORM.