Prague Based
Global reach
Get in touchSay Ahoj! 👋Email copied! ✈️

Backend Integration

Year

2025

Services

Next.jsPostgreSQLDrizzle ORMAudit LoggingType-safe APIsTypeScript

Summary

Backend infrastructure for an e-commerce platform — handling authentication, sessions, and complete audit trails for security and compliance. Built with PostgreSQL and Drizzle ORM.

70%
verification
🔑 iduuid
identifiertext
valuetext
expires_attimestamp
created_attimestamp
coupons
🔑 iduuid
codetext
discount_typeenum
discount_valuenumeric(10,2)
min_purchase_amountnumeric(10,2)
max_usesinteger
current_usesinteger
valid_fromtimestamp
valid_untiltimestamp
is_activeboolean
created_attimestamp
user
🔑 iduuid
nametext
emailtext
email_verifiedboolean
imagetext
created_attimestamp
updated_attimestamp
account
🔑 iduuid
🔗 user_iduuid
guest_iduuid
provider_idtext
access_tokentext
refresh_tokentext
expires_attimestamp
created_attimestamp
guest
🔑 iduuid
session_iduuid
created_attimestamp
session
🔑 iduuid
🔗 user_iduuid
expires_attimestamp
tokentext
ip_addresstext
user_agenttext
created_attimestamp
genders
🔑 iduuid
labeltext
slugtext
brands
🔑 iduuid
nametext
slugtext
logo_urltext
categories
🔑 iduuid
nametext
slugtext
descriptiontext
parent_iduuid
colors
🔑 iduuid
nametext
slugtext
hex_codetext
sizes
🔑 iduuid
nametext
slugtext
sort_orderinteger
collections
🔑 iduuid
nametext
slugtext
descriptiontext
is_activeboolean
created_attimestamp
addresses
🔑 iduuid
🔗 user_iduuid
typetext
address_typetext
first_nametext
last_nametext
streettext
citytext
statetext
postal_codetext
phonetext
is_defaultboolean
created_attimestamp
updated_attimestamp
carts
🔑 iduuid
🔗 user_iduuid
🔗 guest_iduuid
created_attimestamp
updated_attimestamp
products
🔑 iduuid
nametext
descriptiontext
🔗 category_iduuid
🔗 gender_iduuid
🔗 brand_iduuid
is_publishedboolean
default_variant_iduuid
created_attimestamp
updated_attimestamp
orders
🔑 iduuid
🔗 user_iduuid
guest_emailtext
statusenum
order_statusenum
shipping_pricenumeric(10,2)
total_amountnumeric(10,2)
delivery_methodtext
payment_methodtext
delivery_addressjson
🔗 shipping_address_iduuid
🔗 billing_address_iduuid
created_attimestamp
updated_attimestamp
reviews
🔑 iduuid
🔗 product_iduuid
🔗 user_iduuid
ratinginteger
titletext
contenttext
is_verified_purchaseboolean
updated_attimestamp
product_variants
🔑 iduuid
🔗 product_iduuid
skutext
🔗 color_iduuid
🔗 size_iduuid
pricenumeric(10,2)
sale_pricenumeric(10,2)
in_stockboolean
weightnumeric
dimensionstext
created_attimestamp
updated_attimestamp
product_collections
🔑 iduuid
🔗 product_iduuid
🔗 collection_iduuid
sort_orderinteger
created_attimestamp
payments
🔑 iduuid
🔗 order_iduuid
amountnumeric(10,2)
methodtext
statusenum
created_attimestamp
order_items
🔑 iduuid
🔗 order_iduuid
🔗 product_variant_iduuid
quantityinteger
price_at_purchasenumeric(10,2)
wishlists
🔑 iduuid
🔗 product_iduuid
🔗 variant_iduuid
created_attimestamp
product_images
🔑 iduuid
🔗 product_iduuid
urltext
sort_orderinteger
is_primaryboolean
cart_items
🔑 iduuid
🔗 cart_iduuid
🔗 product_variant_iduuid
quantityinteger
Drag to explore

Type-Safe Filtering with Drizzle ORM

Composable WHERE clauses with full type safety — no N+1 queries, SQL injection protected, scales without refactoring.

srclibactionsproduct.ts
Loading...

Secure, traceable,
built to scale.

A robust backend foundation designed for security, auditability, and long-term maintenance.

<100ms

Database updates with full audit logging

Complete audit trail

Every database change tracked with user, timestamp, and context

90%

TypeScript coverage across the entire codebase

Backend integration showcase
Product listing page mockup
Product details page mockup
Product listing mobile mockup
Product details mobile mockup