www.digitalmars.com         C & C++   DMDScript  

digitalmars.D - Database developer's gentle view on D.

reply bls <bizprac orange.fr> writes:
Not that you really need it.
Things move forward. Phobos becomes more and more reliable and usable, 
It seems that the accepting "Foreign modules/Fixes situation" is better 
than ever.  So it looks like things went into the right direction.... 
unfortunately not for me.

Let  me tell you in a second or two about my world.
Creating huge database based multinational applications   (likewise 
multinational/lingual Accounting - Order Sys.)

As said, I have to create Database applications,  consuming SOAP 
respective REST Services. Targets are Desktop(WIN only), WEB and Smart 
Devices. All of them have to interop.

So why not using D ? (Which I would like to do)

DB Support..
    Not yet available. In case that Steve Teale (and he did a dammed 
good Job, as well as Piotr) will add std.database this will not change 
the situation significantly. 'Cause std.database will contain just 
rudimentary DB support..  A Database independent, ORM based library 
module is not even matter of discussion. That's a  pity.

GUI..
     Well for us Windoze is the only interesting Desktop platform.
A _reasonable_ GUI is not available yet.(D-GUI looks pretty good,though)
WEB Development is for sure doable in D, reusable Frameworks are 
nevertheless AFAIK not available.

Smart Device Development..
    (Win 7 mobile/ Android/ IOS ) GDC for rescue ? On Android D To Java ?

Consuming SOAP/REST..
  ATM std.XML is not really perfect. So going a step ahead and asking 
for parsing WSDL files to generate appropriate D code would not make too 
much sense.
Further : Some Services require Certificate authentication. Another  No 
Go. No Crypto lib.

Don't get me wrong, I like D!  Otherwise I would not have followed  D 
for meanwhile 5-6 years.

Without having an DB-Object Relational Mapper, Crypt/Decrypt- extended 
XML support, PDF creation, Reporting, and XML related tools and (mucho 
importante) localization support,  D is not an option for us  --at the 
moment.

  So ... Being a bit enthusiastic about D's progress ? Sure!
  Leaving the planet, went to outer space with a  D Type _2_ Rocket made 
by BOING engineer W.B. ?    Risky ;)

A+
Bjoern
Dec 31 2011
next sibling parent reply Gour <gour atmarama.net> writes:
On Sat, 31 Dec 2011 20:28:43 -0800
bls <bizprac orange.fr> wrote:


 A Database independent, ORM based library module is not even matter of
 discussion. That's a  pity.


That would be nice, indeed.


 Well for us Windoze is the only interesting Desktop platform.
 A _reasonable_ GUI is not available yet.(D-GUI looks pretty
 good,though)=20


What is D-GUI, gtkD or DWT?


Sincerely,
Gour


--=20
As a strong wind sweeps away a boat on the water,=20
even one of the roaming senses on which the mind=20
focuses can carry away a man's intelligence.

http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810
Dec 31 2011
parent reply Jimmy Cao <jcao219 gmail.com> writes:
2012/1/1 Gour <gour atmarama.net>


 On Sat, 31 Dec 2011 20:28:43 -0800
 bls <bizprac orange.fr> wrote:


 A Database independent, ORM based library module is not even matter of
 discussion. That's a  pity.


 That would be nice, indeed.


 Well for us Windoze is the only interesting Desktop platform.
 A _reasonable_ GUI is not available yet.(D-GUI looks pretty
 good,though)


 What is D-GUI, gtkD or DWT?


dgui:

http://code.google.com/p/dgui/

GUI library for Windows.  Pretty easy to use.

-

gtkD and dwt2 are cross-platform GUI libraries for D.

http://www.dsource.org/projects/gtkd

https://bitbucket.org/torhus/dwt2
Jan 01 2012
next sibling parent Gour <gour atmarama.net> writes:
On Sun, 1 Jan 2012 02:22:59 -0600
Jimmy Cao <jcao219 gmail.com> wrote:


 GUI library for Windows.  Pretty easy to use.


Thank you, but not interesting for us looking for multi-platform
library.


Sincerely,
Gour


--=20
Those persons who execute their duties according to My injunctions=20
and who follow this teaching faithfully, without envy, become free=20
from the bondage of fruitive actions.

http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810
Jan 01 2012
prev sibling parent reply bls <bizprac orange.fr> writes:
On 01/01/2012 12:22 AM, Jimmy Cao wrote:

 GUI library for Windows.  Pretty easy to use.


... and should be named Forms4D

I definitely like this library. Pretty straight OOP, Each DOTNET Forms 
developer will immediately  feel at home. New liberal license. Just cool!
Jan 02 2012
parent "Regan Heath" <regan netmail.co.nz> writes:
On Mon, 02 Jan 2012 17:16:13 -0000, bls <bizprac orange.fr> wrote:


 On 01/01/2012 12:22 AM, Jimmy Cao wrote:

 GUI library for Windows.  Pretty easy to use.


 ... and should be named Forms4D





 I definitely like this library. Pretty straight OOP, Each DOTNET Forms  
 developer will immediately  feel at home. New liberal license. Just cool!


Cool, I should take a look at it :)

R

-- 
Using Opera's revolutionary email client: http://www.opera.com/mail/
Jan 04 2012
prev sibling next sibling parent reply Steve Teale <steve.teale britseyeview.com> writes:
On Sat, 31 Dec 2011 20:28:43 -0800, bls wrote:


     Not yet available. In case that Steve Teale (and he did a dammed
 good Job, as well as Piotr) will add std.database this will not change
 the situation significantly. 'Cause std.database will contain just
 rudimentary DB support..  A Database independent, ORM based library
 module is not even matter of discussion. That's a  pity.
 
 


Bjoern,

Even being retired does not mean there's nothing else to do but D library 
components. I didn't get back to you yet because I'm busy making 
furniture for our expanding little enterprise here, and because of the 
holidays, and because I need to lose a few kilos off the belly that 
magically appeared while I was doing nothing but sit in front of a 
keyboard.

Also I'd say for rudimentary I'd want to say basic. There's a slight 
difference.

I'll be back.

Steve

But don't put the database stuff
Jan 01 2012
next sibling parent bls <bizprac orange.fr> writes:
On 01/01/2012 07:02 AM, Steve Teale wrote:

 On Sat, 31 Dec 2011 20:28:43 -0800, bls wrote:


      Not yet available. In case that Steve Teale (and he did a dammed
 good Job, as well as Piotr) will add std.database this will not change
 the situation significantly. 'Cause std.database will contain just
 rudimentary DB support..  A Database independent, ORM based library
 module is not even matter of discussion. That's a  pity.


 Bjoern,

 Even being retired does not mean there's nothing else to do but D library
 components. I didn't get back to you yet because I'm busy making
 furniture for our expanding little enterprise here, and because of the
 holidays, and because I need to lose a few kilos off the belly that
 magically appeared while I was doing nothing but sit in front of a
 keyboard.

 Also I'd say for rudimentary I'd want to say basic. There's a slight
 difference.

 I'll be back.

 Steve

 But don't put the database stuff


Hi Steve,
first of all: A happy and successful new year to you!

What makes me a bit nervous is the use of structures in your source.
In case that your goal is to establish a D database access standard, 
client and server wise, Interfaces are the way to go.

Well, isn't  the right of the youth to be impatient :) (I am just 50)

So I am waiting for your feedback regarding the link I've send you. In 
my (in this case not so humble opinion) following this Design would make 
much sense.
Kind regards, Bjoern
Jan 02 2012
prev sibling next sibling parent Walter Bright <newshound2 digitalmars.com> writes:
On 1/1/2012 7:02 AM, Steve Teale wrote:

 Even being retired does not mean there's nothing else to do but D library
 components.


Steve,

Happy New Year!

Now get back to work! <g>
Jan 02 2012
prev sibling parent sclytrack <sclytrack fake.com> writes:
On 01/01/2012 04:02 PM, Steve Teale wrote:

 On Sat, 31 Dec 2011 20:28:43 -0800, bls wrote:


      Not yet available. In case that Steve Teale (and he did a dammed
 good Job, as well as Piotr) will add std.database this will not change
 the situation significantly. 'Cause std.database will contain just
 rudimentary DB support..  A Database independent, ORM based library
 module is not even matter of discussion. That's a  pity.


 Bjoern,

 Even being retired does not mean there's nothing else to do but D library
 components. I didn't get back to you yet because I'm busy making
 furniture for our expanding little enterprise here, and because of the
 holidays, and because I need to lose a few kilos off the belly that
 magically appeared while I was doing nothing but sit in front of a
 keyboard.

 Also I'd say for rudimentary I'd want to say basic. There's a slight
 difference.

 I'll be back.

 Steve

 But don't put the database stuff


	Could the result type of the query be

	Variant [][][string] resultSet;

	... and the string would be something like.

	"data"	 //original data returned by the query
	"changed"
	"columnNames"

	"bgColor"

	or does it need something more specialised?
Jan 06 2012
prev sibling next sibling parent reply "Adam D. Ruppe" <destructionator gmail.com> writes:
On Sunday, 1 January 2012 at 04:28:45 UTC, bls wrote:

 WEB Development is for sure doable in D, reusable Frameworks 
 are nevertheless AFAIK not available.


What kind of features did you have in mind for this?
Jan 01 2012
parent reply bls <bizprac orange.fr> writes:
On 01/01/2012 10:49 AM, Adam D. Ruppe wrote:

 On Sunday, 1 January 2012 at 04:28:45 UTC, bls wrote:

 WEB Development is for sure doable in D, reusable Frameworks are
 nevertheless AFAIK not available.


 What kind of features did you have in mind for this?


Hi Adam,
first of all: A happy and successful new year to you!
To answer your question  :
An SaaS application living in a Cloud-Space, preferred atm is Amazon EC. 
The database Back-End will be (most probably PostGreSQL)
WHY PostGres ? Callback notifications/ Server-side events ... not 
available in MySQL. (which you prefer in your framework)


The challenge for us is SaaS user management.
Due to the fact that we are supporting small companies(1-5 users) as 
well as huge,international acting companies the Saas Software has to scale.
I.E. From : "I would give your Software a try. We need just the basic 
package" ... to "We want it all (and more); We are looking for a long 
term contract" .
In detail this means we have customers who wish to rent just PARTs OF 
OUR SOFTWARE for a month, others would like to rent our Software for a 
year, including all features.

SOAP/REST  is (in our case) needed to f.i. obtain prices. (https 
tunneling seems to be good enough (tm) )The other need for SOAP/REST (I 
am not sure if should go this way) is to access the SaaS application to 
receive certain informations/to add an potential clients, reuests, what 
the heck. ) In this case we have to establish a WSDL/REST - maybe oData 
Service.  (I would  prefer REST)

---Still have a hangover from new years day, so that's it 4 the moment.

Indeed, I had your library in mind while talking about D for the WEB.
Bjoern
Jan 02 2012
parent "Adam D. Ruppe" <destructionator gmail.com> writes:
On Monday, 2 January 2012 at 16:21:16 UTC, bls wrote:

 WHY PostGres ? Callback notifications/ Server-side events ... 
 not available in MySQL. (which you prefer in your framework)


Aye, I've done some postgres, but since my main work app
uses mysql I haven't spent a lot of time on it.

While basic queries I'm pretty sure work right, I haven't used
any of the more advanced features (partially because mysql doesn't
have any).


 SOAP/REST  is (in our case) needed to f.i. obtain prices. 
 (https tunneling seems to be good enough (tm) )The other need 
 for SOAP/REST (I am not sure if should go this way) is to 
 access the SaaS application to receive certain informations/to 
 add an potential clients, reuests, what the heck. ) In this 
 case we have to establish a WSDL/REST - maybe oData Service.


Right now, I think this could be done with my stuff, but it
doesn't really exist yet.

There's http api like things available in web.d, but it isn't
SOAP or have WSDL... again, it just hasn't come up for me.


I was replacing php with D more than replacing Java :)



It's slowly growing though! As stuff comes up that I
need for me, I'll write it.
Jan 04 2012
prev sibling parent Dejan Lekic <dejan.lekic gmail.com> writes:
Nobody stops you to fill the gap with your own code...

-- 
Dejan Lekic - http://dejan.lekic.org
Jan 04 2012