Hey,

My experience with postgis is limited (and did not involve Wt::Dbo since it
was a Java project), but even if you need to create new tables, you could
still map a Wt::Dbo class to a View that is backed by a query which
aggregates data from multiple tables ?

You should not switch to Wt::Dbo for performance reasons (given you are
arlready using libpq), but only to make your life easier since it helps you
avoid the need to write SQL for handling inserting/updating of data and
basic 1-N or M-N queries and map data from and to C++ objects.

Regards,
koen


2013/1/4 Rashad M <mohammedrasha...@gmail.com>

> I have an app where user creates new layers (map layers eg: atm, roads,
> schools etc.) In gis these should be seperate postgis tables for analysis
> purposes. So Is it really a bad design to have user created tables? I have
> no option left with me
>
>
> On Fri, Jan 4, 2013 at 11:07 PM, Wim Dumon <w...@emweb.be> wrote:
>
>> As far as I know this is not possible with Dbo.
>>
>> I don't think that having your amount of tables grow with the amount of
>> users is recommended database design in general, but then again, I'm not a
>> database expert. What does google say about it? Maybe it's a good
>> opportunity to reconsider how you use the databse?
>>
>> Best regards,
>> Wim.
>>
>>
>> 2013/1/3 Rashad M <mohammedrasha...@gmail.com>
>>
>>> All,
>>>
>>> I am planning to swith my whole db code to use Wt::Dbo (currently using
>>> libpq). Will this improve the efficiency/performance in speedwise of my web
>>> application?
>>>
>>> Also I have problem swtiching to Wt::Dbo. How will I map a table created
>>> by user at runtime?
>>>
>>> like on user creates some new table. and table name can be found out
>>> easily and used in mapping but the mapping class need to be aware of the
>>> fields in the table right? Is this a limitation of Wt:Dbo or I am assuming
>>> something stupid?
>>>
>>>
>>> Currently pfrom pg_catalog and pg_tables i finds the tables' field names
>>> at runtime.
>>>
>>>
>>> --
>>> Regards,
>>>    Rashad
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>>> MVPs and experts. ON SALE this month only -- learn more at:
>>> http://p.sf.net/sfu/learnmore_122712
>>> _______________________________________________
>>> witty-interest mailing list
>>> witty-interest@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/witty-interest
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
>> much more. Get web development skills now with LearnDevNow -
>> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
>> SALE $99.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122812
>>
>> _______________________________________________
>> witty-interest mailing list
>> witty-interest@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/witty-interest
>>
>>
>
>
> --
> Regards,
>    Rashad
>
>
> ------------------------------------------------------------------------------
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> _______________________________________________
> witty-interest mailing list
> witty-interest@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/witty-interest
>
>
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122912
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest

Reply via email to