|
Home > Archive > Unix Shell > December 2007 > download SQL under Solaris10 x86
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
download SQL under Solaris10 x86
|
|
| happytoday 2007-11-30, 1:24 pm |
| I need to learn and download an SQL under Solaris10 x86 version from
where can I begin (What version is easier to have and learn)?
| |
| Gary Mills 2007-11-30, 1:24 pm |
| In <cd1af099-3323-4a81-96f5-e410da9c5bde@v4g2000hsf.googlegroups.com> happytoday <ehabaziz2001@gmail.com> writes:
>I need to learn and download an SQL under Solaris10 x86 version from
>where can I begin (What version is easier to have and learn)?
Mysql is already there:
$ uname -a
SunOS toliman 5.10 Generic_120012-14 i86pc i386 i86pc
$ whence mysql
/usr/sfw/bin/mysql
There's even a manual page, provided that /usr/sfw/man is in
your MANPATH.
--
-Gary Mills- -Unix Support- -U of M Academic Computing and Networking-
| |
|
|
|
| Rich Teer <rich.t...@rite-group.com> wrote:
> happytoday wrote:
> No need to download anything: Solaris ships with Postgres and
> mysql "in the box". :-)
While Mr. Teer's reputation preceeds him, I venture the hubris
to add a caveat for one presuming to learn SQL/RDBMS: I
recommend that you _either_ commit to learning canonical SQL
(if such as thing can be said to exist!), or accept the
considerable "kruft" that you will have to additionally learn
around an established RDBMS that you at least can continue
to use. In-between solutions, especially involving MySQL, are
deprecated both by myself and others (JFGI for the usual
scuttlebutt).
For the former alternative, I recommend:
http://authors.aspalliance.com/habal/sql/default.asp
^ try: http://www.sqlcourse2.com/
.... And for the second alternative, I reiterate Celko's (another
name which will become eventually familiar to you) advice of
preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
Postgres and go directly to PostgreSQL, its opensource and
standards compliant modern SQL implementation.
See another thread discussing the usual tradeoffs of minimalism
versus generality:
http://groups.google.com/group/comp...8e2c50d9b7f8e69
sunfreeware.com has precompiled versions:
http://www.sunfreeware.com/programlistsparc10.html
As for myself, the most experience I have with a RDBMS
optimal for learning is OCELOT -- a miraculous RDBMS:
not too hot, not too cold, but just right...
OCELOT.c: RDBMS: ASCII, SQL99:
http://www.ocelot.ca
http://www.ocelot.ca/commands.htm
=Brian
| |
| Alan Coopersmith 2007-12-04, 1:38 am |
| bsh <brian_hiles@rocketmail.com> writes in comp.unix.solaris:
|Rich Teer <rich.t...@rite-group.com> wrote:
|> happytoday wrote:
|> > I need to learn and download an SQL under Solaris10 x86 version from
|> > where can I begin (What version is easier to have and learn)?
|> No need to download anything: Solaris ships with Postgres and
|> mysql "in the box". :-)
|
|... And for the second alternative, I reiterate Celko's (another
|name which will become eventually familiar to you) advice of
|preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
|Postgres and go directly to PostgreSQL, its opensource and
|standards compliant modern SQL implementation.
PostgreSQL is the one that's actually bundled into Solaris.
--
Alan Coopersmith * alanc@alum.calberkeley.org * Alan.Coopersmith@Sun.COM
http://blogs.sun.com/alanc/ * http://people.freedesktop.org/~alanc/
http://del.icio.us/alanc/ * http://www.csua.berkeley.edu/~alanc/
Working for, but definitely not speaking for, Sun Microsystems, Inc.
| |
| Nomen Publicus 2007-12-04, 1:38 am |
| In alt.solaris.x86 Alan Coopersmith <alanc@alum.calberkeley.org> wrote:
> bsh <brian_hiles@rocketmail.com> writes in comp.unix.solaris:
> |Rich Teer <rich.t...@rite-group.com> wrote:
> |> happytoday wrote:
> |> > I need to learn and download an SQL under Solaris10 x86 version from
> |> > where can I begin (What version is easier to have and learn)?
> |> No need to download anything: Solaris ships with Postgres and
> |> mysql "in the box". :-)
> |
> |... And for the second alternative, I reiterate Celko's (another
> |name which will become eventually familiar to you) advice of
> |preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
> |Postgres and go directly to PostgreSQL, its opensource and
> |standards compliant modern SQL implementation.
>
> PostgreSQL is the one that's actually bundled into Solaris.
>
Sqlite 2.8 is available in Sol10 as /lib/svc/bin/sqlite
| |
| Gorkhan 2007-12-05, 1:42 am |
| On Dec 4, 1:42 am, Nomen Publicus <n...@buffy.sighup.org.uk> wrote:
> In alt.solaris.x86 Alan Coopersmith <al...@alum.calberkeley.org> wrote:
>
>
>
>
>
> Sqlite 2.8 is available in Sol10 as /lib/svc/bin/sqlite- Hide quoted text -
>
> - Show quoted text -
I was told by a Sun SE that Postgres has been washed thru Dtrace to
find hotspots in the code, and these have been ironed out. Postgres
should perform nicely.
| |
| Rich Teer 2007-12-05, 1:24 pm |
| On Mon, 3 Dec 2007, bsh wrote:
> While Mr. Teer's reputation preceeds him, I venture the hubris
> to add a caveat for one presuming to learn SQL/RDBMS: I
> recommend that you _either_ commit to learning canonical SQL
> (if such as thing can be said to exist!), or accept the
Good advice.
> preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
> Postgres and go directly to PostgreSQL, its opensource and
> standards compliant modern SQL implementation.
Umm, Postgres *is* PostgreSQL (the former being a common
abbreviation for the latter)! Being SQL-compliant is one
of the reasons why I recommend it over MySQL...
--
Rich Teer, SCSA, SCNA, SCSECA, OGB member
CEO,
My Online Home Inventory
URLs: http://www.rite-group.com/rich
http://www.linkedin.com/in/richteer
http://www.myonlinehomeinventory.com
| |
| happytoday 2007-12-24, 7:19 pm |
| On Dec 4, 6:55=A0pm, Rich Teer <rich.t...@rite-group.com> wrote:
> On Mon, 3 Dec 2007, bsh wrote:
>
> Good advice.
>
>
> Umm, Postgres *is* PostgreSQL (the former being a common
> abbreviation for the latter)! =A0Being SQL-compliant is one
> of the reasons why I recommend it over MySQL...
>
> --
> Rich Teer, SCSA, SCNA, SCSECA, OGB member
>
> CEO,
> My Online Home Inventory
>
> URLs:http://www.rite-group.com/rich
> =A0 =A0 =A0http://www.linkedin.com/in/richteer
> =A0 =A0 =A0http://www.myonlinehomeinventory.com
can any body advice me of simple SQL programs of how can I create a
table and insert some records into it written using SQL code .
Thanks
| |
| Ian Collins 2007-12-24, 7:19 pm |
| happytoday wrote:
> On Dec 4, 6:55 pm, Rich Teer <rich.t...@rite-group.com> wrote:
*For goodness sake, stop quoting signatures!*[vbcol=seagreen]
>
> can any body advice me of simple SQL programs of how can I create a
> table and insert some records into it written using SQL code .
> Thanks
Just type it in, or learn a scripting language like PHP.
--
Ian Collins.
| |
| Rich Teer 2007-12-25, 7:19 pm |
| On Mon, 24 Dec 2007, happytoday wrote:
> can any body advice me of simple SQL programs of how can I create a
> table and insert some records into it written using SQL code .
Read a book on SQL and database programming.
But as it's Xmas, here's a snippet:
create table people
(
id serial,
name varchar (128) not null.
age int not null,
primary key (id)
);
insert into people (name, age) values values ('Rich Teer', 40);
HTH,
--
Rich Teer, SCNA, SCSA, SCSECA, OpenSolaris CAB member
. * * . * .* .
. * . .*
President, * . . /\ ( . . *
Rite Online Inc. . . / .\ . * .
.*. / * \ . .
. /* o \ .
* '''||''' .
URL: http://www.rite-group.com/rich ******************
|
|
|
|
|