This evening I rewrote the first class (database connection and query handling) to use postgreSQL. It seems to work fine….
$this->conn = pg_connect(
"host='" . $this->tcmshost .
"' port='" . $this->tcmsport .
"' dbname= '" . $this->tcmsdb .
"' user= '" . $this->tcmsuser .
"' password= '" . $this->tcmspwd ."' ");
The next step will be to change the login code, menu code (I love to see how pg will parse my treebuilder with only one query) etc…
Zat net met iemand op irc te praten die allerlei links online gooide met een zoektocht op google waarbij er een subdir is aangesproken (squared).
Zo op het eerste gezicht lijkt het een soort BI achtige omgeving waarbij je vragen kunt stellen op een menselijke manier. Het geeft een overzicht van soorten kaas, maar ook over mensen die ergens wonen of naar toe verhuizen (verzin zelf gewoon een vraag).
Nu wist de persoon dat ik vanuit Nederland naar Duitsland was vertrokken dus vroeg hij de volgende link aan:
Wat staat er nu bij de antwoorden op de eerste plek? Anne Frank, jawel, het Joodse meisje uit het welbekende verhaal.
Nu is mijn kennis niet helemaal op en top maar volgens mij is een deportatie iets anders dan een verhuizing. Overigens, bij mij was het wel een verhuizing.
Heb nog niet echt kunnen kijken of het echt wat is maar er lijken nu toch langzaam oplossingen te komen die er voor zorgen dat media onafhankelijk van de player te zien is in een browser. Wel moet je html5 kunnen bekijken in je browser.
Yesterday I installed PostgreSQL using Fink. I could have chosen to download and install the .dmg from Enterprisedb but that one gave me some troubles (might be the machine I am using for development).
Today I started to look in converting my MySQL data to PostgreSQL. It seems there is a tool called mysql2pgsql. It converts a dump file into a format postgres can read. Once run you will have translated auto_increment fields for a primary key to sequences:
CREATE SEQUENCE “tcms_content_id_seq” START WITH 786 ;
CREATE TABLE “tcms_content” (
“id” integer DEFAULT nextval(‘”tcms_content_id_seq”‘) NOT NULL,
“content” text NOT NULL,
“page_id” int CHECK (“page_id” >= 0) NOT NULL,
primary key (“id”)
I was able to import it into PostgreSQL and using pgAdmin it shows the constraints, tables, etc..
The next time I will work on tcms I will start translating the php code to connect to PostgreSQL and see what will need to be altered.
Before the season holidays I decided to do some more development on tcms. I must say I was a bit lazy and was searching an excuse for myself to not do any development. Maybe there was a reason for it if I look back at the last couple of weeks.
On Januari the 4th I posted about Monty who seems to spam all users, even those addresses he seems to have sold to Sun. I replied on the page where he points to in his e-mail stating I think he is not entitled to those addresses. He never responded but I did catch up reading about his plans. He seems to look for a way where someone can own the database he sold to Sun for a lot of money on a dual license.
This made me decide to not select MySQL as a base development database and switch to PostgreSQL. I must be honest, it’s not the only reason. PostgreSQL has more features that I would like to use and seems to be more stable.
It might set back tcms development for a short while but I hope it will be a more robust solution without doubting over the support in the future.
Since I do a lot of business using MySQL I am subscribed to a few newsletters from mysql.com. I used to be subscribed at my home e-mail address but since I am working for a company for more then a few years now I also subscribed with my business e-mail address.
Today I received an email form helpmysql.org stating the following:
I am contacting you because you have in the past shown interest in
MySQL and from that I assume you are interested in the future
well-being of MySQL.
Now you have a unique opportunity to make a difference. By signing
the petition at http://www.helpmysql.org you can help affect the
future of MySQL as an Open Source database.
You can find more information of this on my latest blog post at:
Help us spread the world about this petition!
http://www.helpmysql.org is available in 18 languages and every vote
is important, independent of from where in the world it comes!
If you know people that are using MySQL, please contact them and
ensure they also sign the petition!
Creator of MySQL
PS: If you already have signed the petition or know about it, sorry for
reminding you about this! Because of the importance of this issue,
I am trying to contact every person that I have ever communicated
with regarding MySQL.
Although I am very thankful for the free software there are some limits in how data is supposed to be handled once someone sells his product and company to another company. Currently it looks like he is using everyone who ever subscribed to the list in the past to spam his cry for help. Is he allowed to use this data?
As far as I know the owners sold MySQL to Sun and they sold it to Oracle. I do not think he is entitled to use people who are subsribed (and not at all if it is used to send massive unsolicited email). What will he do if the users are not responding? Sell the data to another company?