Home
« Older Entries » Newer Entries
🚀 Technology Blog
Things I found userful while working on different projects.
Online Shopping System–Database Design
Database design of Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wishlist / watchlist is needed, the schema can be simply extended. Enjoy. Entities: users – shop admin, owner and customers products – products to sell […]
Quiz System–Database Schema Design
MySQL Database Schema design for quiz system. Schema Diagram: MySQL Create Script: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 01, 2013 at 08:27 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION […]
Photo Video Gallery–Database Design
Database design for photo video gallery website / app. Enjoy. Schema Diagram: MySQL Create script: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 03, 2013 at 10:25 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; […]
Marksheet Generation System–Database Design
Schema for Marksheet Generation System useful for school, colleges and institutes to store student’s information, exam marks etc. Extend at your will. Schema Diagram: MySQL Create Script phpMyAdminDump: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 02, 2013 at 07:28 PM — Server version: 5.1.37 — […]
Simple CMS (Content Management System) – database design
Schema design of simple content management system. Schema and tables itself speak about the type of information indented to be stored by the system. Schema Diagram: MySQL Create Script phpMyAdmin dump: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Mar 30, 2013 at 10:20 PM — Server […]
Online Vehicle Ticketing System Database Design Sample
Online Bus/Vehicle Ticketing System Database Design Sample – MySQL. With minor modifications or further generalization this database schema can be used to implement any kind of ticket booking system. eg. movie ticket booking system, events/show ticket booking etc. Entities: users – user details user_type – type of users in system vendors – providers’ information, in […]
PyroCMS Themes, Widgets and Modules – for reference.
Themes : https://github.com/semicolondevelopers/pyro_theme_artificial_castinghttps://github.com/semicolondevelopers/pyro_theme_blue_spadeshttps://github.com/semicolondevelopers/pyro_theme_business_timehttps://github.com/semicolondevelopers/pyro_theme_coffeehttps://github.com/semicolondevelopers/pyro_theme_eco_designhttps://github.com/semicolondevelopers/pyro_theme_night_club PyroCMS v1.3.2 Theming Guide for beginners:http://echo.semicolondev.com/2011/11/hot-to-create-pyrocms-v132-theme-step.html PyroCMS Tag Cheat Sheet Widgets https://github.com/semicolondevelopers/pyro_widget_categoryhttps://github.com/semicolondevelopers/pyro_widget_login_boxhttps://github.com/semicolondevelopers/pyro_widget_selected_category_posts PyroCMS v1.3.2 Widget creation guide for beginnershttp://echo.semicolondev.com/2011/11/how-to-create-pyrocms-v132-widgets.html Modules: Hello World Module https://github.com/semicolondevelopers/pyro_module_hello Old 0.9.9.x Forum module upgraded to v1.3.2 https://github.com/semicolondevelopers/pyro_module_forums PyroCMS v1.3.2 & v0.9.9.7 Module Creation guide for beginners:http://bhu1st.blogspot.com/2010/09/hello-world-pyrocms-module.html
नेपाली ब्लगरहरुलाई छोटो मीठो सल्लाह
Quick SEO tip for Nepali (Unicode) Bloggers Here goes, one quick SEO (Search Engine Optimization) tip for Nepali Bloggers who use Blogger.com to publish their content written in Nepali Unicode. What I’m talking about ? Say: your blog post title is “मेरो नेपाल” You publish it. Now blogger gives you one random “url/permalink” to your […]
Web development “real” life cycle
Few guys known as manager, designer, software engineer, tester are feeling pressure in what we call Semicolon Valley here, because few other guys known as information architecture, user interface designer, user experience designer, database designers left Nepal thinking there is no work for them here. They never bothered to try creating work here. The smart […]
Android SDK and AVD Manager slow download problem
I was Installing the Android SDK (http://developer.android.com/sdk/installing.html) on my Windows XP box. Problem : Slow download of android SDK platforms ~5kb/s Android SDK and AVD Manager Stalling During Download : Google Groups Android sdk download/update failing : Stack Overflow How to speed up Android SDK platform download ? 1. Allow download over http : check […]
PHP Short Tag : Avoid Them
PHP Short Tag: it look like this: <? ?> <?= $var ?> obvious ones: <?php ?> <?php echo $var ?>. I downloaded an open source php script, thinking to work it out for my own purpose – but what sucks is – the project uses short tag that my host doesn’t *seems* to provide support […]