Re: D need an ORM library!

2018-08-22 Thread Russel Winder via Digitalmars-d-learn
On Wed, 2018-08-22 at 06:14 +, binghoo dang via Digitalmars-d-learn 
wrote:
[…]
> yeah, Diamond is great, but I think it will be more wonderful if 
> it's database ORM can be separated to a standalone project, 
> that's would be useful for the application that's is not WEB 
> oriented but need an ORM.

Possibly, but possibly not. Django has an ORM, but SQLAlchemy happened
as well.

-- 
Russel.
===
Dr Russel Winder  t: +44 20 7585 2200
41 Buckmaster Roadm: +44 7770 465 077
London SW11 1EN, UK   w: www.russel.org.uk



signature.asc
Description: This is a digitally signed message part


Re: D need an ORM library!

2018-08-22 Thread bauss via Digitalmars-d-learn

On Wednesday, 22 August 2018 at 06:14:40 UTC, binghoo dang wrote:

On Tuesday, 21 August 2018 at 10:48:30 UTC, bauss wrote:

Currently (When I get time again) working on implementing 
PostgreSQL and Sqlite support for Diamond.


Mysql and Mssql should work out the box.

https://github.com/DiamondMVC/Diamond

Some examples will come later, unless you use the latest 
stable version of Diamond then you have examples for MySql, 
but the implementation changes with the next release.


http://diamondmvc.org/docs/data/#database

I wouldn't call it light-weight like you explain, because it 
does have the whole framework, but you could technically just 
strip out the part of compile it with the appropriate flags to 
exclude the parts you don't need like the webserver.


Else take a look at https://github.com/buggins/hibernated and 
perhaps https://github.com/buggins/ddbc is enough.


yeah, Diamond is great, but I think it will be more wonderful 
if it's database ORM can be separated to a standalone project, 
that's would be useful for the application that's is not WEB 
oriented but need an ORM.


Diamond works without web though. You can disable all web 
features and simply just import the modules for the orm etc.


The ORM was used to be standalone, but became a huge dependency, 
so was just integrated into it.


I would suggest


Re: D need an ORM library!

2018-08-22 Thread bauss via Digitalmars-d-learn

On Wednesday, 22 August 2018 at 09:33:26 UTC, bauss wrote:

I would suggest


Accidentally pressed "Send", but as I was saying.

I would suggest https://github.com/buggins/hibernated as an 
alternative.


Re: D need an ORM library!

2018-08-22 Thread binghoo dang via Digitalmars-d-learn

On Tuesday, 21 August 2018 at 08:22:34 UTC, Russel Winder wrote:

If there was a D version of SQLAlchemy, that would be 
wonderful. Feel free to s/TBA/Russel Winder/


Great! there are many people waiting for this! ^_^


Re: D need an ORM library!

2018-08-22 Thread binghoo dang via Digitalmars-d-learn

On Tuesday, 21 August 2018 at 10:48:30 UTC, bauss wrote:

Currently (When I get time again) working on implementing 
PostgreSQL and Sqlite support for Diamond.


Mysql and Mssql should work out the box.

https://github.com/DiamondMVC/Diamond

Some examples will come later, unless you use the latest stable 
version of Diamond then you have examples for MySql, but the 
implementation changes with the next release.


http://diamondmvc.org/docs/data/#database

I wouldn't call it light-weight like you explain, because it 
does have the whole framework, but you could technically just 
strip out the part of compile it with the appropriate flags to 
exclude the parts you don't need like the webserver.


Else take a look at https://github.com/buggins/hibernated and 
perhaps https://github.com/buggins/ddbc is enough.


yeah, Diamond is great, but I think it will be more wonderful if 
it's database ORM can be separated to a standalone project, 
that's would be useful for the application that's is not WEB 
oriented but need an ORM.


Re: D need an ORM library!

2018-08-21 Thread bauss via Digitalmars-d-learn

On Monday, 20 August 2018 at 02:30:16 UTC, binghoo dang wrote:

hi,

I thinks D need an ORM library for Sqlite/Mysql/PostgreSQL, 
entity currently support all the three targets, but entity's 
API is too complex and cumbersome for using.


Is there a more light-weight and simpler implementation like 
ActiveAndroid ?


Thanks!


---

Binghoo Dang


Currently (When I get time again) working on implementing 
PostgreSQL and Sqlite support for Diamond.


Mysql and Mssql should work out the box.

https://github.com/DiamondMVC/Diamond

Some examples will come later, unless you use the latest stable 
version of Diamond then you have examples for MySql, but the 
implementation changes with the next release.


http://diamondmvc.org/docs/data/#database

I wouldn't call it light-weight like you explain, because it does 
have the whole framework, but you could technically just strip 
out the part of compile it with the appropriate flags to exclude 
the parts you don't need like the webserver.


Else take a look at https://github.com/buggins/hibernated and 
perhaps https://github.com/buggins/ddbc is enough.


Re: D need an ORM library!

2018-08-21 Thread Russel Winder via Digitalmars-d-learn
On Tue, 2018-08-21 at 01:42 +, binghoo dang via Digitalmars-d-learn 
wrote:
[…]
> 
> SQLAlchemy is very great, and I remember that  
> in D wiki has mentioned this, but the status is "Proposed Project 
> Mentors: TBA".

SQLAlchemy is how SQL building and ORM should be done, in Python. For
other programming languages it has to be an inspiration, but not used
as a template for an API – different languages encourage different
idiomatic solutions to the same problem. I know of a C++11 variant that
had the same approach as SQLAlchemy but done in C++1 idiomatic style,
but then I stopped using C++. I haven't looked for a Rust version yet,
but I am hoping one is there.

If there was a D version of SQLAlchemy, that would be wonderful. Feel
free to s/TBA/Russel Winder/

-- 
Russel.
===
Dr Russel Winder  t: +44 20 7585 2200
41 Buckmaster Roadm: +44 7770 465 077
London SW11 1EN, UK   w: www.russel.org.uk



signature.asc
Description: This is a digitally signed message part


Re: D need an ORM library!

2018-08-20 Thread binghoo dang via Digitalmars-d-learn

On Monday, 20 August 2018 at 23:24:04 UTC, Matthias Klumpp wrote:

On Monday, 20 August 2018 at 15:58:37 UTC, Jesse Phillips wrote:

[...]

There are a number of things out there, but personally don't 
know there state or simplicity.


2016 there was a talk: http://dconf.org/2016/talks/nowak.html

But personally I preferred this one: 
http://dconf.org/2016/talks/smith.html

https://github.com/cruisercoder/dstddb


This all looks very dead. Is there any project still alive? The 
only effort that still seems to be actively developed as far as 
I can see is hunt-entity...


And I agree, SQLAlchemy is pretty great!


yeah, Only entity is likely a living ORM implementation in D. 
But, it's API is too complicated, and API is not stable from my 
experience.


SQLAlchemy is very great, and I remember that  
in D wiki has mentioned this, but the status is "Proposed Project 
Mentors: TBA".


Re: D need an ORM library!

2018-08-20 Thread Matthias Klumpp via Digitalmars-d-learn

On Monday, 20 August 2018 at 15:58:37 UTC, Jesse Phillips wrote:

[...]

There are a number of things out there, but personally don't 
know there state or simplicity.


2016 there was a talk: http://dconf.org/2016/talks/nowak.html

But personally I preferred this one: 
http://dconf.org/2016/talks/smith.html

https://github.com/cruisercoder/dstddb


This all looks very dead. Is there any project still alive? The 
only effort that still seems to be actively developed as far as I 
can see is hunt-entity...


And I agree, SQLAlchemy is pretty great!


Re: D need an ORM library!

2018-08-20 Thread Russel Winder via Digitalmars-d-learn
On Mon, 2018-08-20 at 15:58 +, Jesse Phillips via Digitalmars-d-
learn wrote:
> On Monday, 20 August 2018 at 02:30:16 UTC, binghoo dang wrote:
> > hi,
> > 
> > I thinks D need an ORM library for Sqlite/Mysql/PostgreSQL, 
> > entity currently support all the three targets, but entity's 
> > API is too complex and cumbersome for using.

Can I suggest that SQLAlchemy is excellent. It has the full on ORM for
those that want it, but also an expression language so you do not have
to write SQL in strings if you are not using the ORM. 

Being able to write Python that generated SQL (Builder pattern) has
made working with SQLite almost a joy.

> > Is there a more light-weight and simpler implementation like 
> > ActiveAndroid ?
> > 
> > Thanks!
> > 
> > 
> > ---
> > 
> > Binghoo Dang
> 
> There are a number of things out there, but personally don't know 
> there state or simplicity.
> 
> 2016 there was a talk: http://dconf.org/2016/talks/nowak.html
> 
> But personally I preferred this one: 
> http://dconf.org/2016/talks/smith.html
> https://github.com/cruisercoder/dstddb
-- 
Russel.
===
Dr Russel Winder  t: +44 20 7585 2200
41 Buckmaster Roadm: +44 7770 465 077
London SW11 1EN, UK   w: www.russel.org.uk



signature.asc
Description: This is a digitally signed message part


Re: D need an ORM library!

2018-08-20 Thread Jesse Phillips via Digitalmars-d-learn

On Monday, 20 August 2018 at 02:30:16 UTC, binghoo dang wrote:

hi,

I thinks D need an ORM library for Sqlite/Mysql/PostgreSQL, 
entity currently support all the three targets, but entity's 
API is too complex and cumbersome for using.


Is there a more light-weight and simpler implementation like 
ActiveAndroid ?


Thanks!


---

Binghoo Dang


There are a number of things out there, but personally don't know 
there state or simplicity.


2016 there was a talk: http://dconf.org/2016/talks/nowak.html

But personally I preferred this one: 
http://dconf.org/2016/talks/smith.html

https://github.com/cruisercoder/dstddb


D need an ORM library!

2018-08-19 Thread binghoo dang via Digitalmars-d-learn

hi,

I thinks D need an ORM library for Sqlite/Mysql/PostgreSQL, 
entity currently support all the three targets, but entity's API 
is too complex and cumbersome for using.


Is there a more light-weight and simpler implementation like 
ActiveAndroid ?


Thanks!


---

Binghoo Dang