php-general Digest 8 Sep 2012 01:58:43 -0000 Issue 7954
Topics (messages 319002 through 319010):
Re: use JSON storage on RAMdisk instead of SQL? (for fast moving sites)
319002 by: rene7705
319004 by: rene7705
319008 by: Matijn Woudt
319009 by: Bastien Koert
Pre-populating of a form with known info from database
319003 by: Girish Talluru
319006 by: Ashley Sheridan
xmlrpc encoding problem
319005 by: Cefull Lo
319007 by: HallMarc Websites
The end of "mysql"
319010 by: Jim Giner
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
On Thu, Sep 6, 2012 at 12:47 PM, rene7705 <rene7...@gmail.com> wrote:
> create RAMdisks for free of up to 500gb, and, more important, can on a
sorry!! make that "for free of up to 4gb"
--- End Message ---
--- Begin Message ---
and
memory : {
users : [ /* userID, userID, ... */],
forums : [ /* forumID, forumID, ... */ ],
threads : [ /* threadID, threadID, ... */],
messages : [ /* messageID, messageID, ... */],
},
should read;
memory : {
users : { /* userID:{...}, userID:{...}, ... */ },
forums : { /* forumID:{...}, forumID:{...}, ... */ },
threads : { /* threadID:{...}, threadID:{...}, ... */ },
messages : { /* messageID:{...}, messageID:{...}, ... */ },
},
--- End Message ---
--- Begin Message ---
Op 6 sep. 2012 12:48 schreef "rene7705" <rene7...@gmail.com> het volgende:
>
> Hi Folks..
<snip>
>
> I seem to have figured most of this out, but before I embark on weeks
> of coding, I'd like to give the SQL experts here a chance to convince
> me to stick to MySQL for my data storage and distribution needs. I'd
> love to hear of a simple way to efficiently store and operate a forum
> with tree-structures for both subforums and threads->messages using
> MySQL, as my live hoster does not support RAMdisks, not without
> charging me about 70 euro per month instead of the $7 I pay now ;)
>
> Ok, thanks for reading and possibly considering all this,
> Rene
>
Hi Rene,
I don't call myself an sql expert, but well.. sql is great, but not the
most efficient. There are more people like you that thought about storing
data in json. This has proven to be faster in most situations, that's why
popular platforms like facebook and Twitter don't use sql anymore. Have a
look at MongoDB for example, it uses bson,binary json. That seems to do
exactly what you want and you don't have to reinvent the wheel. You can
choose to store it's data files on ramdisk to make it even faster, but
mongodb has a pretty good cache.
- Matijn
--- End Message ---
--- Begin Message ---
On Thu, Sep 6, 2012 at 2:28 PM, Matijn Woudt <tijn...@gmail.com> wrote:
> Op 6 sep. 2012 12:48 schreef "rene7705" <rene7...@gmail.com> het volgende:
>>
>> Hi Folks..
> <snip>
>>
>> I seem to have figured most of this out, but before I embark on weeks
>> of coding, I'd like to give the SQL experts here a chance to convince
>> me to stick to MySQL for my data storage and distribution needs. I'd
>> love to hear of a simple way to efficiently store and operate a forum
>> with tree-structures for both subforums and threads->messages using
>> MySQL, as my live hoster does not support RAMdisks, not without
>> charging me about 70 euro per month instead of the $7 I pay now ;)
>>
>> Ok, thanks for reading and possibly considering all this,
>> Rene
>>
>
> Hi Rene,
>
> I don't call myself an sql expert, but well.. sql is great, but not the
> most efficient. There are more people like you that thought about storing
> data in json. This has proven to be faster in most situations, that's why
> popular platforms like facebook and Twitter don't use sql anymore. Have a
> look at MongoDB for example, it uses bson,binary json. That seems to do
> exactly what you want and you don't have to reinvent the wheel. You can
> choose to store it's data files on ramdisk to make it even faster, but
> mongodb has a pretty good cache.
>
> - Matijn
+1 for mongo...
If you want to go crazy I would suggest looking at
http://meteor.com or derbyjs.com to build the app. They run on node
and manage the real time changes to the dom content between systems
--
Bastien
Cat, the other other white meat
--- End Message ---
--- Begin Message ---
Hi All,
I have a form using aspx whenever user access the page based on the
pre-known information of the user i need to prefill certain fields from the
batabase but the challenge is i can't use the asp or touch any existing
code.
Any suggestions.
Thanks,
Girish Talluru
--- End Message ---
--- Begin Message ---
Girish Talluru <girish.dev1...@gmail.com> wrote:
>Hi All,
>
>I have a form using aspx whenever user access the page based on the
>pre-known information of the user i need to prefill certain fields from
>the
>batabase but the challenge is i can't use the asp or touch any existing
>code.
>
>Any suggestions.
>
>Thanks,
>
>Girish Talluru
Firstly, what does this have to do with PHP?
To do this at all you will need some element of code on the server to retrieve
the right information and output it in some way. If you can't edit existing
code, you will have to do some sort of ajax request to get this info.
--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
--- End Message ---
--- Begin Message ---
Hi,
here's my code
<?php
*$server = xmlrpc_server_create();*
*xmlrpc_server_register_method($server, "showLog", "showLog_func");*
*xmlrpc_server_register_method($server, "showMaxLogId",
"showMaxLogId_func");*
*$request_xml = file_get_contents("php://input");*
*$response = xmlrpc_server_call_method($server, $request_xml, null);*
*print $response;*
*xmlrpc_server_destroy($server);*
?>
All the response given from the server has the header
<?xml version="1.0" encoding="iso-8859-1"?>
Is there anyway to change the encoding to utf-8?
Thanks
--- End Message ---
--- Begin Message ---
> <?php
> *$server = xmlrpc_server_create();*
> *xmlrpc_server_register_method($server, "showLog", "showLog_func");*
> *xmlrpc_server_register_method($server, "showMaxLogId",
> "showMaxLogId_func");*
> *$request_xml = file_get_contents("php://input");*
> *$response = xmlrpc_server_call_method($server, $request_xml, null);*
> *print $response;*
> *xmlrpc_server_destroy($server);*
> ?>
>
> All the response given from the server has the header <?xml version="1.0"
> encoding="iso-8859-1"?>
>
> Is there anyway to change the encoding to utf-8?
>
> Thanks
[>]
Have you tried $xmlrpc_defencoding = "UTF8"; ?
Marc Hall
HallMarc Websites
--- End Message ---
--- Begin Message ---
So with the announced end of the mysql functions (and switching to a
different extension), one would think that my isp/hoster would be a bit
more interested in my dilemma. I tried today to create my first
mysqli-based test script and found that I didn't have that extension. A
series of emails with my tech support told me that the shared server
farm does not get "mysqli" - only their business servers. Since I dont'
have a need for and want to pay more for a 'business server', I'm told
I'm s... outta luck.
Any idea on the approximate date when mysql truly goes away - ie, when
is the proposed (next) update that will completely refuse to recognize
it? Might be ammunition for me.
--- End Message ---
