Re: [GENERAL] dynamic schema modeling and performance

2017-04-14 Thread Vincent Elschot
Op 14/04/2017 om 19:03 schreef Rj Ewing: We do know where we want to end up. We've had the application running for a while using a triple store db. We're looking to move away from the triple store due to performance issues. Our core concept is that each project can define a set of entities

Re: [GENERAL] browser interface to forums please?

2017-04-05 Thread Vincent Elschot
Op 05/04/2017 om 19:26 schreef Tim Clarke: On 05/04/17 18:22, Joshua D. Drake wrote: Stackoverflow gives back by providing an interface people want to use. It is free (as in beer) and is hugely popular. We need to be embracing these external communities because it is where our growth is. I

Re: [GENERAL] Trim performance on 9.5

2016-11-20 Thread Vincent Elschot
Op 18/11/2016 om 16:58 schreef William Ivanski: I just ran EXPLAIN ANALYZE, please see images attached. Field doesn't have a index. Em sex, 18 de nov de 2016 às 12:16, vinny > escreveu: On 2016-11-18 15:06, William Ivanski wrote: > Hi,

Re: [GENERAL] temporary indexes?

2015-10-22 Thread vincent elschot
On 21-10-15 20:43, Jonathan Vanasco wrote: I couldn't find any mention of this on the archives... Have the project maintainers ever considered extending CREATE INDEX to support "temporary" indexes like CREATE TEMPORARY TABLE? When creating temporary tables for analytics/reporting, I've

Re: [GENERAL] Arduino SQL Connector

2014-04-28 Thread vincent elschot
On 18-04-14 06:21, John R Pierce wrote: On 4/17/2014 9:09 PM, Steve Spence wrote: You know what? Fine, it doesn't matter that much to me. I'm happy to continue using MySQL. It works with the Arduino quite nicely. Postgres doesn't work. That's Postgres loss not mine. I really thought the

Re: [GENERAL] postgresql or xquery?

2013-12-06 Thread vincent elschot
On 06-12-13 11:54, e-letter wrote: Readers, Admittedly, a biased place to ask (!), but for a new database project, how best to evaluate whether postgresql or xquery should be used. As a novice of postgresql and xml, am not sure what is most appropriate for a new database that will be tested