SoC postgres support - Revision history

Dirk: link to project repository

2009-05-21T16:05:52Z

link to project repository

Dirk: list student / mentor on the top of the page

2009-05-15T18:59:27Z

list student / mentor on the top of the page

Choplair at 14:59, 9 May 2009

2009-05-09T14:59:25Z

Choplair: /* = Project info and advancement during Summer of Code */

2009-05-09T14:58:31Z

‎= Project info and advancement during Summer of Code

Choplair: separation of content that prepared SoC, and (future) content about the concrete summer project advancement

2009-05-09T14:58:15Z

separation of content that prepared SoC, and (future) content about the concrete summer project advancement

Vinny at 19:04, 18 March 2009

2009-03-18T19:04:53Z

Dirk: Typo

2009-02-05T14:48:43Z

Typo

Dirk: GSoC idea: Postgres support

2008-11-07T16:16:38Z

GSoC idea: Postgres support

New page

<center>(This is an idea page for the [[Google Summer of Code]])</center>

== Incentive ==

Geeklog currently supports MySQL and MS SQL Server for the database. Recently, we have had an increasing amount of requests to add support for [http://www.postgresql.org/ PostgreSQL] (aka Postgres).

== Details ==

Development of Geeklog started back in 2000 when most of today's database abstraction layers didn't even exist yet. It therefore uses its own (thin) abstraction layer and will have to continue to do so for the forseeable future.

The idea is simple: Create a database abstraction layer for PostgreSQL for Geeklog. In theory, that would "only" require the implementation of one class in one file: <tt>system/databases/postgres.class.php</tt> (alongside <tt>mysql.class.php</tt> and <tt>mssql.class.php</tt>).

Due to Geeklog's thin database abstraction layer, some non-standard SQL has crept into the codebase here and there. The MS SQL implementation works around this by patching some of those requests at runtime. While our goal is to use standard-compliant SQL as much as possible it may not always be possible to change this for reasons of backward compatibility. Also, not all the code is under our control, e.g. in plugins.

In addition to the actual database class, there are also database-specific files to initialize and upgrade the database and the plugins. They usually include the SQL requests to be executed as well as, in case of upgrade files, some PHP code. Equivalents of these files for Postgres will also have to be implemented (obviously, we would not need upgrade files for older Geeklog versions).

== Level of Difficulty ==

''medium to high''

Students interested in this project should be ''very'' familiar with Postgres to be able to work around the restrictions outlined above.

== Further Reading ==

* [http://www.postgresql.org/ PostgreSQL homepage]
* [http://www.geeklog.net/article.php/20060918173353100 Announcement] of the MS SQL support

[[Category:Summer of Code]] [[Category:Development]]

← Older revision		Revision as of 16:05, 21 May 2009
Line 1:		Line 1:
	This is one of the projects to be implemented during the [[Google Summer of Code]] 2009.		This is one of the projects to be implemented during the [[Google Summer of Code]] 2009.

−	'''Student:''' Stan Palatnik, '''Mentor:''' Vincent Furia	+	'''Student:''' Stan Palatnik, '''Mentor:''' Vincent Furia<br/>
		+	[http://project.geeklog.net/cgi-bin/hgwebdir.cgi/gsoc-2009-spalatnik/ Project repository]

@@ Line 1: / Line 1: @@
-<center>(This is an idea page for the [[Google Summer of Code]])</center>
+This is one of the projects to be implemented during the [[Google Summer of Code]] 2009.
 == Project info and advancement during Summer of Code ==
@@ Line 30: / Line 33: @@
 Students interested in this project should be ''very'' familiar with Postgres to be able to work around the restrictions outlined above.
 === Further Reading ===

@@ Line 1: / Line 1: @@
 <center>(This is an idea page for the [[Google Summer of Code]])</center>
-=== Project info and advancement during Summer of Code ===
+== Project info and advancement during Summer of Code ==
 (to be written)
-=== Pre-Summer of Code idea discussion & preparation ===
+== Pre-Summer of Code idea discussion & preparation ==
-== Incentive ==
+=== Incentive ===
 Geeklog currently supports MySQL and MS SQL Server for the database. Recently, we have had an increasing amount of requests to add support for [http://www.postgresql.org/ PostgreSQL] (aka Postgres).
-== Details ==
+=== Details ===
 Development of Geeklog started back in 2000 when most of today's database abstraction layers didn't even exist yet. It therefore uses its own (thin) abstraction layer and will have to continue to do so for the foreseeable future.
@@ Line 24: / Line 24: @@
-== Level of Difficulty ==
+=== Level of Difficulty ===
 ''medium to high''
@@ Line 32: / Line 32: @@
 '''Mentor:''' Vinny Furia
-== Further Reading ==
+=== Further Reading ===
 * [http://www.postgresql.org/ PostgreSQL homepage]

@@ Line 1: / Line 1: @@
 <center>(This is an idea page for the [[Google Summer of Code]])</center>
-=== Project info and advancement during Summer of Code ==
+=== Project info and advancement during Summer of Code ===
 (to be written)
@@ Line 7: / Line 7: @@
 === Pre-Summer of Code idea discussion & preparation ===
 == Incentive ==

← Older revision		Revision as of 14:58, 9 May 2009
Line 1:		Line 1:
	<center>(This is an idea page for the [[Google Summer of Code]])</center>		<center>(This is an idea page for the [[Google Summer of Code]])</center>
		+
		+	=== Project info and advancement during Summer of Code ==
		+
		+	(to be written)
		+
		+
		+	=== Pre-Summer of Code idea discussion & preparation ===
		+

	== Incentive ==		== Incentive ==

← Older revision		Revision as of 19:04, 18 March 2009
Line 23:		Line 23:
	Students interested in this project should be ''very'' familiar with Postgres to be able to work around the restrictions outlined above.		Students interested in this project should be ''very'' familiar with Postgres to be able to work around the restrictions outlined above.

		+	'''Mentor:''' Vinny Furia

	== Further Reading ==		== Further Reading ==

@@ Line 8: / Line 8: @@
 == Details ==
-Development of Geeklog started back in 2000 when most of today's database abstraction layers didn't even exist yet. It therefore uses its own (thin) abstraction layer and will have to continue to do so for the forseeable future.
+Development of Geeklog started back in 2000 when most of today's database abstraction layers didn't even exist yet. It therefore uses its own (thin) abstraction layer and will have to continue to do so for the foreseeable future.
 The idea is simple: Create a database abstraction layer for PostgreSQL for Geeklog. In theory, that would "only" require the implementation of one class in one file: <tt>system/databases/postgres.class.php</tt> (alongside <tt>mysql.class.php</tt> and <tt>mssql.class.php</tt>).