2013/1/6 Koen Deforche <k...@emweb.be>
> 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 ?
>
It can be a little tricky if he needs to do INSERT/UPDATE on this view.
BTW, automatically-updatable views (for simple cases) may be introduced in
9.3.
http://archives.postgresql.org/pgsql-committers/2012-12/msg00154.php
>
> 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
>
>
--
// Dmitriy.
------------------------------------------------------------------------------
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
