Are there packages for accessing SQL databases from Amber Smalltalk?

[Michael Burns]

I've got a couple of large SQL databases I want to access from an amber project.   I've been googling around and not finding much.  It gets confusing because Google finds a bunch of other things named amber.   Is there a general index of Amber packages I can browse? 

Background:  I've been a fan of Smalltalk since the early 80's and have used a. number of other OO languages (most notably Java).  I'm relatively new to Pharo and Amber smalltalk so I'm just getting started.  

Pointers generally or direct pointers to projects that have accessed SQL data? 

[Siemen Baader]

Hi Michael,

I am not aware of any SQL packages or a general package repo for Amber, but is SQL+Amber really what you want to use? Amber is compiled to JS, so it makes most sense to use it for web frontends / SPAs. You can use Amber on NodeJS, but on a server where you can choose your runtime, you'll most likely be better off using Pharo because it has a better IDE, dynamic programming features and real Smalltalk libraries. On Pharo, you eg have https://github.com/svenvc/P3 for SQL, but again, perhaps you want to use a document oriented database like Voyage because you won't have to evolve a DB schema as your domain models evolve.

There is also PharoJS for cross-compiling Pharo to a JS runtime which is actively maintained, but is used to be buggy and undocumented for a long time, so it can be a head-scratching experience.

What are your goals? Personally I'm very happy with Iliad - https://iliadproject.github.io/ - for responsive / AJAX web apps and real Pharo coding server-side. But it needs to be ported to recent Pharos.

HTH

Siemen

--
You received this message because you are subscribed to the Google Groups "amber-lang" group.
To unsubscribe from this group and stop receiving emails from it, send an email to amber-lang+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/amber-lang/5e9938cb-bf14-4bcb-8921-5349a5c4be7dn%40googlegroups.com.