Thursday, April 05, 2007

REAL SQL Server Session

In May, during the MacWorld I'll present a session about the REAL SQL Server.
I am interested in hearing from you suggestions and advices about special topics or arguments that can I expand during my session.

posted by Marco Bambini at 5:31 PM  

Del.icio.us | Digg it | Furl | ma.gnolia | Spurl | Yahoo MyWeb

6 Comments:

  • How about running server side external RB apps/scripts from a REALSQL db client.

    By Gerard Hammond, at 2:26 AM  

  • How to build an unttended REAL SQL server installer?

    How to register the REAL SQL server from a connected REALSQL client?

    Using Data-On-Demand with REAL SQL server.

    Client side Performance tips! What tunnable parameteres are there. Can we build in (bake in) pre parsed SQL into our apps.

    Server side Index tricks and tips. Index creation tips.

    I have lots more. Want them??? ;-)

    I can't wait for this session. Please make it an advanced session not a bginners session.

    By Gerard Hammond, at 2:33 AM  

  • Thanks a lot for you requestes Gerard... I'll probably make an intermediate/advanced session but I am not 100% sure about this point.

    If you have more requestes please don't hesitate to post all of the them!

    By Marco Bambini, at 9:12 AM  

  • ok, some more....

    a) Please explain FTS1 and FTS2.
    b) what is planned for the Next version, eg features
    c) Why isn't there a builtin RENAME COLUMN command ;-)
    d) Why are boolean columns so unreliable/inconsistent...
    e) Using PHP with REALSQL - example scripts to download
    f) How to send a message between clients via the server? (postgreSQL has something like this)
    g) Can a message be broadcast from the server to any or all clients (eg 'please logoff now')
    h) Performance Tips, tips, tips....

    i) Inserting user entered dates - what is the best, most safe way.
    j) tips for threaded queries - are threaded queries possible?
    k) How to reset the server when it has broken connections with disconnected clients (it never releases them....

    ok, some of these are feature requests, but maybe you can consider them before i get to Austin as I'll repeat them there ;-)

    oh one last one.

    An example of a client INSERTing 10,000 SQL tupples so that the server still stays responsive to other clients logged on at the same time.

    And vice versa, 10 users downloading these 10,000 rows at the same time. How to make te server stay fast and responsive to user 11 who logs in ;-)

    By Gerard Hammond, at 5:55 AM  

  • One more item for your talk...

    What are "Custom commands" from the evaulation of BugID

    http://www.realsoftware.com/feedback/viewreport.php?reportid=zmmyzqze

    I think I know, but I'd like
    a) confirmation
    b) a list of them

    By Gerard Hammond, at 4:09 AM  

  • It isn't a bug Gerard, because you can't send multiple "custom commands" in the same line.

    To show all supported "custom commands" just send this query to the server:
    rs = db.SQLSelect("SHOW COMMANDS")

    By Marco Bambini, at 8:22 AM  

Post a Comment

<< Home