database ~ C#, .NET, Java, Php, Python, Wordpress, Windows, Linux…

LINQ to SQL: Draw objects in C #, before creating the DB

December 27th, 2010 marco No comments

I'm not saying you should delete the database from the planning documents for designing a new application. Not at all. The database design is an important part of the development process and should never be overlooked, if necessary. At the same time, sometimes it is easier to begin the design process in another way – the least common.

From my experience, in designing a database from the beginning gives a rather rigid structure. After defining the tables and created some stored procedures, developers start working on their applications trying to adapt the application to existing conditions of the DB and often they must reach compromises because a small change to a table in DB can ruin an entire chain of relationships between tables.

How to create a table in PHP in a MySQL database

December 22nd, 2010 marco No comments

In this article we will see in Php you can create a table in a database MySQL. Before we tackle the config.php file in which there are parameters to connect to MySQL server and the PHP functions for connecting and then tackle the file for table creation, the end of the post you'll find inside the zip with the 2 php file that you can download to do all the tests you want.

PostgreSQL 9.0 offers many new features

December 15th, 2010 marco No comments

PostgreSQL has always had characteristics of strength and was the first database open source to have passed the test ACID, which is a sign of professionalism. With the recent release of 9, PostgreSQL has added many requested features that really put him above the average of the database.

The biggest news of PostgreSQL 9.0 is the replication stream. Existed for some time third-party solutions for this feature, but now there is a solution “Journal” that comes with the Postgres server. Streaming allows replication to one or more databases to replicate from a master server to secondary servers atria. This is an asynchronous transfer, but very fast.

In addition to the new replica streaming, Postgres 9,0 There is also a hot standby capacity. This allows a secondary database to be designated as a hot standby in case the primary database fails. In addition, The hot standby can be used as a read-only database, while the primary database is active. This allows a certain level of load balancing and PostgreSQL port closest to the ability to support active-active configurations.