is Django right choice for a financial app

[kk]

The said project is an enterprise accounting (book keeping ) system.
It is not mere dynamic content such as that served by news rooms (the
very foundation of Django's origin ).
It is going to be lot of dynamic views which actually have to
conditionally serve ad-hock dynamic data.
It will also be used at point of sails counters for example in trade
fairs and malls.
So is Django good enough for such development?
We are used to using sqlalchemy and would want to continue the same for ORM.
Happy hacking.
Krishnakant

[bobhaugen]

On Sunday, October 11, 2015 at 10:33:03 PM UTC-5, krmane wrote:

The said project is an enterprise accounting (book keeping ) system. 
It is not mere dynamic content such as that served by news rooms (the 
very foundation of Django's origin ). 
It is going to be lot of dynamic views which actually have to 
conditionally serve ad-hock dynamic data. 

We're doing the equivalent of an ERP system in django.

https://github.com/valnet/valuenetwork

The django backend works great, and has handled probably more complex processing than you will do. Or at least, very complex, like event-driven MRP. It also does multi-party accounting.

Main problem we have is that complex pages with lots of django forms get way too slow. We plan to use django-restframework to create an API which will be consumed by something like React in the browser. 

We use the django ORM, not sqlalchemy, but that would probably just make it all better.

[kk]

On Monday 12 October 2015 08:06 PM, bobhaugen wrote:

On Sunday, October 11, 2015 at 10:33:03 PM UTC-5, krmane wrote:

The said project is an enterprise accounting (book keeping ) system. 
It is not mere dynamic content such as that served by news rooms (the 
very foundation of Django's origin ). 
It is going to be lot of dynamic views which actually have to 
conditionally serve ad-hock dynamic data. 

We're doing the equivalent of an ERP system in django.

https://github.com/valnet/valuenetwork

Wow that's interesting.
I guess ERP needs scalability and Django is good at that.

The django backend works great, and has handled probably more complex processing than you will do. Or at least, very complex, like event-driven MRP. It also does multi-party accounting.

Ic.

Main problem we have is that complex pages with lots of django forms get way too slow. We plan to use django-restframework to create an API which will be consumed by something like React in the browser.

Well We are actually planning to use REST based services.
But I did not get the react concept.

We use the django ORM, not sqlalchemy, but that would probably just make it all better.

Oh is that so?
How about baked queries in sqlalchemy where queries from Python code are already byte compiled?
How about the SA expression language?
So far as what I herd, SQLAlchemy is more performant and fast than sqlobject?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c4d38614-621c-4cc2-ad74-2e4744725fc8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[bobhaugen]

krmane, google is misbehaving and will not allow me to reply to your reply to me, so I'll fake it and do some cutnpasting.

You wrote:

>  I did not get the react concept.

https://facebook.github.io/react/

I wrote:

We use the django ORM, not sqlalchemy, but that would probably just make it all better.

And you replied: Oh is that so?

And now I am stuck in a box. But anyway, I think my comment miscommunicated. I meant sqlalchemy would probably make it better.

[James Schneider]

> The said project is an enterprise accounting (book keeping ) system.
> It is not mere dynamic content such as that served by news rooms (the very foundation of Django's origin ).
> It is going to be lot of dynamic views which actually have to conditionally serve ad-hock dynamic data.

As long as you can coerce the data into Django models (preferred), Python objects/dicts/lists, or have some function that returns the data in a sane serialized manner such as JSON/XML, that shouldn't be an issue. That's pretty much how all web apps work.

> It will also be used at point of  sails counters for example in trade fairs and malls.

Here is where you'll run into trouble. PoS systems usually need to be able to run in a standalone mode due to a lack of connectivity. Django is not meant to be run directly on the client side (although I suppose it could be). Without connectivity back to the Django server, the clients need some way to store transactions locally and upload them later. A web application is not ideal in this scenario. You would need to develop a local PoS app (perhaps in Python directly) that knows how to communicate with Django as connectivity is available, usually via an API that you would write in Django that the app knows how to use.

You also need to be careful with the data that is traversing your system. Not sure what country you are in, but in the US, PoS systems are required to adhere to strict guidelines when accepting payments, even if it isn't stored within your system. If any sort of electronic payment card hits your app, you're probably subject to those regulations. Check with your legal and information security team before accepting payments.

> So is Django good enough for such development?

Yes and no for the reasons above.

> We are used to using sqlalchemy and would want to continue the same for ORM.

I believe there is 3rd party support for SQLAlchemy as a plugin for Django, but not officially out of the box. I'm not familiar with any packages to provide further comment, but they definitely exist.

> Happy hacking.
> Krishnakant
>

That's the last thing you want to say around a PoS system. :-P

If you have doubts, I would recommend you run through the tutorial and try it out yourself to get a better feel for its capabilities.

-James

[kk]

--

I see, I am sorry I could not read it properly.
I use a screen reader because I am totally blind.
I guess it did not read things properly in a way that associated lines correctly.
I know for sure sqlalchemy is more performant so was thinking.
happy hacking.
Krishnakant.

[Avraham Serour]

Sqlalchemy is more performant? In what way? Do you have any reference or this was from personal experience?

--

You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/561C2FEF.8030800%40gmail.com.

[kk]

hello,

On Tuesday 13 October 2015 04:09 AM, Avraham Serour wrote:

Sqlalchemy is more performant? In what way? Do you have any reference or this was from personal experience?

Personal experience and some online reviews.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFWa6tLcxawEHaSAvGsaUBpKDEq2O%2BWHZ-KoTPqtVsbuhUZs7w%40mail.gmail.com.

[Avraham Serour]

well if you have online reviews stating or showing that sqlalchemy is faster than django ORM, than this is exactly what I'm asking you to post, it would be an interesting read

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/561C6B73.4090301%40gmail.com.