Custom Programming, Database, Free for Web, Server-side Scripting, Web Server
Lately I’ve been performing lots of fresh system installs, a result of testing my Ubuntu respin. Restoring my personal data after such an install is simple enough, but having to reinstall my Apache, MySQL & PHP set-up requires a little more effort. So, for future reference I’ve decided to record the process. By following the instructions below I should be able to get my development server up and running within minutes.
AMP install instructions
1. Open a terminal and issue the following command to install the three main packages:
sudo apt-get install apache2 mysql-server php5
This will install the following packages:
apache2 apache2-mpm-prefork apache2-utils apache2.2-common libapache2-mod-php5
libapr1 libaprutil1 libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perllibplrpc-perl libpq5 mysql-client-5.0 mysql-common mysql-server mysql-server-5.0
php5 php5-common
…
Full article: http://crunchbang.org
License: Creative Commons Attribution-Share Alike 2.0 UK
Indexed in June 2008
Related Info Web
Database, Free for Web, Tools
..
MySQL Tools -
Apart from being a popular open source database. It also has some amazing tools, which have been formed, due to years of users invaluable feedback, on their forums. Here’s what the website describes about MySQL Administrator;
MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating
..
MySQL and NetBeans -
So, you want to use MySQL with NetBeans, I guess Java is your language of choice for development in NetBeans, as it provides such a fabulous Java Editor since 6.0 FCS and now, its really amazing in 6.1 FCS. You could try making a database application using Swing Application Framework, which lets you create a CRUD application.
Firstly, you need a JDBC driver, as we are using Java to connect to MySQL databases, then you have to go for Connector/J (IV Type Driver), there are some more available for other languages too.
…
Full article: http://nbguru.wordpress.com
License: Creative Commons Attribution-Share Alike 2.5 India
Indexed in June 2008
Related Info Web
Database, Maintenance Web, Tools
By default, MySQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home or from web server.
Step # 1: Login over ssh if server is outside your IDC
First, login over ssh to remote MySQL database server
Step # 2: Enable networking
Once connected you need edit the mysql configuration file my.cfg using text editor such as vi.
- If you are using Debian Linux file is located at /etc/mysql/my.cnf location
- ..
…
Full article: http://www.sinidaily.com
License: Creative Commons License
Indexed in June 2008
Related Info Web
Database, Maintenance Web, Web Articles for Dummies
Before performing any procedures that affect your database (such as installing or upgrading a module), you should create a backup in case you need to restore your site. The database contains all of the content of your website, as well as its settings and configuration options..
Most web providers use software called PhpMyAdmin to allow easy administration of the MySQL database software that is also commonly used. This tutorial will focus on using it to create a backup.
- The exact method for reaching the PhpMyAdmin page for your website differs depending on your web host..
…
Full article: http://www.topnotchthemes.com
License: Creative Commons Attribution-Share Alike 3.0 United States
Indexed in May 2008
Related Info Web
Custom Programming, Database, Framework, Ruby on Rails
Joe points out the following from this interview with Twitter’s Alex Payne:
The problem is that more instances of Rails (running as part of a Mongrel cluster, in our case) means more requests to your database. At this point in time there’s no facility in Rails to talk to more than one database at a time.
..
In my case, ActiveRecord provided exactly the right level of functionality. I can have multiple database connections established and write code to manage when each should be used. Control of which connection is used is managed at the model level. Connections cascade up inheritance chains and I can specify that one model use the connection specified on another model using a simple delegate statement:
class A < ActiveRecord::Base
end
class B < ActiveRecord::Base
class << self
delegate :connection, :to => A
end
end
…
Full article: http://tomayko.com/writings/rails-multiple-connections
License: Creative Commons
Indexed in May 2008
Related Info Web
Custom Programming, Database, Web Server
This document will walk you through the installation of what is known as a “LAMP” system: Linux, Apache, MySQL and PHP. Depending on who you talk to, the P also stands for Perl or Python, but in general, it is assumed to be PHP. I run CentOS on my servers; these directions were written for CentOS/Red Hat/Fedora..
..
I designed this document so you can just copy/paste each line or block of commands into your shell session and it will “just work” for you. This avoids tedious typing, and the inevitable typos or missed steps that result..
…
Full article: http://lamphowto.com/
License: Creative Commons License
Indexed in April 2008
Related Info Web
Custom Programming, Database, Framework
Cakephp lets you define various kinds of associations between models. The principle is really simple, just define arrays like $hasMany in your main model, where associations with other models are defined.
For most purposes this does the trick, most associations are made by convention, but you can override these as well for e.g. database (foreign-) keys.
…
Full article: http://squio.nl
License: Creative Commons Naamsvermelding-Gelijk delen 2.5 Nederland
Indexed in April 2008
Related Info Web
Database, Free for Web, Web Articles for Dummies, Web based Application
Introduction
This document answers the question that some clients ask: “Why use PostgreSQL (as opposed to MySQL, Oracle, MS-Access, FoxPro, etc.) for web application development?” PostgreSQL is a Relational Database Management System (RDBMS) that Summersault prefers as the back-end data management component for the database driven websites that we develop..
..
Choosing PostgreSQL
We’ll address a couple of key factors that one should look at in choosing an RDBMS for a production-quality web application, and why we think PostgreSQL comes out on top for our typical application needs:
- General Advantages
- Features
- ..
…
Full article: http://support.summersault.com/why_postgresql.html
License: Creative Commons License
Indexed in April 2008
Related Info Web
Database, Web Articles for Dummies
This is my comparison of installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of state of the art for three categories of DB: Commercial vs. Academe vs. Internet Model. This is a comparison from the view of a new user wanting to install a database to learn. I’m trying to keep the viewpoint of a home or small business user.
..
I am ranking this comparison on six factors:
- Documentation and Getting Started Support
- Ease of installation
- Ease of Verifying Successful Installation
- Creation of Non-Admin User
- Time to Run First Query
- Resource Requirements
…
Full article: http://blogs.ittoolbox.com
License: Creative Commons Attribution-Share Alike 3.0 United States
Indexed in April 2008
Related Info Web
Database
MySql is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks!
I still hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three main places to look for problems are:
1. Faulty Database Design
…
Full article: http://www.articlesbase.com
License: Creative Commons License
Indexed in March 2008
Related Info Web
