AltME groups: search

It was always a GPL SQL database, but people complained it didn't 
support as much as, say, Oracle and PostgreSQL

I also needed to add the Java folders to PATH manually, I don't know 
what Oracle is doing with its installers...

If you don't look at the source, but just examine the behavior from 
the outside, that is called clean-room reverse engineering. You can't 
be blocked on copyright violation grounds, just patent and trademark 
stuff. Even the function specs could be considered to be not copyrightable, 
according to Google vs. Oracle, though that case's appeals haven't 
made it to the supreme court yet. The doc strings are another issue 
though since they aren't technically necessary for interoperability. 
Copyright laws (at least in the US) don't make a distinction between 
code and data when it comes to derived works.

GPL's licensing is much more murky when it relates to languages and 
interpreters.  in court it could be a much bloodier battle than it 
was for Google vs Oracle.

The only place I've seen othermindedness happen has been inside companies 
with strong leaders.  The results are always powerful.  The Humana 
Healthcare organization went from 4 rural hospitals to the second 
largest HMO in America that way. Waste Management also became the 
largest waste disposal company in America that way.   There is one 
part of Oracle that is experiencing a 4 fold increase in sales as 
a result of an othermined culture establish by the general manager 
of that department.  NewTek was another company that started out 
that way. It can be done, but I've never seen it in an open source 
community.

almost :) Oracle doesn't support it, I think. http://www.petefreitag.com/item/666.cfm

Or better put it only for unsupported db server like Oracle.

ack  oracle bought sleepycat (maintainers if berkeley ) last month

They use one fat Oracle server, that has some bugs and is not patched 
correctly so that everyone can grab some data, burn it and sell it.

And also the Sun and Oracle tools, since the component model of Java 
was designed by Borland. And Eclipse, since it emulated the MS tools.

re #4116 - the same bug happens even via ODBC Oracle driver. So maybe 
Oracle driver is just a wrapper to ODBC? My suspicion is, that result 
of such query is non-standard, it is returned to the pipe, and rebol 
crashes by trying to parse it. Just a wild speculation though ...

Is there a way to change the format of to-date?  In oracle you can 
specify to-date(field, 'MM-DD-YYYY') and I need to read in a lot 
of dates that are in MM/DD/YYYY, but to-date assumes it's DD/MM/YYYY. 
 I also have dates that are Month DD, YYYY.

rebol/view is my refuge from the evils of Oracle and SQL Server development 
:)

what's the freebie oracle like?

I've juste noticed the nice values we get for event key when pressing 
function keys !!!

in order: console listen tcp udp icmp dns local odbc oracle

I have installed mySQL and Oracle as part of my studies for improving 
TretbaseDB.  I'm curious from others that use mySQL with REBOL as 
to what they dislike about the interoperablility or what they like 
most about it.

> My guess is also that Oracl, SQL Server and perhaps PostGreSQL 
are smarter with their table optimziers and query rewriters


Postgres is about 2 times faster than MySQL in this query, but the 
execution time grow alot as num of records increase. 
So I really don't know how good is compared to MySQL.
Oracle, I would try, but I have no time :-P

> Also, change the count(*) to count(1)

Thanks, good one.


The real tables will be more large (5 M record or more), so small 
optimizations would be not sufficient
I'm tryng a different approach, using one simple stored function:

create function running_total (cod VARCHAR(50), adder DECIMAL)
RETURNS DECIMAL
	BEGIN
		IF @last_cod <> cod THEN
			BEGIN
				SET @running_total = 0;
				SET @last_cod = cod;
				SET @num_row = 0;
			END;
		END IF;
		SET @running_total = @running_total + adder;
		SET @num_row = @num_row + 1;
		RETURN @running_total;
	END

and using as select:

SET @last_cod = ''; 
SET @running_total = 0; 
SET @num_row = 0; 

SELECT cod , date, running_total(cod , amount), @num_row FROM a ORDER 
BY cod, date;


This approach seems really fast : processing and inserting 100'000 
records  took less than 1 sec. instead of  281,73 sec. with SQL join

To run syllable server, I personally need

1. ghostscript
2. hylaFAX
3. oracle or mysql
4. jira
5. pmwiki
6. apache
7. cheyenne

Kaj, I see that you've included Oracle's BerkeleyDB, but not the 
less corporate sqlite. Was there a specific reason for that choice?

Yes, BerkeleyDB was one of the oldest and most popular open source 
databases before Oracle acquired it. Many open source packages require 
it. We would rather have kept it out of the base system, but one 
such package is in the Syllable Server base system; I believe IPRoute

All SDKs have shell, library and encryption. Command adds ODBC/Oracle 
and SSL (client side)

Using Vid, I get for F1 onwards, console, listen, tcp, udp, icmp, 
dns, odbc, oracle, msql, crypt, compress ...

Looks like it might be using Oracle as the DB ...

New version of SQL-PROTOCOL is on www.rebol.org


This new version handle now standard SQL string for SELECT, INSERT, 
UPDATE and DELETE so you have a better compatibility with other database 
like MySQL, Oracle or ODCB protocol.

Command adds encryption, ODBC, Oracle, (slower native) MySQL, and 
SSL.

The idea with the on-* naming is to clearly indicate an event. I 
toyed with using just focus / unfocus but these verbs could be confused 
with the functions of the same name. Likewise, 'enter could be confused 
with the 'return keyword and 'exit has the same issue with regards 
to both 'exit and 'quit. 'on-enter and 'on-exit are possibilities 
though.


on-focus and on-unfocus return true or false so as you can handle 
failure. This scenario is more likely with on-unfocus where you would 
want to trap and handle a field validation failure for example.


The difference between on-unfocus and the usual action (both may 
be triggered by pressing enter for instance) is that on-unfocus enables 
you to interrupt the normal work-flow by aborting the unfocus and 
subsequent focus operation - something you could not [easily] do 
normally. Also, for many widgets the usual action and on-* actions 
may be different (e.g. pressing enter to initiate the default action 
may be quite different to pressing tab and leaving the field).


For those familiar with Oracle*Forms, and similar products, these 
new actions are like the pre-field and post-field triggers (with 
the app-level ones mapping to pre-form and post-form).

Good questions all, keep them coming.

Odd, just noticed that the latest View beta is registering fkeys 
as 'console, 'icmp, 'oracle, etc. Wierd. I vagually recollect someone 
else mentioning this before in another group though.

oracle ??

This seems to work in lInux.  In display.r, change

							find [f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12] event/key
to 

       find [ console listen tcp udp icmp dns local odbc oracle mysql crypt 
       compress ] event/key

and redefine on-fkey in rebgui-ctx.r

	on-fkey: make object! [

   console: listen: tcp: udp: icmp: dns: local: odbc: oracle: mysql: 
   crypt: compress: none
	]

Oracle acquires Sleepycat
http://sleepycat.com/

After buying Sleepycat, Oracle tried to buy mySQL - it starts to 
be worryig :-)

http://news.com.com/Oracle+tried+to+buy+open-source+MySQL/2100-7344_3-6040197.html?tag=nefd.lede

Oke SAP and Oracle is a different story... ;-)

Statistically, I find it close to impossible to believe that no open 
source infringes on MS, to begin with.

Then there are patents from IBM, Oracle, etc. 


One has to either decide they are for patents or against them.  Once 
you have worked that out (sort of religion), then you can make all 
your other statements.

But MS is not the issue here.

And Oracle acquires BEA


http://www.bloomberg.com/apps/news?pid=20601087&sid=alI8qN7k9lQU&refer=home

Our general media portal reports, that SUN is being bought by Oracle. 
I thought that it was IBM who tried to acquire them? Anyone confirms 
the news?

Hm.. I imagine they have hard time selling Oracle if MySQL is free.. 
I wouldn't like to be mysql right now :)

I didn't know Oracle even exists in last years, and surelly not that 
they have so much $$ to buy Sun (+ MySQL )... I am not sure if they 
are very present in web-scene

Oracle already owns the company thaat makes the InnoDB engine for 
MySQL, and that didn't kill MySQL.

Oracle moves away from a one-product company. Strategically a good 
step. And owning a lot of datastorage infrastructure within the companies 
makes them a logical choice for the other layers.

But overall, I don't like this happening... when will Oracle DBs 
internally use ZFS?

Nothing. I'm using it on OSX. My message referrs to two topics:
1. Oracle buys Sun -> I don't like it
2. Maybe ZFS will now become more a DB thing than a FS thing.

I wonder if this would have happened if Google had used oracle as 
their primary database engine

Looks like the ability to sue Google was one of the things Sun was 
selling to Oracle http://nighthacks.com/roller/jag/entry/the_shit_finally_hits_the

Oracle probably sued Sun before they bought them ....

It's called a "Pseudo-Relational Database" for a good reason. ;)


But in answer to Pekr's previous point; *you* can work out *how* 
to do that aggregation more efficiently than the limited AI of most 
RDBMS systems. I've worked at DB2 and Oracle shops where it was mandated 
that all JOINs be performed inline! SQL optimizers are not trivial 
to write, and the meta-data overhead (indexes, statistics, hints, 
etc) required to get them to make the "right" choices are often a 
false economy.

hehe, just reading Alianz success story. Those bank guys don't fear 
risking choosing non-traditional aproach. They chose AcuCobol with 
its own file system as a storage instead of relational database. 
Those IT ppl must be crazy, to run such a big house ... well, without 
SAP and Oracle :-)

i wonder if some great guys who help carl thought about Database 
access ? odbc? rebol native lib for mysql db2 oracle mssql etc....

Talk to professional Java or Oracle developers and then see if you 
can claim programmers are curious :(

I like "theorical", it sounds like "the oracle". :-)

what does Database C drivers: MySQL 3,Oracle 8 ... mean, btw?
it doesnt work with mysql 5 and ora 10?

Those drivers are built in REBOL/Command. It depends if Mysql 5 and 
Oracle 10 servers are compatible with older drivers. I can only answer 
for Mysql, and the answer is no.

Not everybody run on Mysql 5 and Oracle 10, so it can be useful to 
some users. Also it's all or nothing, I cannot chose which native 
feature I want to include or not.

When any process wants to write, it must lock the entire database 
file for the duration of its update


However, client/server database engines (such as PostgreSQL, MySQL, 
or Oracle) usually support a higher level of concurrency and allow 
multiple processes to be writing to the same database at the same 
time. This is possible in a client/server database because there 
is always a single well-controlled server process available to coordinate 
access. If your application has a need for a lot of concurrency, 
then you should consider using a client/server database.

And Oracle (does anyone use that?)

BrianH .. a public license means that everyone gets ssl, odbc, oracle, 
encryption today without waiting for a new build.

Brian, yes we use Oracle and Sybase specifically in our enterprise.

OpenSolaris seems to be suppported by Oracle and a large community

It's a little soon to see if it will be supported by Oracle, but 
it's a cool platform.

since Oracle also owns VirtualBox

like this?
the cli connector is using the cli component nearly all major
databases delivering. the connection is made via rebols 

call/wait/info/output/error and a simple parse after, for the resultset.
I am using this prototype mainly for a q & d connect

to mysql/postgresql/monetdb/sqlite. on my list are also connectors 
for

firebird/oracle/greenplum/sybase/ingres/infobright/frontbase and 
cassandra.
pros:

1. very fast for single requests
2. no rewrite of code needed if a new version or protocol is out
3. easy 'data migration' between the db's

4. adding new db's are a matter of hours only (see the cli spec thats 
all)
5. fast prototyping and testing for new db's

6. robust, never had any trouble with cli's even with bigger resultsets

7. should be perfect also for traditional cgi (the process starting 
overhead is minimal, execpt you name is facebook)

8. very small footprint (~120 lines for connecting to 4 db's, could 
be the half)

with a nice tcp-server component like rebservice the 
cli multi connector could be very usefull as a c/s connector.
I made a test with 2.000 concurrent calls (simple select) 
on a 4 gig quadcore. the cpu was only close to 50%, a good value.

cons:


1. slow if you have very much serial inserts (unless you shape them 
into one sql query)
2. need to start a cli process for every request
3. needs a tcp server for non-local connections
4. some more, but who cares ;-)

with a solution to keep the cli open from rebservice,

these cons could disappear and the speed diff overhead to a memory 
based lib
could be marginal.

maybe i wasn't clear. Sorry i readed my post and some things appears 
not to be clear anough... 


1) Rebol runtime environement already exists that's the VM you install 
on your computer when you want to run scripts 

But a) it's not called a runtime environement  b) it's need disappears 
when you use REBO/SDK to "hide" your industrial secrets or when you 
don't want on purpose the client to install or know that  it's rebol 
behind.


2) by speudo compiling (byte code compilation) you allow people that 
need it to be a step closer to the hardware but keeping the portability 
effect so a rebol VM in my opinion should be able to  run both  a 
speudo binary file or a text script rebol file. Of course  like in 
java people would feel the need to share their software with embeded 
 Rebol Runtime Environement.


3) Having a runtime environement is the best modular way ...  core 
will be the base then you have View and lot of othe modules that 
wil clip to rebol. for example if i  put  import  "oracle" at the 
begining of my script then rebol runtime environement knows that 
he need the oracle package and goes to rebol.com to retrieve it and 
install it to the proper rebol runtime place in order for the vm 
to find it. Something close to what apt-get is to debian. REbol Environement 
doesn't comes with the whole thing but if the script tells it he 
can expend it selves in the fastest way. Well this runtime organisaton 
in  fact already exists but it's not pushed to it's extend, you know 
the point where the good idea become the best idea. the rebol/view 
2 implies a /desktop which implies a local scrit library (like a 
cache) to store the rebol script see the idea is there but once again 
it's not pushed to it's limits. Only rebgui used this system to store 
an extension to rebol.


4) by being closer to what people extend as an output you make them 
interessted in your input . To be more explicite by giving to peope 
what they are used to get in the end of their creation process then 
you allow them to be confident in your solution and to be more interressted 
on the way you propose to build your software.


5) i took java and .net as main example but if you look closely this 
is an expending tendency. For example Adobe Flash do that.


6) the other interrest in the compiled way is to merge the source 
code and the related resourcies at the same place (1.exe  file for 
example) and then forbiding the people to change their contents ... 
and this leaded then to the skining my application modo. Wich is 
just the we don't merge in the resulting binary the resourcies . 
In rebol we can already easyly build a script merger with data to 
output a .r file containing both but then people can still extract 
the ressourcies and change them etc...

The primary reason for supporting NaNs would be for easy of interaction 
with systems that do support NaN, eg Oracle.


Right now, any REBOL system that was trying to trade values with 
an Oracle system that supported NaN and +/-INF would need to code 
for special cases.


However, I do not know of anyone who has such a need -- so time for 
some to make the busines case!

some servers are anti-indexing and its in these cases where the brute 
parse is most effective.  I've even had to cater an oracle web server 
which didn't have ANY css, type, or id fields in all pages which 
are driven by form.  all urls can only be read once, and every page 
read is a redirect.   


only parse allowed me to cope in such a drastic anti-robot  environment. 
 it still took a day to build the robot.  and in the end, it even 
had an auto-user-creationg step at each 200 pages which created a 
google gmail account for the next batch.  :-)

in those cases, parse is king.