[PHP-DB] Re: Online PHP-Mysql Meeting
Hi All, As we are discussing about how to roll out this meeting from past 3-4 days Taygun ALBAN has raised an important point about the meeting (Thanks Taygun for pointing out this). As we all know we don't live in the same country, so their will be some difference between each one's time zone. Taygun has pointed out that we all are from different time zone so how we are going to roll out this meeting? Guys please pitch in and think about this issue. We will have to come with some solution so that all of us can attend this meeting. Also, I think now its time to decide a date for the meeting. Please suggest a date as well. Best, Guru.
Re: [PHP-DB] Re: Online PHP-Mysql Meeting
Due to time zone differences, people in various zones (countries/continents) can only avail of a live event within a certain time period. A recorded presentation can be viewed by anyone anytime anywhere. No time zone constraints. Obviously, whoever is taking on the role of tutor in a live event has their own time restrictions/schedule, so I think if this is is going to be a live event, see who is available/able to take on the role of tutor in various zones so everyone else knows which live event best suits their own schedule if they want to attend/tune in. Then decide/debate on the best available format for the event and any associated QA. Richard - Original Message - From: nagendra prasad nagendra802...@gmail.com To: PHP DB php-db@lists.php.net; phpexpe...@yahoogroups.com Sent: Thursday, March 18, 2010 10:46 AM Subject: [PHP-DB] Re: Online PHP-Mysql Meeting Hi All, As we are discussing about how to roll out this meeting from past 3-4 days Taygun ALBAN has raised an important point about the meeting (Thanks Taygun for pointing out this). As we all know we don't live in the same country, so their will be some difference between each one's time zone. Taygun has pointed out that we all are from different time zone so how we are going to roll out this meeting? Guys please pitch in and think about this issue. We will have to come with some solution so that all of us can attend this meeting. Also, I think now its time to decide a date for the meeting. Please suggest a date as well. Best, Guru. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Online PHP-Mysql Meeting
Guys i think u can use either Google wave or EtherPad for this purpose. Chaitanya A man can get discouraged many times but he is not a failure until he stops trying... I would love to change the world, but I can't get the source code. On Thu, Mar 18, 2010 at 4:16 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, As we are discussing about how to roll out this meeting from past 3-4 days Taygun ALBAN has raised an important point about the meeting (Thanks Taygun for pointing out this). As we all know we don't live in the same country, so their will be some difference between each one's time zone. Taygun has pointed out that we all are from different time zone so how we are going to roll out this meeting? Guys please pitch in and think about this issue. We will have to come with some solution so that all of us can attend this meeting. Also, I think now its time to decide a date for the meeting. Please suggest a date as well. Best, Guru.
[PHP-DB] Re: help needed.
Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/ http://www.indigostar.com/microweb.php PHP EXE Compiler/Embedder : http://www.bambalam.se/bamcompile/ p.s.: Make sure you encode your PHP codes before distributing... Vinay Kannan wrote: Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install PHP, APACHE, MySQL, can something like this be done, i am sure it can be done, but how do I do it, any guidelines please? Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Online PHP-Mysql Meeting
I think we should either consider audio or video Audio would make it impossible for the hearing impaired :-( -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Online PHP-Mysql Meeting
Well if it could be subtitled in any way, that would solve the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think we should either consider audio or video Audio would make it impossible for the hearing impaired :-( -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Building indexes
Chris, I just assumed that everyone on this list was using MySQL... That's what we're using (v. 5.1.45 GA) with InnoDB as the engine. (I just read your tutorial at http://www.designmagick.com/article/16/ It was very helpful - I look forward to checking out more of your articles.) If it is just as efficient to use multiple separate indexes, that would make index building less complicated on our large db. Without a large dataset, it hard to truly test a system and if you have a large dataset, like we do, it takes quite a while to build indexes. Our project is a petition signature validation suite. Since many of the handwritten names and addresses on petition sheets are difficult to read, the user needs to be able to do some fuzzy searching. Sometimes it's easier to read the address than it is the name. The zip code is usually easy to read. We almost always need to use LIKE queries, since some part of the name or address is typically hard to read. (We try to use as many of the leading characters as we can and wildcard the remaining.) For this part of the project joins are not needed. We could eliminate most of the 55 columns, which would reduce the size of the db, but I don't know what that would do to speed... Does any of this affect the approach you would suggest? Thanks!! - Ron On 3/17/2010 11:56 PM, Chris wrote: listread wrote: Greetings! We are working on a 4 million record db with about 55 fields. We need to build indexes to speed queries, but it seems to take way too long. I'm assuming your using mysql but that's just a guess. What database? (mysql, oracle, postgres, firebird, sqlite, other) If it's mysql, what db engine? Here are some questions: 1) If a query uses two or three fields is it best to prepare an index with those two or three fields, or will the query be just as efficient if we build three separate index, one for each field? Relates to above, but assuming mysql then it depends on what version. multicolumn indexes work well in all mysql versions. separate indexes can be used and combined in newer versions (v5 I think it came in). 2) Is the index building process any slower, per index, if you are building more than one index at a time? Most indexing I think takes an exclusive lock on the table, so index 1 gets created, index 2 has to wait it's turn until index 1 finishes. I wrote an article on this a while ago, might give you some more insights: http://www.designmagick.com/article/16/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Online PHP-Mysql Meeting
http://www.youtube.com/watch?v=y2c_S_90Syc /sob it took me 2 hours to build this decent tutorial please have look on my work *that's include the subtitle (english) I don't do dubbing.. sry On Thu, Mar 18, 2010 at 9:23 PM, Richard Dunne richarddunne1...@o2.iewrote: Well if it could be subtitled in any way, that would solve the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think we should either consider audio or video Audio would make it impossible for the hearing impaired :-( -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
Re: [PHP-DB] Re: help needed.
flash? why not using xml.. is the data will be update? this good aplication i think On Thu, Mar 18, 2010 at 4:10 PM, Nadim Attari na...@alienworkers.comwrote: Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/ http://www.indigostar.com/microweb.php PHP EXE Compiler/Embedder : http://www.bambalam.se/bamcompile/ p.s.: Make sure you encode your PHP codes before distributing... Vinay Kannan wrote: Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install PHP, APACHE, MySQL, can something like this be done, i am sure it can be done, but how do I do it, any guidelines please? Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
Re: [PHP-DB] Online PHP-Mysql Meeting
i found this interesting movie well actualy is nice.. but you can't see the tutorial because it soo Small http://www.youtube.com/watch?v=ejVYBBREcLw hope this can help .. somehow On Thu, Mar 18, 2010 at 11:08 PM, Gunawan Wibisono landavi...@gmail.comwrote: http://www.youtube.com/watch?v=y2c_S_90Syc /sob it took me 2 hours to build this decent tutorial please have look on my work *that's include the subtitle (english) I don't do dubbing.. sry On Thu, Mar 18, 2010 at 9:23 PM, Richard Dunne richarddunne1...@o2.iewrote: Well if it could be subtitled in any way, that would solve the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think we should either consider audio or video Audio would make it impossible for the hearing impaired :-( -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ.. -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
Re: [PHP-DB] Re: help needed.
Yes, the data would be updated, I am not really good at XML, havnt had a chance to work with XML, so was trying to avoid it as much as I can, but I guess if it thats what it takes, then would have to sit down and start working on it now :) On Thu, Mar 18, 2010 at 8:11 AM, Gunawan Wibisono landavi...@gmail.comwrote: flash? why not using xml.. is the data will be update? this good aplication i think On Thu, Mar 18, 2010 at 4:10 PM, Nadim Attari na...@alienworkers.com wrote: Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/ http://www.indigostar.com/microweb.php PHP EXE Compiler/Embedder : http://www.bambalam.se/bamcompile/ p.s.: Make sure you encode your PHP codes before distributing... Vinay Kannan wrote: Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install PHP, APACHE, MySQL, can something like this be done, i am sure it can be done, but how do I do it, any guidelines please? Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
Re: [PHP-DB] Online PHP-Mysql Meeting
This is vary nice Gunawan :) I will post my example movie tonight and see if this works. I am going to make a live working movie which will show the user as if he is sitting just next to me. I will also try to put some subtitles in it. Just thinking if anyone know a tool which can convert MP3 to text so that I can record the audio in MP3 and then I can get the whole audio into text. This would be easier for everyone while making an audio-video movie with subtitles. Just for making everyone's life easier here are few tool which we can use it while making movie clips: 1. Any screen capturing tool (Snagit will do) 2. Any Movie editing tool (Generally Window movie maker but I recommend Ulead Video studio) 3. Any video compressor tool which will reduse the size of the movie so that it would be easier to upload it. ( su...@2000 will do) Best, Guru.
Re: [PHP-DB] Building indexes
listread wrote: Chris, I just assumed that everyone on this list was using MySQL... That's what we're using (v. 5.1.45 GA) with InnoDB as the engine. Most people are but there are lots of types of databases out there :) (I just read your tutorial at http://www.designmagick.com/article/16/ It was very helpful - I look forward to checking out more of your articles.) If it is just as efficient to use multiple separate indexes, that would make index building less complicated on our large db. It is, though wildcard searches can't always use indexes. If you do field like 'abcdef%'; then an index can potentially be used because the db (mysql or otherwise) can look at the start of the string to see if it matches. The longer the string the more likely an index can be used (eg doing field like 'a%' probably won't use an index, it'll end up being quicker to scan the actual data). If you do field like '%abcdef%'; then an index can't be used since abcdef could appear anywhere in the string. Without a large dataset, it hard to truly test a system and if you have a large dataset, like we do, it takes quite a while to build indexes. Definitely, it's the best way to test and also the hardest since rebuilding the db takes so long. Our project is a petition signature validation suite. Since many of the handwritten names and addresses on petition sheets are difficult to read, the user needs to be able to do some fuzzy searching. Sometimes it's easier to read the address than it is the name. The zip code is usually easy to read. We almost always need to use LIKE queries, since some part of the name or address is typically hard to read. (We try to use as many of the leading characters as we can and wildcard the remaining.) I'd suggest fulltext but that won't work with innodb, only myisam. You could do something like keep the addresses and names in a separate myisam table just for searching, though that means a whole new import process and also means you'd end up having to do two queries (maybe a subquery or join, you'd have to test) - one do to full text search and one to get the rest of the data based on the result of the first. What do your queries end up looking like? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Online PHP-Mysql Meeting
for studi purpose.. i suggest to use subtitle.. but in my youtube.. use Caption (soft-sub) i think we should create simple.. http://www.youtube.com/watch?v=y2c_S_90Syc using close caption http://www.youtube.com/watch?v=ZrRU1k4f_zM using annotation beside.. in this youtube.. we can pause it to read i recomended create max for movie in 640x480.. no more? about the music.. sry i put strange bg music On Thu, Mar 18, 2010 at 11:52 PM, nagendra prasad nagendra802...@gmail.comwrote: This is vary nice Gunawan :) I will post my example movie tonight and see if this works. I am going to make a live working movie which will show the user as if he is sitting just next to me. I will also try to put some subtitles in it. Just thinking if anyone know a tool which can convert MP3 to text so that I can record the audio in MP3 and then I can get the whole audio into text. This would be easier for everyone while making an audio-video movie with subtitles. Just for making everyone's life easier here are few tool which we can use it while making movie clips: 1. Any screen capturing tool (Snagit will do) 2. Any Movie editing tool (Generally Window movie maker but I recommend Ulead Video studio) 3. Any video compressor tool which will reduse the size of the movie so that it would be easier to upload it. ( su...@2000 will do) Best, Guru. -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
