, schrieb Bas Scheffers:
I think the question is *how* to grab the raw post data?
On Wednesday, April 7, 2010 4:12pm, Gustaf Neumannneum...@wu-wien.ac.at
said:
Grab the post data and use an xml parser to get the content
There are multiple xml parsers for tcl available that you can use.
I
On Saturday, October 31, 2009 10:30pm, Dave Bauer
d...@thedesignexperience.org said:
Of course you can say apt-get install aolserver4 already.
Of course you can, but then what? Then you still have this completely alien
server in front of you that you will need to configure. It puts people off.
have done that
successfully
Jim
Sent from my iPhone
On Oct 27, 2009, at 6:55 PM, Dossy Shiobara do...@panoptic.com
wrote:
On 10/27/09 5:40 PM, Bas Scheffers wrote:
Moving AOLserver to run inside Apache as a module would be a great
step to making it more accesible and popular
On Tuesday, October 27, 2009 7:55pm, Bernd Eidenschink eidensch...@web.de
said:
Even using and relying on several AOL- and Naviservers for years now I cannot
get used to the technical superiority discussions...
It is not about technical superiority. No matter how hard you try, AOLserver
will
On Tuesday, October 27, 2009 9:08am, Jeff Rogers dv...@diphi.com said:
The C-python implementation has a misfeature known as the global
interpreter lock (GIL) that presents scalability problems in a threaded
This why all of the Apache supported languages either require the pre-fork
model where
On 24/09/2009, at 10:04 PM, Dino Vliet wrote:
Question 1)
I see the need to present the users of my site with a small little
calender, when they want to input date fields in my forms. How is
this accomplished? Do I really need javascript for this, or are
there other possibilities,
As far as I am aware, the only way to do it is to implement a new socket driver
in C.
AOLserver can certainly handle this. There used to be nsftp, which did just
that.
Bas.
On Tuesday, August 18, 2009 10:26pm, Nikolay Shulga
nikolay.shu...@runway.lv said:
Hello,
Is it possible to
G'day all,
Is anyone, or does anyone know of any AOLserver and/or Tcl developers in
Auckland, New Zealand?
A national media company there is looking at re-using a site I developed many
moons ago for their purposes and would be keen to have someone based there to
consult, as I am in Adelaide.
One caching solution for Java is http://www.opensymphony.com/oscache/ which
should do the job quite nicely.
Another, of course, is to use memcached and any of the Java clients for it.
This way you could clear the cache from AOLserver also if the content changes.
Finally, a singleton with a
On Monday, March 2, 2009 8:15am, Alexey Pechnikov pechni...@mobigroup.ru
said:
I rewrite command as
...
It's work but is not stable.
Using exec is generally unstable, not sure why, but it is certainly not
recommended. I would try some other way, like ns_proxy.
If you want to make them all run as individual processes, you can use
Apache as proxy to them.
And of course Jeff is right about SSL - one per IP only unless you
choose different ports. (which you don't want to as many corporate
firewall only allow 80 and 443 traffic)
On 07/02/2009, at
Did you build Tcl with the --enable-threads flag? You must. That is
what the multiple _init message usually indicates, that Tcl was not
built with multithreading enabled.
Bas.
On 22/10/2008, at 5:10 AM, Thibault Fouache wrote:
Hi everyone !
I've got a problem during the Aol server
On 19/08/2008, at 10:14 AM, Tom Jackson wrote:
No, fastpath is making the exact same assumptions that any archive
program would make, which is to record certain attributes at the time
something is cached and then compare them with the same attributes
at a
Could the file name (just the name,
On 06/05/2008, at 11:44 AM, Tom Jackson wrote:
The main thing you need with a mashup is data. Without that, there
is nothing
to mash.
And much of that data is in XML and tdom runs rings around any Java
XML implementation, though not sure about the ones in PHP, Perl, etc
which are also
The plot thickens:
% format %.2f 18.0051
18.01
No ideas, though.
Bas.
On 04/05/2008, at 8:01 AM, William Scott Jordan wrote:
Hey all!
This is really more of a tcl question, but I'm hoping that someone
on the list might have an explanation. Why does [format %.2f
18.005] round down to
Xavier,
Inside an ADP, you could simply use ns_adp_include. If you want to do
it in a Tcl file/proc, you coud do:
ns_return 200 text/html [ns_adp_parse -file [file join [ns_info
pageroot] path/to/my_file.adp]]
Hope that helps,
Bas.
On 22/04/2008, at 6:26 PM, Xavier Bourguignon wrote:
On 20/04/2008, at 7:18 PM, Xavier Bourguignon wrote:
So Bob, what is the difference between setting the variable within the
adp and setting it in a procedure? Surely the variable set in the
procedure should be available as the procedure is called within the
adp.
It's all about scope! A variable
This is by no means the world's best test (that would be re-writing an
actual heavily loaded application), but I tried the same query as I
did in Java yesterday in libpq.
Single threaded, the results were similar, seeing a 6.2% improvement
this time. But when I started running several
Given our current conversations, I can't help not to share this:
http://thedailywtf.com/Articles/Oklahoma-Leaks-Tens-of-Thousands-of-Social-Security-Numbers,-Other-Sensitive-Data.aspx
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
I have wanted to add bind variable support to nsdb for a _long_ time,
but never got around to computing this support matrix that I describe
above.
I don't really like bind variables, I would much rather see it
implemented like:
ns_db select
On 17/04/2008, at 9:25 AM, Tom Jackson wrote:
Your script/page level code can remain unchanged even when you switch
databases.
That looks more like an OR mapping framework. I think that is a good
thing to have also but to me it is separate from having bind variables
in the core nsdb api. I
Can you show the code on how you are setting the cookie?
Setting a time using the old style netscape cookie spec is entirely
unreliable as it depends on the client's computer clock being accurate.
I don't find timed cookies very useful in any case and only ever use
no time-out (i.e.:
On 04/04/2008, at 8:44 AM, Cynthia Kiser wrote:
It never occurred to me to try parsing this with Tcl instead. Is
there an AOLserver or straight Tcl module I should be using to parse
pseudo-CSV? Or is the answer keep it simple and just read lines and
split on ¡ with 'split'?
Tcl lib has a
Some questions to help us, and maybe give you some hints as to what
might be wrong.
How did you determine the fact that the value isn't a correct Tcl
string?
What encoding is the database in? (UTF-8?) Are you 100% sure the data
in the database is actually correct?
I wouldn't think you
is that
AOLserver/Tcl has the tools to handle the issues.
tom jackson
On Wednesday 02 April 2008 15:38, Bas Scheffers wrote:
Some questions to help us, and maybe give you some hints as to what
might be wrong.
How did you determine the fact that the value isn't a correct Tcl
string?
What encoding
How are db.tcl and admin.tcl called?
The normal way of using ns_db is simply to get a handle in the page
(ADP, Tcl or registered proc) that you need it on. Not in some other
file like your db.tcl.
Bas.
On 02/04/2008, at 7:51 AM, Xavier Bourguignon wrote:
Hi all,
I have this in my
You can use nsv shared variables, which makes the variable shared by
all threads. You can initialize these values in a library Tcl file,
like init.tcl.
See: http://panoptic.com/wiki/aolserver/Thread-shared_Variables
A second (and possibly better) way is to set these values in a section
of
On 19/12/2007, at 12:59 AM, Rajesh nair wrote:
This code crashes when I do a ns_db select with SQL = “Exec stored
procedure @params”.
Crash is such a harsh word, don't you mean throws an error? I bet
the error is ... is not a statement returning rows or similar.
I can do a ns_db exec “exec
On 18/12/2007, at 1:11 AM, Andrew Piskorski wrote:
1. Vlad's nsmemcache first.
Glancing through the code, it looks like quite a good implementation
and very clean/readable. (i.e.: easy to improve upon further) My
preference would also be to have a 100% AOLserver module; the socket
API is
I don't know the ns_db sp_* functions, but you can get return values
in other ways.
First of all, there is nothing stopping you from executing a big chunk
of T-SQL in ns_db select. You could easily execute the stored proc
using exec and the trick to getting the output values is to not use
If you are serving these verbatim from the database with no other
processing, I think you should consider caching them in the file
system for much better performance.
You can do this by creating a 404 handler that checks if the requested
file could be got from the database. If it can, it
On 28/09/2007, at 9:28 AM, Dossy Shiobara wrote:
Yes! Finally, someone else who uses the 404-handler-as-request-
processor
pattern! Indeed, you can't beat static file serving performance.
And,
My first inspiration for this came way back in the last century, from
working with Vignette
On 28/09/2007, at 3:38 AM, Dossy Shiobara wrote:
I bet with just a few minutes of tweaking and tuning, we can get
between
4k-8k simple dynamic req/sec out of your hardware.
Hear, hear. I just blasted my brand-spanking-new Quad 2.6 Mac Pro
using ab. I was testing my ns_session, so it was
On 28/09/2007, at 5:04 AM, John Buckman wrote:
I've been looking at C-caching of Tcl dynamic content, with dirty
cache support. For example, replacing the Tcl code that returns a
user's uploaded photo with C code.
I wrote C code to do this, and got 14k/second vs 240/s for the same
tcl
Instead of using exec, have you tried to open a pipe (open |
javacmd) and use fconfigure on the I/O channel returned by this?
Cheers,
Bas.
On 5 Sep 2007, at 17:05, Janine Sisk wrote:
This may be more of a Tcl question than an AOLserver one, but I'm
guessing that people on this list are more
On 6 Sep 2007, at 08:17, Janine Sisk wrote:
The problem is, Tcl doesn't support utf-8s, and as far as I can
tell there is no other format that will work. This will leave me
stuck with the java program, and I have serious concerns about the
performance of any sort of exec, let alone one
On 10 Aug 2007, at 02:54, Tom Jackson wrote:
I have never been able to put my finger on what the issue is here.
AOLserver
isn't Apache. Sendmail isn't Qmail either. Both compete over a single
privileged port. That is the real issue. Some company only has one
IP address
and needs to make a
On 8 Aug 2007, at 14:08, Tom Jackson wrote:
general indications? Uhhh, I mean what is memcache, how do you use
it and why
is it useful? Otherwise, it isn't useful to me or anyone else
without a clue.
http://www.danga.com/memcached/ is brilliant. I have not used it in
AOLserver yet, though.
, Guan Yang wrote:
Bas Scheffers wrote:
http://www.danga.com/memcached/ is brilliant. I have not used it
in AOLserver yet, though. There is a Tcl only client but for best
performance you'd probably be best off creating a module using one
of the C libraries available.
When I last tried
On 7 Aug 2007, at 23:07, Dossy Shiobara wrote:
1) JavaScript: the SpiderMonkey JS engine is thread-safe and I've been
integrating it into AOLserver (see: nsjsapi). John Resig has
started
I'll have a look at that soon!
On Apache, lacking nsv's (and nv's), folks use memcache. Naturally,
On 7 Aug 2007, at 13:08, Mark Aufflick wrote:
tcl is certainly unpopular - (put's on flame retardent suit) - it
doesn't suit structured programming well like, say, ruby and python
Those languages were really only made popular by their use in a hot(-
ish) new(-ish) web stack, Tcl could achieve
Not entirely sure, but if you were willing to run the server on
Windows, you should be able to create a much simpler module than
mod_auth_kerb using the MS functions; send the right headers for IE
to return the NTLM token, check its validity using MS code and then
just get the username out
I haven't tested it yet, but a quick google found this:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1214771SiteID=1
Are you using pop-ups?
I'll look into it further soon!
Bas.
On 19 Jul 2007, at 05:25, Ian Harding wrote:
Has anyone else had trouble with this? Firefox, Safari,
ns_write is designed to be called multiple times so you can stream
content to the client. It is not designed to close the connection
after one call!
Have you tried ns_conn close?
Cheers,
Bas.
On 13/07/2007, at 9:59 AM, JAMSHED QURESHI wrote:
Hi,
Upon receiving the request i'm calling
This should do the trick:
[lindex [split [ns_conn request]] 1]
Bas.
On 10/07/2007, at 3:53 PM, Ian Harding wrote:
If you use the internal redirect mechanism like this
ns_section ns/server/${servername}/redirects
ns_param 404 /notfound.adp ;# Not Found error page
And your notfound
On 27 Jun 2007, at 11:54, Jim Lynch wrote:
I don't believe it would be useful to require aolserver to have to
watch for
dropped connections to aolserver; that takes an extra process or
thread and
CPU time that should be used for what aolserver's job is.
The postgres driver could easily do a
something
wrong?
ns_session is working great, this is the first time I tried to use the
ns_cookie commands.
Thanks,
Ian
On 2/24/06, Bas Scheffers [EMAIL PROTECTED] wrote:
Jeremy Collins wrote:
Is this the same module that is in AOLserver CVS? Doesn't look
like it
but they have the same
On 20 Jun 2007, at 09:36, Dossy Shiobara wrote:
Hey everyone! Look at Bas, planting the seed for the Year 2033 bug!
Haha! yeah, you have a valid point. But I didn't do it, some dude at
Netscape in 1995 did! AOL bought Netscape, you work for AOL, so it is
all your fault, really! :P
There
On 20 Jun 2007, at 09:44, Jeff Rogers wrote:
Just in case this is running for 5 or so years, is this susceptable
to a Y2038 bug?
No, it wouldn't because the 2,000,000,000 value is hardcoded and not
relative to now.
But there is, as Dossy pointed out a Y2033 bug if you leave this
unchanged
also updated the documentation of this in the README.
Cheers,
Bas.
On 20 Jun 2007, at 10:08, Bas Scheffers wrote:
On 20 Jun 2007, at 09:36, Dossy Shiobara wrote:
Hey everyone! Look at Bas, planting the seed for the Year 2033 bug!
Haha! yeah, you have a valid point. But I didn't do it, some
Also, Squid *should* be able to detect and re-write this as well.
(well, I think it should; it might, I don't know) Apache's mod_proxy
certainly does this.
This is useful as you can also re-write directories, ie: a request to
/ on the proxy goes to /site/ on nsd; when nsd redirects /site/
You load nsdb in the server's modules section:
ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nsperm ${bindir}/nsperm.so
ns_param nsdb ${bindir}/nsdb.so
ns_param nssession ${bindir}/nssession.so
That's been a sore point for a long time; one that I am trying to solve
with Dossy's blessing. Unfortunately, having a busy project at work and
building work going on at home hasn't sped things up. I came as far as
preparing AOLserver for an OpenACS install, but got stalled there.
If anyone -
: Daniël Mantione [EMAIL PROTECTED]
Date: Wednesday, October 18, 2006 12:56 am
Subject: Re: [AOLSERVER] OT: Who owns aolserver.com?
To: AOLSERVER@LISTSERV.AOL.COM
Op Wed, 18 Oct 2006, schreef Bas Scheffers:
That's been a sore point for a long time; one that I am trying
to solve
As part of a popularity drive, why don't we add more stuff to AOLserver?
TclLib and tdom in the standard build sound like a good idea. So I believe
is my sessions modules. We could merge their documentation into the
AOLserver docs, so all is in one place. The same with the Tcl man pages,
On Wednesday, September 6, 2006 16:56, Tom Jackson said:
it. We can introduce the unique AOLserver APIs to this project. But now we
are back to the beginning: AOLserver isn't unique because of the Tcl
language
after all, it is unique because of the way it solves a particular problem.
If
On Sunday, September 3, 2006 16:58, John Buckman said:
2) there is lots of good competition - everything from Ruby, Python
and Zope to LightHttpd is in the same kind of mind space --
alternatives to Apache that have cool ideas in them.
Well, half of those actually run inside Apache, they are
On Tuesday, September 5, 2006 15:50, Rick Gutleber said:
Support for more popular languages (come on, let's say it together, I
know it's hard, but Tcl is not popular) is probably the most useful
long-term technical change that can be made. This isn't an indictment
As long as it is anything but
On 5 Sep 2006, at 17:57, Titi Ala'ilima wrote:
1) AOLserver probably needs a new name. Something that uses the NS
initials would be ideal so that all those ns_* commands actually
make sense again. Could we resurrect the NaviServer name?
Already taken! (OpenSource
On 5 Sep 2006, at 18:54, Dossy Shiobara wrote:
Of course, non-AOL employees are free to speak and speculate all you
want. We just can't confirm or deny any of it.
Here goes my speculation then!
From between the lines in the past, I picked up that AOL business
units are getting a bit of
Strange title, I know. But hear me out.
I talked before about creating easy to deploy AOLserver
Applications. This is do-able the way I described it, but to do it
right, quite invasive in the core. And it probably still won't be
simple enough for people used to PHP deployments.
Here are
On 1 Sep 2006, at 22:29, dhogaza@PACIFIER.COM wrote:
For the old, non-threaded Apache 1x. My understanding is that the
Apache
2x is quite different, and mod_aolserver would not be a trivial task.
Apache 2 still has the forking thing as well, just depends on how you
config it.
But yeah, a
I use exec for Image Magick, though not in a high-concurrency environment.
I wonder how Photo.net deals with this; I always understood they use Image
Magick this way. Maybe they did in the beginning and have now switched to
a module?
Does anyone have experience with using TclMagick inside
On Thursday, August 17, 2006 8:13, Marc Kalberer said:
My dirty work around is a cron that periodicaly check if an nsd
process is available and if not retstart aolserver.
You should consider running AOLserver using Daemontools; it works like a
charm and much more reliable than scripts looking
On 6 Jul 2006, at 20:20, internet wrote:
Is it fair to assume that those memory usage problems have been
eliminated in AOLserver 4.5.0 when used with Tcl 8.4.1.3?
I'd say so. I believe I was the first to notice the problem with Tcl
8.4.7 or something. It was never something that was a problem
Oh boy, another OS X build problem from me... :(
-
ranlib: can't open file: /Users/bas/dev/aolserver-4.5.0/lib/
libnsthread.a (No such file or directory)
make[1]: *** [install-dll] Error 1
make: *** [install-bins] Error 1
geefive:~/dev/src/aolserver-4.5.0 bas$ ls
AFAIK, following instructions:
geefive:~/dev/src/tcl8.4.13/unix bas$ ./configure --prefix=/Users/bas/
dev/aolserver-4.5.0 --enable-threads
geefive:~/dev/src/tcl8.4.13/unix bas$ make install
geefive:~/dev/src/aolserver-4.5.0 bas$ /Users/bas/dev/aolserver-4.5.0/
bin/tclsh8.4 ./nsconfig.tcl
On 5 Jul 2006, at 19:43, Tom Jackson wrote:
performance from an SQL database. However, if you use the BDB
database, you
will still have to go through some sort of database API, either the
one which
exists, or a custom designed API. The purpose of the built in API
is to share
connections
Tom Jackson said:
I think that there are developers who are not familiar or comfortable with
SQL
and database management systems. This can lead to a number of bad choices
This seems to be a big problem everywhere. I didn't realize quite how bad
it was in our company until just two weeks ago
John Buckman said:
to AOLServer scalability and the ns_bdb module (which works very well).
That's good to know, I may have some use for it.
1) scripting overhead, esp as the application matures and more and
more dependent code gets included on each page load
How do you mean included? Actual
On 3 Jul 2006, at 11:35, John Buckman wrote:
No, but on the other hand, most interactive web sites have response
times over 3 seconds. Amazon, for instance, now is frequently 10
seconds for a book page load. Yahoo, with it's page times
consistently under 1 second, is a pleasure to use.
Jamie Rasmussen said:
For my nightly AOLserver build I use Visual C++ Toolkit 2003. The
Toolkit is command-line only but free-to-download. In my opinion that's
enough to make it the preferred compiler for now. I have a TCL script
Isn't the code the free one produces not quite as optimized as
Hi,
Just trying to make nspostgres work on Mac OS X. Any ideas? See
output below.
Cheers,
Bas.
geefive:~/dev/src/nspostgres-4.0 bas$ make POSTGRES=/usr/local/pgsql/
INST=/Users/bas/dev/aolserver-4.0.10
gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql//include -Os -Wall -Wno-
implicit-int
On 30 Jun 2006, at 22:04, Dossy Shiobara wrote:
Where's the -lnsdb ... ?
Well spotted. Just looked at the makefile; it only puts it in if
AS3=1. Not sure where that is supposed to come from
(Makefile.global?) but if I put it in always, it links just fine.
Cheers,
Bas.
--
AOLserver -
John Buckman said:
I'm trying to redirect 404 not found pages to the home page. The
annotated config file shows this as:
Are you sure you want to do this? This is very confusing for users! I
personally hate this when I come acros a site that does it. I much prefer
a 404 page with link to the
On 3 Jun 2006, at 00:56, William Scott Jordan wrote:
personal website. For the most part, this just means that we need
to change the style sheet and use Company X's URL instead of our
own. Because we could be looking at potentially thousands of
clients wanting to do this and because 99.9%
On 17 May 2006, at 21:34, Dossy Shiobara wrote:
Dave Siktberg seems to have narrowed it down to 2006-05-12 21:25.
In what timezone? It sound like that could equate to Sat May 13
02:27:28 BST 2006, or 1147483648 seconds since epoch, which makes it
*exactly* 1,000,000,000 seconds until expiry
Hi,
Just trying to setup AOLserver on a debian box. Tried several version of
Tcl and AOLserver (including the 8.4.9/4.0.9 I have working elsewhere on a
Fedora box) but always the same problem:
conn.c: In function 'NsTclConnObjCmd':
conn.c:843: error: invalid lvalue in assignment
make[1]: ***
= itPtr-conn;
connPtr = (Conn *) conn;
Rick
Jeremy Collins wrote:
Make sure you're building not building with gcc 4.0, maybe try 3.3 or
3.4.
On May 9, 2006, at 9:06 AM, Bas Scheffers wrote:
Hi,
Just trying to setup AOLserver on a debian box. Tried several version
of
Tcl
John Buckman said:
Because BerkeleyDB's tcl interface isn't thread safe, I'm running
aolserver in single-thread mode, with
You need to look into environments in the Berkely DB system. The way I
see it, you should be able to have concurrent access to one database from
many threads in AOLserver.
John Buckman said:
440 hits/s second is plenty fast, amazing even (fyi, compared to
about 12 hits/s I get if I code the same page in MySQL), I was just
What kind of SQL/code is that? And what kind of server? I get 100+
pages/sec using AOLserver and Postgres for a message board system; two
Mark Aufflick said:
I also want to say that I was joking in the comment quoted below. Weak
technology (especially expensive weak technology) gets me a little hot
under the collar sometimes but I don't think there was any real
In that regards, IBM to me has always been a shocking example with
Mat Kovach said:
I see many large scale sites that run UDB/DB2. I know of at least three
sites that have, easily, 1000 UDB instances running. I lot of people
What kind of sites are they? What industries?
Cheers,
Bas.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this
Mark Aufflick said:
I feel a good old fashioned usenet style flame war coming on =)
Slashdot has flame wars, all we have are friendly argument with as outcome
learning more about our favourite and other products.
In Sybase, NULL matches NULL in a search clause (by default - as
Yes. I personaly
Mark Aufflick said:
do show disturbingly similar philosophies - like making NULL = NULL by
default because many clients with poorly trained developers asked for
I recon that's the only one! (and I still don't see why this is such a bad
thing) My problem with MySQL isn't this simplification, it's
Dossy Shiobara said:
You're right; MySQL is orders of magnitude better than Sybase. I'm dead
Yeah, when it doesn't blow up in weird and wonderul ways... And you don't
mind not being able to do online backups And if you think '-00-00'
or '2006-02-30' is a date... (oh no, just tested mysql
Tom Jackson said:
It sounds like you guys are comparing rotten oranges and rotten apples.
Are there any apples that aren't considered rotten by someone, somewhere?
Like I said before, every RDBMS has it's issues...
...MySQL just takes them to a whole new level and gets even otherwise
sensible
Dossy Shiobara said:
Oh man, who is feeding you this pack of lies? I mean, MySQL has been
able to do hot online backups since May 2002! Well, you've been able to
How? All I can find is this mysqldump and mysqlhotcopy, which lock
tables while they are being dumped. Hardly online backup if you
On 6 Apr 2006, at 17:42, Dossy Shiobara wrote:
Can you embed Postgres? Before I got turned on to SQLite, MySQL
served
I don't see that as a downside, it's not what I use it for. Like you
say, there's SQLite for that. Try embedding MySQL into a non-GPL
project and see how free it is then!
On 6 Apr 2006, at 19:13, dhogaza@PACIFIER.COM wrote:
The people who wrote MySQL have the ethical standards of the George W.
Bush administration.
What, it's made by the same folks as those behind JBoss!? ;-)
Bas.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list,
select @@identity for the last identity value assigned in the
current session. This is acros all tables with id columns, so if you
are inserting multiple in one transaction and need all of them, be
sure to assign them to another variable after each insert.
Cheers,
Bas.
On 5 Apr 2006, at
Mark Aufflick said:
I have seen some large Sybase databases go down quite spectacularly.
Any details on how or why? One common cause for downtime is filling up the
log space and locking up the DB, not knowing how to fix it. But they
should have read the manual!
Most of the web world runs on
Mark Aufflick said:
Doesn't that still serialize all updates requiring access to that
sequence?
Sequences are used for inserts, not updates. Well, I haven't seen them
being used in updates anyway.
If you used it within a transaction it would also have implications
with other transactions
Andrew Piskorski said:
No. Sequences in an RDBMS are designed to scale gracefully under
heavy concurrent load. (This is basic stuff, grab any good
I think Mark was talking about my Sybase solution (sequence table) for if
you don't want to use identity columns.
I think SQL Server and Sybase
Dossy Shiobara said:
I just have to ask: what version of Sybase and Oracle are you comparing?
9i and 11.92, 12, 12.5.
The worst Oracle instance was maintained by a couple of very good DBAs, at
least according to the guy who actually worked for Oracle and did an audit
of our system. They were
Looks like some regexp failing on the username:password.
ns_httpopen (called by ns_httpget) doesn't know how to handle basic auth
at all.
You could try using the Tcl http package instead, but I don't know if it
does it:
http://tcl.tk/man/tcl8.4/TclCmd/http.htm
Otherwise you will have to hack
William Scott Jordan said:
ns_db dml $db INSERT INTO test (test_column) SELECT
COALESCE(MAX(test_column),0) + 1 FROM test
Ehrm, that is a very, very bad way of creating keys. It is no unlikely
that on a very loaded site two people might insert at the same time and
get the same key!
The correct
To repeat Dossy: wow, they came with a cool new name for something old! :)
That said: in principle, AOLserver is perfectly able to do this as it has
the ability to just keep the connection open for as long as you like and
stream the data. You should be thinking of a registered proc or .tcl file
Jeremy Henty said:
server, which Dossy has made perfectly clear). When a new thread is
created,
is it's Tcl interpreter created from scratch by reexecuting the source, or
is it simply cloned from a preexisting interpreter? (Or a bit of both?)
Neither, it's executing the init script, created
Jeremy Henty said:
Thanks again to Bas and Dossy! I'm digging through init.tcl to see how
init.tcl in modules/tcl isn't actually the init script we are talking
about. The file you are looking at is simply the first .tcl file in that
directory that gets loaded, before the others are done. The
1 - 100 of 278 matches
Mail list logo
