Loading repository data…
cojocaru-david / repository
A modern, high-performance personal portfolio and blog built with Astro.js. Designed to showcase your projects and technical writing with blazing-fast performance and exceptional SEO.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
A modern, high-performance personal portfolio and blog built with Astro.js. Designed to showcase your projects and technical writing with blazing-fast performance and exceptional SEO.
Selected from shared topics, language and repository description—not editorial ratings.
milewskibogumil /
⚡️ Kickstart your web projects with the Astro + Sanity + Turbopack Starter! Integrate Astro, Sanity CMS, and Turbopack for high performance, Core Web Vitals optimization, and SEO-friendly web development. Perfect for building modern, fast, and flexible web applications with ease.
39/100 healthBefore you begin, ensure you have the following installed:
Clone the repository
git clone https://github.com/cojocaru-david/portfolio.git
cd portfolio
Install dependencies
npm install
# or
yarn install
Start the development server
npm run dev
# or
yarn dev
Open your browser
Navigate to http://localhost:4321 to see the site running locally.
portfolio/
├── public/ # Static assets
├── src/
│ ├── components/ # UI components
│ ├── content/ # Content collections
│ │ ├── blog/ # Blog posts in MD/MDX format
│ │ └── projects/ # Project data
│ ├── layouts/ # Page layouts
│ ├── lib/ # Utility functions
│ ├── pages/ # Page routes
│ └── styles/ # Global styles
├── astro.config.mjs # Astro configuration
├── tailwind.config.cjs # Tailwind CSS configuration
├── tsconfig.json # TypeScript configuration
└── package.json # Project dependencies
.mdx or .md file in src/content/blog---
title: "Your Post Title"
description: "A brief description of your post"
date: 2025-04-20
tags: ["tag1", "tag2", "tag3"]
authors: ["Your Name", "Co-author (optional)"]
---
# Your Post Title
Write your content here using Markdown.
## Subheading
More content...
.md file in projectsThe project includes dark mode support using Tailwind CSS and Preact. It detects user preferences and applies the appropriate theme, with an option to toggle between light and dark modes.
The project includes several utility functions in data-utils.ts:
getAllPosts() - Retrieve all blog postsgetRecentPosts(count) - Get the most recent postsgetAdjacentPosts(currentId) - Get next and previous postsgetAllTags() - Get all tags used in postsgetSortedTags() - Get tags sorted by usage countgetPostsByAuthor(authorId) - Get all posts by a specific authorThe portfolio includes a post feedback system allowing visitors to like or dislike blog posts. This feature requires a PostgreSQL database to store vote data. This guide explains how to set it up using Neon.tech.
Create a Neon.tech Account
Create a New Project
Get Connection Details
Set Environment Variables
.env file in your project root (if not already present)DATABASE_URL=your_neon_connection_string_here
Run the following SQL queries in the Neon SQL Editor to create the necessary tables for the feedback system:
CREATE TABLE post_feedback (
id SERIAL PRIMARY KEY,
post_id VARCHAR(255) NOT NULL,
likes INTEGER DEFAULT 0,
dislikes INTEGER DEFAULT 0,
CONSTRAINT unique_post_id UNIQUE (post_id)
);
CREATE TABLE post_likes (
id SERIAL PRIMARY KEY,
post_id VARCHAR(255) NOT NULL,
fingerprint_id VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT unique_like UNIQUE (post_id, fingerprint_id)
);
CREATE TABLE post_dislikes (
id SERIAL PRIMARY KEY,
post_id VARCHAR(255) NOT NULL,
fingerprint_id VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT unique_dislike UNIQUE (post_id, fingerprint_id)
);
CREATE INDEX idx_post_feedback_post_id ON post_feedback (post_id);
CREATE INDEX idx_post_likes_post_id_fingerprint ON post_likes (post_id, fingerprint_id);
CREATE INDEX idx_post_dislikes_post_id_fingerprint ON post_dislikes (post_id, fingerprint_id);
The feedback system consists of three tables:
post_feedback: Stores aggregate counts of likes and dislikes for each postpost_likes: Records individual like actions with fingerprint IDs to prevent duplicate votespost_dislikes: Records individual dislike actions with fingerprint IDsThe portfolio includes API endpoints for handling likes and dislikes:
Fetching Post Feedback
/api/like/{postId} returns current like/dislike countsSubmitting Likes
/api/like/{postId} with fingerprint ID in the request bodySubmitting Dislikes
/api/dislike/{postId} works similarly to the like endpointWhen a new blog post is created:
post_feedbackTo reset likes for a post:
DELETE FROM post_likes WHERE post_id = 'your-post-id';
DELETE FROM post_dislikes WHERE post_id = 'your-post-id';
UPDATE post_feedback SET likes = 0, dislikes = 0 WHERE post_id = 'your-post-id';
To view post statistics:
SELECT * FROM post_feedback ORDER BY likes DESC;
To find which posts a specific user has interacted with:
SELECT post_id FROM post_likes WHERE fingerprint_id = 'specific-fingerprint-id';
If you encounter issues with the feedback system:
Check Environment Variables
.env file contains the correct DATABASE_URLVerify Database Connection
Check for Errors in Console
Reset User Vote State
// In browser console
localStorage.clear()
Contributions are welcome! Please feel free to submit a Pull Request.
git checkout -b feature/amazing-feature)git commit -m 'Add some amazing feature')git push origin feature/amazing-feature)This project is licensed under the MIT License - see the LICENSE file for details.