Op maandag 5 november 2018 08:36:25 CET schreef craigarno:
> Geert Janssens-4 wrote
>
> > Op zondag 4 november 2018 14:49:22 CET schreef craigarno:
> >> Geert Janssens-4 wrote
> >
> > Whether it can work depends on
> > whether the db layer we rely on has a notification mechanism for db
> >
Op maandag 5 november 2018 17:07:25 CET schreef Robert Fewell:
> Hi,
> I was poking around with the CSV importer and I noticed the following, this
> may also be an issue with other importers on first use after creating a new
> file...
> With a new empty xml file, I used a one line transaction csv
Geert,
I just subscribed to the gnucash-devel mailing list. Where do I find
the list so I can find and respond to your message? I also need to
respond to Phil's message, in gnucash-devel.
Short answer, no we do not have different ideas. I need to help you
understand my answer. Looks like
On 05/11/2018 16:07, Robert Fewell wrote:
Hi,
I was poking around with the CSV importer and I noticed the following, this
may also be an issue with other importers on first use after creating a new
file...
With a new empty xml file, I used a one line transaction csv file with
appropriate
Hi,
I was poking around with the CSV importer and I noticed the following, this
may also be an issue with other importers on first use after creating a new
file...
With a new empty xml file, I used a one line transaction csv file with
appropriate settings and the 'Account' set to 'Assets:Current
And here is an example for PostgreSQL
https://www.postgresql.org/docs/9.6/trigger-example.html
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
SQLite "trigger" example:
http://www.sqlitetutorial.net/sqlite-trigger/
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
Here is an example for MySQL
http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
I would assume postgresql and mysql would be more likely to provide this
kind of notification because they have a central server. sqlite does not.
I'm not sure how it could have 2 instances notify each other if they are
just accessing the same sqlite file.
On Mon, Nov 5, 2018 at 3:47 PM craigarno
Here is an outline for high performance record lock/update/release activity,
"Consumer/Producer" model.
https://www.xaprb.com/blog/2007/08/29/how-to-notify-event-listeners-in-mysql/
Good discussion of the problems surrounding multiple source remote data
updates, which definitely will go along
Op maandag 5 november 2018 20:16:04 CET schreef Craig Arno:
> Geert,
>
> I just subscribed to the gnucash-devel mailing list. Where do I find
> the list so I can find and respond to your message? I also need to
> respond to Phil's message, in gnucash-devel.
>
> Short answer, no we do not have
> On Nov 6, 2018, at 2:50 AM, Geert Janssens wrote:
>
> Op maandag 5 november 2018 17:07:25 CET schreef Robert Fewell:
>> Hi,
>> I was poking around with the CSV importer and I noticed the following, this
>> may also be an issue with other importers on first use after creating a new
>> file...
On 05/11/2018 17:50, Geert Janssens wrote:
Like you though I suspect this may be at least one cause of the import issues
we see. Thanks for poking at it!
this is a basic issue, people aren't allowed to decide if their tx are
new or not
--
Wm
Op maandag 5 november 2018 21:03:15 CET schreef Wm via gnucash-devel:
> On 05/11/2018 17:50, Geert Janssens wrote:
> > Like you though I suspect this may be at least one cause of the import
> > issues we see. Thanks for poking at it!
>
> this is a basic issue, people aren't allowed to decide if
Ok, think I see how GnuCash User/devel lists are organized, think I'm on dev
right now???
Phil's point is a valid one, Observer pattern works fine in local code on
the local machine, but how do you get SQL database notification of an update
to "trigger" an update cycle in other remote machines so
> On Nov 6, 2018, at 7:19 AM, Craig Arno wrote:
>
> I like John's idea,
>
> Here is potentially another big group of GnuCash customers/users, Microsoft
> product users (also supported by ODB)
>
> Microsoft SQL Server (MSDN Trigger documentation)
>
I like John's idea,
Here is potentially another big group of GnuCash customers/users,
Microsoft product users (also supported by ODB)
Microsoft SQL Server (MSDN Trigger documentation)
https://msdn.microsoft.com/en-us/library/sdk3bcyw.aspx?f=255=-2147217396
Craig
On 11/5/2018 2:08 PM, John
Op maandag 5 november 2018 20:23:40 CET schreef Wm via gnucash-devel:
> On 05/11/2018 16:07, Robert Fewell wrote:
> > Hi,
> > I was poking around with the CSV importer and I noticed the following,
> > this
> > may also be an issue with other importers on first use after creating a
> > new
> >
Isn't SQLite for "single" application use? Or are you thinking GnuCash will
be operating "peer-to-peer" (even more interesting thought for tiny
organizations)?
Maybe conditional code with SQLite being a third database type.
--
Sent from:
> On Nov 6, 2018, at 6:18 AM, craigarno wrote:
>
> Isn't SQLite for "single" application use? Or are you thinking GnuCash will
> be operating "peer-to-peer" (even more interesting thought for tiny
> organizations)?
>
> Maybe conditional code with SQLite being a third database type.
To
Got it, and noted. "Won't support" isn't the same as "won't work" (user
beware). But I get not putting free effort into a product someone else
profits from.
On 11/5/2018 2:30 PM, John Ralls wrote:
> SQL Server isn’t Free Software, so we won’t support using it. Same for
> Oracle, DB2, and any
Phil,
I did more investigation of SQLite v3 today and found a few impressive
things to summarize and pass along, which you may already know, but if not:
1. SQLite is "/full featured/", providing almost all of the features of
a "Server" based database installation; *triggers* being the
22 matches
Mail list logo
