DEV Community: Anwar Achilles

Example Online Postgre with Neon.com – Rune + RedBean CLI Application

Anwar Achilles — Sat, 04 Oct 2025 14:59:16 +0000

This project is an example CLI application demonstrating how to use Neon PostgreSQL (a fully managed cloud PostgreSQL platform) in combination with Rune and RedBeanPHP. The application allows you to perform CRUD operations on a user table directly from the CLI, making it perfect for developers who want a lightweight, fast, and flexible way to interact with a database without building a full web interface.

The project leverages:

Neon PostgreSQL – cloud-hosted PostgreSQL database
Rune – for CLI management and scripting
RedBeanPHP – lightweight ORM for PHP

Features

Create, read, update, and delete users using CLI commands.
Easily create database tables via scripts.
Works with Neon PostgreSQL in the cloud.
Clean, simple, and easy-to-extend structure.

Installation & Setup

Follow these steps to get started:

1. Clone the repository

git clone https://github.com/AnwarAchilles/example-online-postgre.git
cd example-online-postgre

2. Load vendor packages

composer install

3. Configure database connection Edit the main setup file where RedBean connects to Neon PostgreSQL. Replace placeholders with your Neon credentials:

$NEON_HOST = '';
$NEON_DB   = '';
$NEON_USER = '';
$NEON_PASS = '';

R::setup(
    "pgsql:host=$NEON_HOST;dbname=$NEON_DB;sslmode=require",
    $NEON_USER,
    $NEON_PASS
);

Using placeholders keeps your credentials safe for sharing or pushing to a repository.

Running the Application

To start the CLI application:

php cast

This will show available commands and let you run scripts, manage users, or view results.

 #  R E G I S T E R E D.
 ♦ php cast script
    #≈ runs a script, e.g., creating database t
    ables.
 ♦ php cast result
    #≈ lists all user emails in the database.
 ♦ php cast create
    #≈ create a new user, --email=(string)
 ♦ php cast update
    #≈ update an existing user, --id=(int) --em
    ail=(string)
 ♦ php cast delete
    #≈ delete an existing user, --id=(int)

Step by Step

1. Create the user table

php cast script

This runs the script to create a user table if it does not exist.

2. Add a new user

php cast create --email=demo@mail.com

Adds a new user to the database.

3. View all users

php cast result

Lists all emails currently stored.

4. Update a user’s email

php cast update --id=1 --email=updated@mail.com

Updates the email for the user with id=1.

5. Delete a user

php cast delete --id=1

Removes the user from the database.

References

Rune GitHub - Mangement Tools
Neon - Managed PostgreSQL
RedBeanPHP - Lightweight ORM for PHP
Repo - Github Repository

Summary

This project is an example showing how to integrate and use Neon PostgreSQL in PHP, with database management organized neatly using Rune. It demonstrates how to perform CRUD operations via CLI commands with RedBean, making it easy to understand the workflow and structure when working with a cloud PostgreSQL database.

Exploring the Concept of RUNE: A Dev Tool That’s Still Evolving

Anwar Achilles — Sat, 19 Jul 2025 12:28:05 +0000

Rune is a lore-driven, modular concept beneath PHP,
designed not to dictate development — but to respond to it.

A B O U T

Within Rune’s architecture:

Ether defines truth
Essence holds flow
Entity performs behavior

Each is awakened only when invoked — making every element:

Composable 🧩
Lazy-loaded 🌙
Purpose-driven 🎯

Rune is inherently lightweight and adaptable, ideal for systems that grow from concept, not convention. Whether you’re shaping internal tools, backend systems, or modular workflows — Rune lets developers sculpt structure from intent, not instruction.

C O R E

Here’s a breakdown of the core components in Rune's system:

✦ Manifest

A static class copied from the main controller. Used as a full-feature blueprint that users can modify and extend directly.

✦ Ether

An absolute, unchangeable constant. Reflects rules and system-wide options — the truth within the architecture.

✦ Essence

A mutable global state. Holds dynamic data, constantly changing to reflect the system's current flow.

✦ Entity

A function, representing a small logical behavior. Part of a broader process — activated only when needed.

✦ Phantasm

An auxiliary static class, like a shadow of Manifest. Ideal for fallback logic or mirrored behaviors without direct control.

💡 Rune is not a framework. It's a concept to shape intention-first architecture beneath PHP.

S T R U C T U R E

Here’s a basic overview of how a Rune-powered PHP file is structured:

<?php
// Autoload using PSR-4 standard
require_once __DIR__ . '/vendor/autoload.php';

// Importing Manifest classes for different modules
use Rune\Aether\Manifest as Aether;
use Rune\Chanter\Manifest as Chanter;
use Rune\Weaver\Manifest as Weaver;
use Rune\Whisper\Manifest as Whisper;
// ... Add more modules as needed

// Each Manifest exposes three key components:
// - ether()   → immutable constants (rules/options)
// - essence() → mutable state/data (flow)
// - entity()  → functional behavior (action/logic)
Aether::ether()::essence()::entity();
Chanter::ether()::essence()::entity();
Weaver::ether()::essence()::entity();
Whisper::ether()::essence()::entity();
// ... Extendable across modules

// Start the Rune lifecycle
Aether::begin();   // Bootstraps or initializes the module

// "Playground" — your logic lives here
Aether::dd(['welcome here']); // Debug/Display output

// End the Rune lifecycle
Aether::end();     // Gracefully terminate or finalize module processes

php {FILE}

B U I L T - I N

✦ Grimoire

The grimoire is a dynamic record of the system including the phantasm of runes, and the arcane of logs.

php {FILE} grimoire

✦ Sentinel

sentinels act as your right hand in building systems with runes.

php {FILE} sentinel

✦ Artefact

An artifact reflects a backup or fragment of a system built in the past.

php {FILE} artefact

🖼️ I N T E R F A C E

A visual glimpse into Rune’s internal experience.

Each interface represents a distinct layer of the system — from entry to execution.

✦ Entrance

The starting point of every Rune invocation.

Shows basic module loads, version info, and preflight checks.

✦ Built-in

Displays available built-in commands (grimoire, sentinel, artefact).

Think of it as your spellbook index — fast access to internal magic.

✦ Grimoire Rune

Visual snapshot of the grimoire — a system record

containing phantasms, metadata, and spell traces (rune logs).

✦ Runtime Summary

Logs the execution performance of a rune:

including time spent, memory usage, and exit state.

✦ Arcane Logs

Deep dive into the mysterious flow of behavior.

These logs track function calls, essence changes, and triggered entities.

✦ Zero Trust

is a special mode where Rune limits its behavior strictly to the main process — ignoring arcane logs, bypassing the Chanter lifecycle, and preventing Whisper from triggering any end-phase emissions. This mode is ideal for clean execution environments where minimal interference and full isolation are required.

E X I T

🔗 https://github.com/devneet-id/rune

Rune is still under active development and refinement.

The current implementation serves as a foundation, laying out its lore-driven modular system — where each part reflects a story, structure, and purpose — but many advanced features and deeper integrations are still being built.

This version is best suited for experimental use, early contributions, or for developers exploring modular, composable systems outside of conventional frameworks.

Stability may vary between modules, and certain built-in tools (like Grimoire, Sentinel, and Artifact) are still evolving toward their intended forms.

Originally, Rune was something I built for personal use —

a tool to simplify tasks like automation, bundling, backup, benchmarking, and unit-testing.

Over time, it evolved into something deeper: a modular concept inspired by structure, clarity, and story.

If you find value in its design, or feel curious about how it's built,

feel free to explore, fork, contribute, or simply watch the project unfold over time.

The device is not yet complete — but its potential is waking.

Simple Pic Upload Preview

Anwar Achilles — Sun, 01 Jun 2025 14:05:52 +0000

This is a simple program for a file input form with image preview functionality. Users can select an image, and it will be displayed instantly before uploading. It’s easy to use and can be further developed to fit more advanced needs. Hope you like it! 💕✨

🖥️ Showcase Preview:

🔗 Visit My Channel

If you're interested in learning more, check out my YouTube channel where I share tutorials, tips, and coding experiments. Don't forget to subscribe and stay tuned for more!
youtube.com/@anwarachilles
tiktok.com/@anwar.achilles

🛠️ Let’s Connect!

Let’s connect more closely! Follow my social media accounts below, and don’t hesitate to reach out if you have exciting ideas for experiments or collaborations.
anwarachilles.pro
instagram.com/anwar_achilles
github.com/AnwarAchilles

Enjoy! 😊

Glam Up My Markup: ❄️ Celebrations Winter Solstice

Anwar Achilles — Tue, 24 Dec 2024 00:03:13 +0000

This is a submission for Frontend Challenge - December Edition, Glam Up My Markup: Winter Solstice

What I Built

This landing page is designed to showcase not only a visually stunning and interactive UI/UX but also a highly optimized performance. The theme revolves around the winter solstice, complemented by an AI-generated image as the opening element. This carefully selected image serves as a bold invitation to embrace the beauty of a winter sunrise.

You can explore more inspiration behind the design through this Pinterest board: https://id.pinterest.com/pin/306385580915655056

The page combines creative code snippets and innovative elements like Overlay Scrolling, Observer Elements, and a snowflake animation. This snowflake effect isn't a simple looped animation—it perfectly aligns with user interactions, creating a cohesive and immersive experience.

Demo

Journey

During the journey of building this landing page, I delved into techniques that blend design and performance optimization. The challenge was to make every element feel interactive yet smooth. I utilized technologies like Overlay Scrolling and Observer Elements to provide seamless user experiences.

One of the most rewarding parts was crafting the snowflake animation. It follows the user’s interactions fluidly, enhancing the overall winter theme without compromising on performance. I’m particularly proud of how it turned out, as it feels alive and responsive, unlike static animations.

For the next steps, I aim to incorporate more AI-generated visuals to elevate the page's artistic touch and continue refining the animations for even better performance. Collecting user feedback will also be vital in enhancing the overall experience and ensuring it resonates with the audience.

Custom YouTube Player Gadget with Javascript

Anwar Achilles — Sat, 21 Dec 2024 16:46:28 +0000

This YouTube Video Player is created using the YouTube Player API with an iframe-based structure. It is built with JavaScript and packaged as a ready-to-use class, ensuring ease of use and customization. This project is a collaboration with the YouTube channel Its Nocturna, featuring a curated music playlist paired with a stunning visualizer.

🖥️ Codepen Preview

✨ About This Collaboration

This project seamlessly blends technology and creativity to deliver a captivating user experience.

Development: Designed and developed by Anwar Achilles, the custom YouTube player is a versatile and robust solution built to enhance user interaction. With features like playlist integration, customizable themes, looping options, and seamless performance, this library offers a high degree of flexibility for various use cases.

Content: Curated by Its Nocturna, the playlist is a carefully selected collection of NIGHTCORE tracks that elevate the visualizer experience, perfectly syncing music.

This collaboration highlights the power of combining innovative development with creative content to push the boundaries of what technology can achieve in music and entertainment.

Project Highlights

🚀 Anwar Achilles

Custom YouTube Player Gadget
Short Video on YouTube
Short Video on TikTok

🚀 Its Nocturna

NIGHTCORE - 100$ (Løvesick) Speed Up Version
Short Music on YoutTube
Full Music on Youtube

Discover Our Work

🔗 Anwar Achilles

Check out my YouTube for tutorials, tips, and coding experiments. Subscribe for more!
youtube.com/@anwarachilles
tiktok.com/@anwar.achilles
instagram.com/anwar_achilles
github.com/AnwarAchilles
anwarachilles.pro

🔗 Its Nocturna

Explore high-energy NIGHTCORE tracks and stunning visuals. Subscribe for more captivating music playlists!
youtube.com/@its.nocturna
Member of Nightcore Community

Hope you like it! 😊

Targeted Element Parallax with Javascript

Anwar Achilles — Mon, 16 Dec 2024 22:04:18 +0000

A parallax effect, but only for HTML object elements? Yes! Here, we'll demonstrate how to create a parallax effect not on the background but instead applied to object elements. Complete with a JavaScript class you can use directly, saving you time and effort.

🖥️ Showcase Preview:

🔗 Visit My Channel

🛠️ Let’s Connect!

Enjoy! 😊

Auto Step Input Number with Javascript

Anwar Achilles — Thu, 12 Dec 2024 17:10:30 +0000

Have you ever seen a PIN input field? It’s not just one input field but typically 6 separate input boxes. By manipulating the maxLength attribute and using a stepping technique between inputs, you can create a functional PIN input. Here's an example I’ve created for you.

🖥️ Showcase Preview:

🔗 Visit My Channel

🛠️ Let’s Connect!

Enjoy! 😊

Image Loading Optimization with Javascript

Anwar Achilles — Sun, 08 Dec 2024 06:12:17 +0000

Optimize your website's page speed, especially when it comes to loading images. If there's just one image, you might not notice the impact, but what if there are 10 images on a single page? Your page will wait for all 10 images to finish loading. The best technique to tackle this is by optimizing image loading. How? Load images only after the page has fully loaded its markup. That's it!

🖥️ Showcase Preview:

🔗 Visit My Channel

If you're interested in learning more, check out my YouTube channel where I share tutorials, tips, and coding experiments. Don't forget to subscribe and stay tuned for more!
anwarachilles.pro
youtube.com/@anwarachilles
tiktok.com/@anwar.achilles

🛠️ Let’s Connect!

Let’s connect more closely! Follow my social media accounts below, and don’t hesitate to reach out if you have exciting ideas for experiments or collaborations.
instagram.com/anwar_achilles
github.com/AnwarAchilles

Enjoy! 😊

Scrolling Sticky Overlay Effect with Javascript

Anwar Achilles — Tue, 03 Dec 2024 11:19:25 +0000

Have you ever noticed a page scroll effect that feels like flipping through a book? Here, we’ll create that effect, which we’ll call a scrolling sticky overlay. Below is a short example along with the code.

🖥️ Showcase Preview:

🔗 Visit My Channel

🛠️ Let’s Connect!

Hope you like it! 😊

Progress Bar Animation Ideas

Anwar Achilles — Sun, 27 Oct 2024 10:51:28 +0000

Check Out This Pen I Made!
Hey everyone! Check out this new Pen I created on CodePen:

If you want to see more content, feel free to visit my YouTube channel:

🔗 Visit My YouTube Channel!

Enjoy! 😊

Button Style Variant ideas

Anwar Achilles — Sat, 12 Oct 2024 20:08:04 +0000

Check Out This Pen I Made!
Hey everyone! Check out this new Pen I created on CodePen:

If you want to see more content, feel free to visit my YouTube channel:

🔗 Visit My YouTube Channel!

Enjoy! 😊

Text Wave Animation

Anwar Achilles — Fri, 11 Oct 2024 23:14:54 +0000

Check Out This Pen I Made!
Hey everyone! Check out this new Pen I created on CodePen:

If you want to see more content, feel free to visit my YouTube channel:

🔗 Visit My YouTube Channel!

Enjoy! 😊