Database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Database

Luke Ivers
In the one place I really found any in depth-information, it showed creating a DB connection each time you wanted to access information stored in a GOODS based DB... is this the suggested method of retrieving database information?

Also, is GOODS the only suggested resource for storing DB information?  I see that there is a Postgre DB client written for Squeak, I was hoping to be able to use some kind of ORM to be able to access a different DB than GOODS... is that possible?

I intend to start on creating a tutorial as part of my learning experience (I find that writing down how I did things not only helps others to do the same things, but solidifies my knowledge of what I'm doing).

I am going to start out attempting to write my own blog software, followed by a couple of more complex projects, hopefully documenting my each step along the way.

However, I am at a loss as far as DB connectivity goes... can anyone point me to a guide on this, or give me a few pointers on how I should be accomplishing it?

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

Ramiro Diaz Trepat
On Ramón's blog, http://onsmalltalk.com you can find how he built a connection pool for the Seaside / Glorp Postgres stack.
Probably it is easy to make it work with a GOODS or Magma session too.
Cheers

r.



On 4/16/07, Luke Ivers <[hidden email]> wrote:

> In the one place I really found any in depth-information, it showed creating
> a DB connection each time you wanted to access information stored in a GOODS
> based DB... is this the suggested method of retrieving database information?
>
> Also, is GOODS the only suggested resource for storing DB information?  I
> see that there is a Postgre DB client written for Squeak, I was hoping to be
> able to use some kind of ORM to be able to access a different DB than
> GOODS... is that possible?
>
> I intend to start on creating a tutorial as part of my learning experience
> (I find that writing down how I did things not only helps others to do the
> same things, but solidifies my knowledge of what I'm doing).
>
> I am going to start out attempting to write my own blog software, followed
> by a couple of more complex projects, hopefully documenting my each step
> along the way.
>
> However, I am at a loss as far as DB connectivity goes... can anyone point
> me to a guide on this, or give me a few pointers on how I should be
> accomplishing it?
>  
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>
>

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

tblanchard
In reply to this post by Luke Ivers
Lots of people are using postgres with glorp.

-Todd Blanchard

On Apr 16, 2007, at 10:43 AM, Luke Ivers wrote:

> In the one place I really found any in depth-information, it showed  
> creating a DB connection each time you wanted to access information  
> stored in a GOODS based DB... is this the suggested method of  
> retrieving database information?
>
> Also, is GOODS the only suggested resource for storing DB  
> information?  I see that there is a Postgre DB client written for  
> Squeak, I was hoping to be able to use some kind of ORM to be able  
> to access a different DB than GOODS... is that possible?
>
> I intend to start on creating a tutorial as part of my learning  
> experience (I find that writing down how I did things not only  
> helps others to do the same things, but solidifies my knowledge of  
> what I'm doing).
>
> I am going to start out attempting to write my own blog software,  
> followed by a couple of more complex projects, hopefully  
> documenting my each step along the way.
>
> However, I am at a loss as far as DB connectivity goes... can  
> anyone point me to a guide on this, or give me a few pointers on  
> how I should be accomplishing it?
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

Rajeev Lochan
Dear Members,
Even I was interested in knowing the pros and cons of these DBs. It would be great if senior members post with the advantages of Magma or Goods over one another.

Regards,
Rajeev



On 4/17/07, Todd Blanchard <[hidden email]> wrote:
Lots of people are using postgres with glorp.

-Todd Blanchard

On Apr 16, 2007, at 10:43 AM, Luke Ivers wrote:

> In the one place I really found any in depth-information, it showed
> creating a DB connection each time you wanted to access information
> stored in a GOODS based DB... is this the suggested method of
> retrieving database information?
>
> Also, is GOODS the only suggested resource for storing DB
> information?  I see that there is a Postgre DB client written for
> Squeak, I was hoping to be able to use some kind of ORM to be able
> to access a different DB than GOODS... is that possible?
>
> I intend to start on creating a tutorial as part of my learning
> experience (I find that writing down how I did things not only

> helps others to do the same things, but solidifies my knowledge of
> what I'm doing).
>
> I am going to start out attempting to write my own blog software,
> followed by a couple of more complex projects, hopefully
> documenting my each step along the way.
>
> However, I am at a loss as far as DB connectivity goes... can
> anyone point me to a guide on this, or give me a few pointers on
> how I should be accomplishing it?
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside



--
Rajeev Lochan

Co-founder, AR-CAD.com

http://www.ar-cad.com
+91 9212090622 (Gurgaon)
080 65355873 (Bangalore)
_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

Luke Ivers
In reply to this post by tblanchard
Thanks to both Ramiro and Todd for good advice :)  That's exactly what I was looking for.
If anyone cares (at all), you can see the beginning of my tutorial at
http://technodolt.blogspot.com

You can also feel free to comment, and I will definitely change/update anything I have wrong.

On 4/16/07, Todd Blanchard <[hidden email]> wrote:
Lots of people are using postgres with glorp.

-Todd Blanchard

On Apr 16, 2007, at 10:43 AM, Luke Ivers wrote:

> In the one place I really found any in depth-information, it showed
> creating a DB connection each time you wanted to access information
> stored in a GOODS based DB... is this the suggested method of
> retrieving database information?
>
> Also, is GOODS the only suggested resource for storing DB
> information?  I see that there is a Postgre DB client written for
> Squeak, I was hoping to be able to use some kind of ORM to be able
> to access a different DB than GOODS... is that possible?
>
> I intend to start on creating a tutorial as part of my learning
> experience (I find that writing down how I did things not only

> helps others to do the same things, but solidifies my knowledge of
> what I'm doing).
>
> I am going to start out attempting to write my own blog software,
> followed by a couple of more complex projects, hopefully
> documenting my each step along the way.
>
> However, I am at a loss as far as DB connectivity goes... can
> anyone point me to a guide on this, or give me a few pointers on
> how I should be accomplishing it?
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside


_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

Ramiro Diaz Trepat
In reply to this post by Rajeev Lochan
This is a possible flame generating question.
I am no "senior member", but I'll tell you my brief experience:

  • OmniBase
    Discard if you intend to use the free version with Squeak.

  • Magma
    Excellent code integration, probably the most elegant of all. 
    Can run as server and client images separately.
    Has a great query language that no one else has
    Has special classes for large collections that you can create indexes to specific attributes
    Has programmable ReadStrategies
    Has excellent support from its creator Chris Muller, and the list.
    The bad thing: It is a bit too slow.  Both for inserting and for querying, even on mid sized collections (a few thousand elements) with indexes and optimal read strategies can still be pretty slow.

  • Glorp / Postgres
    I'm just starting to test this, but it seems to run _real_ fast.
    It is A LOT more work to do the initial set up (OR mappings).

On 4/16/07, Rajeev Lochan <[hidden email]> wrote:

> Dear Members,
> Even I was interested in knowing the pros and cons of these DBs. It would be
> great if senior members post with the advantages of Magma or Goods over one
> another.
>
> Regards,
> Rajeev
>
>
>
>
>  On 4/17/07, Todd Blanchard <[hidden email]> wrote:
> > Lots of people are using postgres with glorp.
> >
> > -Todd Blanchard
> >
> > On Apr 16, 2007, at 10:43 AM, Luke Ivers wrote:
> >
> > > In the one place I really found any in depth-information, it showed
> > > creating a DB connection each time you wanted to access information

> > > stored in a GOODS based DB... is this the suggested method of
> > > retrieving database information?
> > >
> > > Also, is GOODS the only suggested resource for storing DB
> > > information?  I see that there is a Postgre DB client written for
> > > Squeak, I was hoping to be able to use some kind of ORM to be able
> > > to access a different DB than GOODS... is that possible?
> > >
> > > I intend to start on creating a tutorial as part of my learning
> > > experience (I find that writing down how I did things not only
> > > helps others to do the same things, but solidifies my knowledge of
> > > what I'm doing).
> > >
> > > I am going to start out attempting to write my own blog software,
> > > followed by a couple of more complex projects, hopefully
> > > documenting my each step along the way.
> > >
> > > However, I am at a loss as far as DB connectivity goes... can
> > > anyone point me to a guide on this, or give me a few pointers on
> > > how I should be accomplishing it?
> > > _______________________________________________
> > > Seaside mailing list
> > > [hidden email]
> > >
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> >
> > _______________________________________________
> > Seaside mailing list
> > [hidden email]
> >
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> >
>
>
>
> --
> Rajeev Lochan

>
> Co-founder, AR-CAD.com
>
> http://www.ar-cad.com
> +91 9212090622 (Gurgaon)
> 080 65355873 (Bangalore)
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>
>

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

RE: Database

Ramon Leon-5
> * Glorp / Postgres
> I'm just starting to test this, but it seems to run _real_ fast.
> It is A LOT more work to do the initial set up (OR mappings).

Not necessarily

http://onsmalltalk.com/programming/smalltalk/a-smalltalk-activerecord-using-
magritte-seaside-and-glorp/

Ramon Leon
http://onsmalltalk.com

_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
Reply | Threaded
Open this post in threaded view
|

Re: Database

garduino
In reply to this post by Ramiro Diaz Trepat
Very good abstract Ramiro. Thanks!

We wait the next :)

Cheers.


2007/4/16, Ramiro Diaz Trepat <[hidden email]>:

> This is a possible flame generating question.
> I am no "senior member", but I'll tell you my brief experience:
>
>
> OmniBase
> Discard if you intend to use the free version with Squeak.
>
>
> Magma
> Excellent code integration, probably the most elegant of all.
> Can run as server and client images separately.
> Has a great query language that no one else has
> Has special classes for large collections that you can create indexes to
> specific attributes
> Has programmable ReadStrategies
> Has excellent support from its creator Chris Muller, and the list.
> The bad thing: It is a bit too slow.  Both for inserting and for querying,
> even on mid sized collections (a few thousand elements) with indexes and
> optimal read strategies can still be pretty slow.
>
> Glorp / Postgres
> I'm just starting to test this, but it seems to run _real_ fast.
> It is A LOT more work to do the initial set up (OR mappings).
>
> On 4/16/07, Rajeev Lochan < [hidden email]> wrote:
> > Dear Members,
> > Even I was interested in knowing the pros and cons of these DBs. It would
> be
> > great if senior members post with the advantages of Magma or Goods over
> one
> > another.
> >
> > Regards,
> > Rajeev
> >
> >
> >
> >
> >  On 4/17/07, Todd Blanchard <[hidden email]> wrote:
> > > Lots of people are using postgres with glorp.
> > >
> > > -Todd Blanchard
> > >
> > > On Apr 16, 2007, at 10:43 AM, Luke Ivers wrote:
> > >
> > > > In the one place I really found any in depth-information, it showed
>  > > > creating a DB connection each time you wanted to access information
> > > > stored in a GOODS based DB... is this the suggested method of
> > > > retrieving database information?
> > > >
> > > > Also, is GOODS the only suggested resource for storing DB
> > > > information?  I see that there is a Postgre DB client written for
> > > > Squeak, I was hoping to be able to use some kind of ORM to be able
> > > > to access a different DB than GOODS... is that possible?
> > > >
> > > > I intend to start on creating a tutorial as part of my learning
> > > > experience (I find that writing down how I did things not only
> > > > helps others to do the same things, but solidifies my knowledge of
> > > > what I'm doing).
> > > >
> > > > I am going to start out attempting to write my own blog software,
> > > > followed by a couple of more complex projects, hopefully
> > > > documenting my each step along the way.
> > > >
> > > > However, I am at a loss as far as DB connectivity goes... can
> > > > anyone point me to a guide on this, or give me a few pointers on
> > > > how I should be accomplishing it?
> > > > _______________________________________________
> > > > Seaside mailing list
> > > > [hidden email]
> > > >
> >
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> > >
> > > _______________________________________________
> > > Seaside mailing list
> > > [hidden email]
>  > >
> >
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> > >
> >
> >
> >
> > --
>  > Rajeev Lochan
> >
> > Co-founder, AR-CAD.com
> >
> > http://www.ar-cad.com
> > +91 9212090622 (Gurgaon)
> > 080 65355873 (Bangalore)
> > _______________________________________________
>
> > Seaside mailing list
> > [hidden email]
> >
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> >
> >
>
> _______________________________________________
> Seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>
>


--
Germán S. Arduino
http://www.arsol.biz
http://www.arsol.net
_______________________________________________
Seaside mailing list
[hidden email]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside