[Phpmyadmin-devel] [ Exporting Relations Schema] Project
Hi, First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010> I expect to get the feedback about my proposal from the Community :) Thanks! I will write weekly status reports at my blog and will regularly tweet my progress. My twitter: @hiddenpearls Regards Muhammad Adnan -- Failure takes you higher than success ..!
Hi Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010>
Welcome and looking forward to cooperation with you. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010>
Your website seems to be down all the day and returns just "Default Website Page"... -- Michal Čihař | http://cihar.com | http://blog.cihar.com
On Thu, May 6, 2010 at 4:27 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. < http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
Your website seems to be down all the day and returns just "Default Website Page"...
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ? It is paid hosting :( -- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Hi Dne Thu, 6 May 2010 16:31:10 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-). -- Michal Čihař | http://cihar.com | http://blog.cihar.com
On Thu, May 6, 2010 at 4:44 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Thu, 6 May 2010 16:31:10 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
pretty strange ,, can u please send me screen shot ? also which hosting you are using for your blog ? or you think is better hosting provider ? -- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
pretty strange ,, can u please send me screen shot ?
Okay, looking a bit deeper into the problem and the issue is DNS of your hosting. They have two DNS servers: imblog.info. 86400 IN NS ns1.puzzlehosting.com. imblog.info. 86400 IN NS ns2.puzzlehosting.com. But each of them returns different address: $ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53 www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153 $ nslookup www.imblog.info ns1.puzzlehosting.com Server: ns1.puzzlehosting.com Address: 208.116.16.18#53 www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.158 The 195.191.24.153 works fine, while 195.191.24.158 does not. Screenshot is here: http://tmp.cihar.com/imblog.info.png
also which hosting you are using for your blog ? or you think is better hosting provider ?
I have own server what is probably not a solution for you. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
pretty strange ,, can u please send me screen shot ?
Okay, looking a bit deeper into the problem and the issue is DNS of your hosting.
They have two DNS servers:
imblog.info. 86400 IN NS ns1.puzzlehosting.com. imblog.info. 86400 IN NS ns2.puzzlehosting.com.
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
$ nslookup www.imblog.info ns1.puzzlehosting.com Server: ns1.puzzlehosting.com Address: 208.116.16.18#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.158
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158. -- Marc Delisle http://infomarc.info
Dne Thu, 06 May 2010 10:43:27 -0400 Marc Delisle <marc@infomarc.info> napsal(a):
Both name servers queried from here currently return 195.191.24.158.
Same here now. What means that the web does not work... -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Michal Čihař a écrit :
Dne Thu, 06 May 2010 10:43:27 -0400 Marc Delisle <marc@infomarc.info> napsal(a):
Both name servers queried from here currently return 195.191.24.158.
Same here now. What means that the web does not work...
I confirm that http://www.imblog.info currently shows a default website page. -- Marc Delisle http://infomarc.info
2010/5/6 Marc Delisle <marc@infomarc.info>:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case. Maybe this has something to do with this : http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On... -- Greets, Dieter Adriaenssens
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle <marc@infomarc.info>:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
------------------------------------------------------------------------------ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now .. -- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
It seems some serious problems with my existing hosting. So, I bought a new one now. I will host my blog now on it in next couple of days. On Thu, May 6, 2010 at 11:03 PM, ADnan <hiddenpearls@gmail.com> wrote:
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle <marc@infomarc.info>:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
------------------------------------------------------------------------------ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now ..
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ? We should give this exporting feature under the operations tab ? or a separate tab ? On Mon, May 10, 2010 at 12:55 PM, ADnan <hiddenpearls@gmail.com> wrote:
It seems some serious problems with my existing hosting. So, I bought a new one now. I will host my blog now on it in next couple of days.
On Thu, May 6, 2010 at 11:03 PM, ADnan <hiddenpearls@gmail.com> wrote:
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle <marc@infomarc.info>:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
------------------------------------------------------------------------------ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now ..
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface). -- Michal Čihař | http://cihar.com | http://blog.cihar.com
hi, first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended On Mon, May 24, 2010 at 8:03 PM, Michal Čihař <michal@cihar.com> wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
My status report for 2nd week ! http://www.imblog.info/google-summer-of-code-2010-2nd-week On Fri, May 28, 2010 at 11:06 PM, ADnan <hiddenpearls@gmail.com> wrote:
hi,
first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended
On Mon, May 24, 2010 at 8:03 PM, Michal Čihař <michal@cihar.com> wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
hi Cihar, 1. I am thinking to code a config class in which I define all the Global vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ? Class name will be PMA_SCHEMA_config .. 2. I noticed in PDF Relation Export classes .. There is a function name PMA_RT_DOC should be renamed to PMA_RT_dataDictionary On Sat, Jun 5, 2010 at 6:04 AM, ADnan <hiddenpearls@gmail.com> wrote:
My status report for 2nd week ! http://www.imblog.info/google-summer-of-code-2010-2nd-week
On Fri, May 28, 2010 at 11:06 PM, ADnan <hiddenpearls@gmail.com> wrote:
hi,
first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended
On Mon, May 24, 2010 at 8:03 PM, Michal Čihař <michal@cihar.com> wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Hi Dne Tue, 22 Jun 2010 17:55:11 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
1. I am thinking to code a config class in which I define all the Global vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ?
Class name will be PMA_SCHEMA_config ..
Why you need separate class for configuration? Shouldn't that be part of either PMA_Config (if it is some global settings) or PMA_Schema (if it is schema specific). You don't need any global variables for both, just use method attributes for this. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
hi, I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding .. Experts & Mentors, Please suggest what should I do ?? though, I am going to digg more in that issue to see any solution for this ... On Tue, Jun 22, 2010 at 7:09 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Tue, 22 Jun 2010 17:55:11 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
1. I am thinking to code a config class in which I define all the Global vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ?
Class name will be PMA_SCHEMA_config ..
Why you need separate class for configuration? Shouldn't that be part of either PMA_Config (if it is some global settings) or PMA_Schema (if it is schema specific).
You don't need any global variables for both, just use method attributes for this.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
Experts & Mentors, Please suggest what should I do ??
though, I am going to digg more in that issue to see any solution for this ...
-- Marc Delisle http://infomarc.info
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Experts & Mentors, Please suggest what should I do ??
though, I am going to digg more in that issue to see any solution for this ...
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it). -- Piotr Przybylski
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski <piotr.prz@gmail.com>wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info>
wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :( --
Piotr Przybylski
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
Sorry, I will explain more clearly. If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter. It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available. -- Piotr Przybylski
On Wed, Jun 23, 2010 at 12:33 AM, Piotr Przybylski <piotr.prz@gmail.com>wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why
generating
in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
Sorry, I will explain more clearly.
If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter.
It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available.
How I can change/restore connection parameters ??
-- Piotr Przybylski
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Wed, Jun 23, 2010 at 12:33 AM, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2010/6/22 ADnan <hiddenpearls@gmail.com>:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit : > hi, > > I am working with XMLWriter Extension for generating XML Documents > for > SVG,DIA,VISIO formats for generating schema .. but I noticed in > XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
Sorry, I will explain more clearly.
If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter.
It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available.
How I can change/restore connection parameters ??
Ok... sorry for giving you incorrect information. I looked at phpMyAdmin's code and saw how it is handled. As far I I understand code in PMA_DBI_postConnect(), your data is guaranteed to come in UTF-8 encoding. So you don't have to worry about anything, XMLWriter is safe to use. As for connection parameters, you can look ar MySQL's documentation [1] in your free time, as there is no need to change anything. Sorry for confusing you. [1] http://dev.mysql.com/doc/refman/5.0/en/charset.html -- Piotr Przybylski
Hi Dne Tue, 22 Jun 2010 23:58:18 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
All translations in phpMyAdmin are UTF-8 as well as all data you get from MySQL inside phpMyAdmin are in UTF-8, so you really don't have to care about this. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
hi, I am trying to look at the ways that how different export schema's should output the schema. It should be sent the output to Browsers or force downloaded to users ? *PDF *Schema file should inline or download ? *possiblity:* it can be inline and download but inline is again an issue, we need to clean the headers *SVG *Schema file should inline or download ? *possiblity:* it can be inline and download but for showing it inline, we need to make frames to output the svg image *DIA *Schema file should inline or download ? *possiblity:* it can be just download Regards On Wed, Jun 23, 2010 at 9:03 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Tue, 22 Jun 2010 23:58:18 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle <marc@infomarc.info> wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
All translations in phpMyAdmin are UTF-8 as well as all data you get from MySQL inside phpMyAdmin are in UTF-8, so you really don't have to care about this.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Hi Dne Sun, 11 Jul 2010 17:51:34 +0500 Adnan <hiddenpearls@gmail.com> napsal(a):
I am trying to look at the ways that how different export schema's should output the schema. It should be sent the output to Browsers or force downloaded to users ?
*PDF *Schema file should inline or download ? *possiblity:* it can be inline and download but inline is again an issue, we need to clean the headers
I'd prefer download, but I anyway don't use plugins to be able to display PDF inline.
*SVG *Schema file should inline or download ? *possiblity:* it can be inline and download but for showing it inline, we need to make frames to output the svg image
Again, I'd prefer download, mostly because of frames.
*DIA *Schema file should inline or download ? *possiblity:* it can be just download
Definitely download here, AFAIK there is no plugin for browser for this format. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Michal Čihař a écrit :
Hi
Dne Thu, 6 May 2010 16:31:10 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-).
Michal, I see the content. Could there be some caching issue on your side. -- Marc Delisle http://infomarc.info
2010/5/6 Michal Čihař <michal@cihar.com>:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010>
Your website seems to be down all the day and returns just "Default Website Page"...
When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Groetjes, Dieter Adriaenssens
On Thu, May 6, 2010 at 5:31 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Michal Čihař <michal@cihar.com>:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan <hiddenpearls@gmail.com> napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. < http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
Your website seems to be down all the day and returns just "Default Website Page"...
When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Groetjes,
Dieter Adriaenssens
------------------------------------------------------------------------------ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
I just clicked on link again and it worked . here it is .. http://www.imblog.info/export-relations-schema-project-google-summer-of-code... -- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
ADnan a écrit :
On Thu, May 6, 2010 at 5:31 PM, Dieter Adriaenssens <dieter.adriaenssens@gmail.com <mailto:dieter.adriaenssens@gmail.com>> wrote:
2010/5/6 Michal Čihař <michal@cihar.com <mailto:michal@cihar.com>>: > Hi > > Dne Thu, 29 Apr 2010 00:38:15 +0500 > ADnan <hiddenpearls@gmail.com <mailto:hiddenpearls@gmail.com>> napsal(a): > >> First of all, thanks for accepting my proposal. I am very delighted that I >> got a chance to take part in Great Google Summer of Code Program and >> phpMyAdmin was my favorite choice. I posted my proposal to my blog. >> <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010> > > Your website seems to be down all the day and returns just "Default > Website Page"...
When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.
I just clicked on link again and it worked . here it is .. http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
It works for me right now, with shift/reload. -- Marc Delisle http://infomarc.info
participants (6)
-
ADnan -
Adnan
-
Dieter Adriaenssens -
Marc Delisle -
Michal Čihař -
Piotr Przybylski