|
Installing Django on OS X 10.5 (Leopard)
2007-10-30 05:51:00 This is a quick update to my previous installing django posts. Today I got my hands on Leopard, so far I’ve been happy but went I went about reinstalling Django I hit a snag. MacPort would encounter an error whenever it tried to build PostgreSQL. If you can wait a little while the port maintainer for ...
Installing and Running Django on a Mac - Part 1 - Getting Ready
2007-10-17 06:30:00 I’m a recent Mac convert. For the most part I’ve loved all the perks of being a Mac user but I’ve run into a road block recently. Apparently getting my favorite web application framework, Django and its various dependencies running on OS X to do local development is not as easy or clear as it ...
Intro to Drupal
2007-10-10 05:56:00 Lately I’ve been working on a few Drupal projects. Accordingly I’ve seen much of what Drupal can and can’t do. Here’s some info to help spread the word on Drupal: What is Drupal? Drupal is an open-source CMS (Content Management System) which is written in PHP and uses a MySQL or PostgreSQL database as a back-end. What’s good ...
How to Create Users and Databases easily in PostgreSQL
2007-09-15 14:45:00 After the good response to the last post on How to Install PostgreSQL easily on Windows Vista or XP?, lets today focus on how to Create new Users and new Databases easily in PostgreSQL. As mentioned previously we will use the techy psql which is the command line interface for PostgreSQL.You will need to first connect to the user postgres from your localhost to create the database owner. The command prompt postgres=# indicates that you are connected to the postgres database. The # in the command prompt actually means that the user connected to is a database superuser[Sort Off like in Linux].Creating a New User:To create a New User(mynewuser) in PostgreSQL we will use the CREATE ROLE command as follows:postgres=#CREATE ROLE mynewuserpostgres-#loginpostgre-s-#password 'mypassword';This will create a new user called 'mynewuser' with the password 'mypassword'.Creating TableSpace :Now we will move ahead to create the default tablespace for the new database. This is where the database...
How to Install PostgreSQL easily on Windows Vista or XP?
2007-09-09 15:32:00 PostgreSQL is an object-relational database management system (ORDBMS) and is distributed as a Open Source software under the BSD License. This is a very stable and useful database when you consider to use a DB free from license restrictions like SQL Server or Oracle.In this post I will explain to you simple steps to Install PostgreSQL in a Windows Vista or XP machine with ease. To start-off, you will need to download the latest release of PostgreSQL direct from the official website.Next, extract the file from the archive you have downloaded. Run postgresql-8.2.msi as an administrator user account in Vista or XP. You will then need to select your language and check "Write detailed installation log to postgresql-8.1.log in the current directory". Once you agree to the terms on the license, select what you want to install. I would suggest that you check everything from Database server and also select the installation directory. If at all you want to install PostgreSQL as a windows ser...
Beginning PHP and PostgreSQL E-Commerce: From Novice to Professional
2007-05-18 03:07:00 Publisher: Apress Language: English ISBN: 159059648X Paperback: 700 pages Data: December 5, 2006 Format: PDF Description: The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before. In Beginning ...
By: Ebooks Corner
Who Else Wants To Use PostgresSQL Instead Of MySQL?
2007-03-23 16:59:00 In a previous post I mentioned that we use PostgreSQL as our database server. Common sense might indicate that we use MySQL as that is what the core team is using and what would probably be considered to be the defacto standard for Rails development.So why are we using PostgreSQL?Probably the biggest reason we use PostgresSQL is the simplest...I like it more than MySQL. This is one of the main reasons why we picked Rails as our development platform. When all things are equal, pick the one that is more enjoyable to use as you're going to be spending lots of time with it and it helps with motivation during those long hours of a startup.Both databases are perfectly capable and I've used both on live sites but I've always found MySQL to be harder to use from the command line. This may be because I don't know how to use all the features but that's is part of the problem isn't it? Learning PostgreSQL on the command line was very easy and intuitive, MySQL isn't.The other reason...
Sun Takes a Swing at Oracle/Linux with PostgreSQL
2007-02-21 23:35:00 Hmmm, it looks like Sun is getting serious with PostgreSQL database and packaging it with Solaris 10. In this news story Sun is reported to have migrated a customer off of Oracle/Linux combination onto PostgreSQL/Solaris with much success. I'm sure this sort of move is not going to gel very well with Oracle, who has been a long standing Sun partner. And for a good reason - Solaris has always been
By: The Unix Blog
|



