Author: Camil Ghircoias
Posted: 2013-03-27 02:07:28 Link
Hi,
I’m a vfp developer now working with postgresql as a main database.
I’m looking to move my apps (accounting, sales,salary software mainly) into web.
For the client part I was looking for some web platforms like sencha-ext js for web forms (looks nice, like desktop), but on the server side I didn’t found anything good enough.
I’d like a scripting language and python looks a good one, but need more for database and local cursors support. And reports of course.
Not sure if dabo class can be used as a scripting language on the server side to prepare data for the client in json formats or xml for the client.
And the most important, can I design reports into dabo and render them on server side into pdf using dabo so the resulting pdf could be send to client ?
>From what I found on dabo side it is designed mainly for desktop apps not as a web scripting service
Thanks,
Camil Ghircoias
camil.ghircoias@info-expert.ro
www.info-expert.ro
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/7C4BB7C86DF14D01962C3B7E3E18336D@statie2
Author: John Fabiani
Posted: 2013-03-28 12:47:43 Link
In general Dabo is a desktop framework. That said, Ed did create a
webservice of sorts.
For the web, most python developers are using dJango.
As far as the PDF's you want there are several ways to get that done.
I'll guess and say the Dabo's reporting tools would work just fine. I
use the reporting tools to create PDF's in cron batch jobs all the
time. IOW you can use the tools on the server side without any really
issues and without using the graphical desktop stuff.
Johnf
On 03/27/2013 12:07 AM, Camil Ghircoias wrote:
> Hi,
>
> I’m a vfp developer now working with postgresql as a main database.
> I’m looking to move my apps (accounting, sales,salary software mainly) into web.
> For the client part I was looking for some web platforms like sencha-ext js for web forms (looks nice, like desktop), but on the server side I didn’t found anything good enough.
> I’d like a scripting language and python looks a good one, but need more for database and local cursors support. And reports of course.
> Not sure if dabo class can be used as a scripting language on the server side to prepare data for the client in json formats or xml for the client.
> And the most important, can I design reports into dabo and render them on server side into pdf using dabo so the resulting pdf could be send to client ?
> >From what I found on dabo side it is designed mainly for desktop apps not as a web scripting service
>
>
> Thanks,
> Camil Ghircoias
> camil.ghircoias@info-expert.ro
> www.info-expert.ro
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
> _______________________________________________
> Post Messages to:Dabo-users@leafe.com
> Subscription Maintenance:http://mail.leafe.com/mailman/listinfo/dabo-users
> Searchable Archives:http://leafe.com/archives/search/dabo-users
> This message:http://leafe.com/archives/byMID/7C4BB7C86DF14D01962C3B7E3E18336D@statie2
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/5154823F.50106@jfcomputer.com
Author: Paul McNett
Posted: 2013-03-29 08:45:21 Link
On 3/27/13 12:07 AM, Camil Ghircoias wrote:
> I’m a vfp developer now working with postgresql as a main database.
Welcome!
> I’m looking to move my apps (accounting, sales,salary software mainly) into web.
Ok; Dabo's a cross-platform desktop application framework, not a web framework.
> For the client part I was looking for some web platforms like sencha-ext js for web forms (looks nice, like desktop)
IMO trying to get the desktop onto the web is shooting yourself in the foot. But I'll
leave it at that. :)
> , but on the server side I didn’t found anything good enough. I’d like a scripting language and python looks a good one,
Yes, Python is a great scripting language with lots of libraries built-in and
available from third-parties to solve almost every class of problem. There are very
popular web frameworks like Django, libraries to run your Python from Apache or other
webservers (wsgi), libraries to give your Django or other web application a REST web
service api (tastypie), and plus you can just run Python scripts on the server via
cron jobs, etc.
> but need more for database and local cursors support.
Here's the thing. You are coming from VFP and are thus used to holding a local cursor
open, maybe for the entire time the app is running. How are you going to achieve that
over the web? If you need statefulness, you are basically forced to choose between:
1) Set up an application server to maintain state for x number of cursors for y
number of instances for z number of users. And this server will need to figure out
when it can safely kill its state because the user has logged off or been inactive
for a while.
2) Maintain state on the client side, which is problematic due to security
restrictions in the browser/os.
The world is definitely moving to a web paradigm but you really have to embrace it
100% and not try to jack it up by introducing needless statefulness into it.
I think business applications of a certain complexity still belong predominantly on
the desktop, not the web. For the type of application where a user logs in and does
data entry and reporting all day, that belongs on the desktop for speed, stability,
and security.
> And reports of course.
Dabo's reports are xml and are easily designed in the desktop ReportDesigner. The
runtime reportwriter doesn't need to be on the desktop, and outputs PDF to a file or
stream. Thus you could put this on your webserver, run it from a script, etc.
> Not sure if dabo class can be used as a scripting language on the server side to prepare data for the client in json formats or xml for the client.
I could see this working, but I've never done it. Apache/mod_wsgi -> your dabo bizobj
-> wrapped in tastypie -> output json or xml
> And the most important, can I design reports into dabo and render them on server side into pdf using dabo so the resulting pdf could be send to client ?
Yes. You'd need to design the reports using the desktop ReportDesigner however, if
you don't want to craft them by hand using Python or XML.
>>From what I found on dabo side it is designed mainly for desktop apps not as a web scripting service
Correct.
Again, welcome.
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/51559AF1.30103@ulmcnett.com
Author: Vineet Deodhar
Posted: 2013-03-30 23:50:02 Link
>
> From: "Camil Ghircoias" <camil.ghircoias@yahoo.com>
> To: <dabo-users@leafe.com>
> Subject: [dabo-users] can I design reports into dabo and render them
> on server for web app
> Hi,
>
> I?m a vfp developer now working with postgresql as a main database.
> I?m looking to move my apps (accounting, sales,salary software mainly)
> into web.
>
I have done the same kind of transition using :--
On server, 'Web2py' web framework + 'DABO'
I have used dabo for taking care of database related stuff.
Web2py for other server side tasks such as web-server (btw, it has built-in
web server), controller functions, handling requests & responses, etc.
On client side, of course, no installation is needed; just a compatible web
browser.
Now coming to the task of holding data in cursor-like object at client
side...
My setup is like this--
>From dabo's bizobj, convert data into json format, dispatch it to the
client, At client side, in the browser, there is .data property for html
elements like <div>. This can be used to hold data. This object is mutable.
After making changes to this data, the same object can be sent to the
bizobj at server and persist the data on disk.
If you need a code snippet, I can share it.
I?d like a scripting language and python looks a good one, but need more
> for database and local cursors support.
I have not done speed tests, but python is great in speed.
dabo gives mostly all that functionality available in vfp.
And reports of course.
>
I use html for reports.
HTH,
Vineet.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/CAP5=7opzEF-D9adKiBse2ns=+nzOHoqNr3D4-EWphk2V0J_M5Q@mail.gmail.com
Author: Paul McNett
Posted: 2013-03-31 09:47:31 Link
On 3/30/13 9:50 PM, Vineet Deodhar wrote:
>>From dabo's bizobj, convert data into json format, dispatch it to the
> client, At client side, in the browser, there is .data property for html
> elements like <div>. This can be used to hold data. This object is mutable.
> After making changes to this data, the same object can be sent to the
> bizobj at server and persist the data on disk.
Do you program the javascript directly ?
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/51584C83.1080301@ulmcnett.com
Author: Vineet Deodhar
Posted: 2013-04-01 00:16:35 Link
On 3/30/13 9:50 PM, Vineet Deodhar wrote:
>>From dabo's bizobj, convert data into json format, dispatch it to the
> client, At client side, in the browser, there is .data property for html
> elements like
. This can be used to hold data. This object is mutable.
> After making changes to this data, the same object can be sent to the
> bizobj at server and persist the data on disk.
========================================
Do you program the javascript directly ?
Paul
========================================
I use jquery in web2py 'view' code (MVC pattern) and also inline python scripts.
This gives granular control over the DOM and embedded data.
--- Vineet
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/CAP5=7opptEjgzVRrAPDatckTfGYC9E_BbkoC_ha9sKc4Mu5siA@mail.gmail.com
Author: Paul McNett
Posted: 2013-04-03 16:58:37 Link
On 3/31/13 10:16 PM, Vineet Deodhar wrote:
> On 3/30/13 9:50 PM, Vineet Deodhar wrote:
>> >>From dabo's bizobj, convert data into json format, dispatch it to the
>> > client, At client side, in the browser, there is .data property for html
>> > elements like
> . This can be used to hold data. This object is mutable.
>> > After making changes to this data, the same object can be sent to the
>> > bizobj at server and persist the data on disk.
> ========================================
> Do you program the javascript directly ?
>
> Paul
> ========================================
>
> I use jquery in web2py 'view' code (MVC pattern) and also inline python scripts.
> This gives granular control over the DOM and embedded data.
Vineet,
I and the community would *love it* if you could prepare an example tutorial building
a sample app using these technologies. I'm sure we'd even jump in and help you edit
it to get it published somewhere.
Cheers
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/515CA60D.90905@ulmcnett.com
Author: Vineet Deodhar
Posted: 2013-04-08 00:53:18 Link
>
>
> >I and the community would *love it* if you could prepare an example
> tutorial building
> >a sample app using these technologies. I'm sure we'd even jump in and
> help you edit
> >it to get it published somewhere.
> >
> >Cheers
> >Paul
>
>
Sure.
I will be happy to do so.
BTW, sorry for not replying in time, bcoz I was busy into other work.
--- Vineet
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/CAP5=7orT3Hw+p40ZD9_rG64a0EOnfR0C=oeesLLPdgTNypqYRQ@mail.gmail.com
Author: Camil Ghircoias
Posted: 2013-04-08 09:00:30 Link
Thank you all,
My ideea would be to have a good tool for making a desktop like client
interface (and sencha extjs is good for that) and use json format to send and
get data from the server.
On the server side I need a language with some cursor (like vfp...) support so
to be able to run queries on postgresql database and then work with cursors
(in memory or not) to prepare the jason format. There are situations when the
sql language it is not sufficient and need some extra tools for handle data. I
do not want to have a lot of opened cursors but to be able to do the hard work
with it and then kill them.
So here I came to dabo where I found some vfp paradigms in it.
And reporting it is also important. I do not want to drive back to 90's when
designing reports where similar to writing scripting lines. I need a report
designer that can be rendered on server side and to be able to read data in
some format dabo can give it.
So here I wanted some feedback from people involved. I will try to look more
deep into dabo.
On the internet i looked at solutions but there is not a good platform to
handle all these.
Camil
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/loom.20130408T155145-651@post.gmane.org
Author: John Fabiani
Posted: 2013-04-08 12:50:41 Link
On 04/08/2013 07:00 AM, Camil Ghircoias wrote:
> Thank you all,
>
> My ideea would be to have a good tool for making a desktop like client
> interface (and sencha extjs is good for that) and use json format to send and
> get data from the server.
>
> On the server side I need a language with some cursor (like vfp...) support so
> to be able to run queries on postgresql database and then work with cursors
> (in memory or not) to prepare the jason format. There are situations when the
> sql language it is not sufficient and need some extra tools for handle data. I
> do not want to have a lot of opened cursors but to be able to do the hard work
> with it and then kill them.
>
> So here I came to dabo where I found some vfp paradigms in it.
> And reporting it is also important. I do not want to drive back to 90's when
> designing reports where similar to writing scripting lines. I need a report
> designer that can be rendered on server side and to be able to read data in
> some format dabo can give it.
>
> So here I wanted some feedback from people involved. I will try to look more
> deep into dabo.
>
> On the internet i looked at solutions but there is not a good platform to
> handle all these.
>
> Camil
>
> _______________________________________________
>
This sounds like a ReST server or maybe a way to work with websockets?
This is a very different way to think of Dabo. I wonder if what Ed's
web interface might work?
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/51630371.9070001@jfcomputer.com