Re: [sqlite] Are you getting spam when you post to sqlite-users ?

And my dating success rate has dropped dramatically On Wed, Apr 18, 2018 at 8:54 AM, José María Mateos wrote: > On Tue, Apr 17, 2018, at 17:39, Simon Slavin wrote: > > Dear list-posters, > > > > Are you getting a new dating-spam each time you post to this list ? If > > you

Re: [sqlite] [EXTERNAL] kooky thought: a vm-only build (for embedded). feasible?

Thanks for the feedback. The schema would indeed be fixed. It sounds like I have an 'interesting' side project in my future! > -Original Message- > From: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Hick Gunter > Sent: Monday, April 16, 2018 1:50

Re: [sqlite] kooky thought: a vm-only build (for embedded).feasible?

... > > size -- both code and RAM. I know about the various > compile switches that > > can turn off various features, but I wonder if I can really > strip it down > > further by eliminating parsing, query planning, etc, > altogether, and only > > support the virtual machine. I do need

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

I have banished a block of 256 IP addresses around the specific IP address from which the spam was originating. (The ISP is Mellowhost.com.) I did not expect that this would help, as I assumed that the email addresses were being harvested from a separate gmail or yahoo email account. And yet,

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

On Tue, Apr 17, 2018, at 17:39, Simon Slavin wrote: > Dear list-posters, > > Are you getting a new dating-spam each time you post to this list ? If > you are, please post a brief follow-up to this message. Please do /not/ > include any details about the spam, its headers, or the person it's

Re: [sqlite] Any operation to trigger osMunmap?

On 4/18/18, Nick wrote: > Hi, > I have one process using sqlite with “pragma mmap_size=30M”. The operations > of my process is insert-select-insert-select. So the PSS(private clean) will > increase along with the growing of the db which is treated as memory leak by >

[sqlite] crash dropping table

I have a simple test case wherein I delete from a number of tables and then drop one of those tables. This crashes sqlite3. So something like this: begin; delete from x; delete from y; delete from z; drop x; << crashes here Sorry for my ignorance but is there a procedure for submitting bugs

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

Can you forward at least the header to me, please? On 4/18/18, David Raymond wrote: > Just got my first one after my last post. > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Richard Hipp >

Re: [sqlite] crash dropping table

On 18 Apr 2018, at 4:47pm, Mark Wagner wrote: > I have a simple test case wherein I delete from a number of tables and then > drop one of those tables. This crashes sqlite3. > > So something like this: > > begin; > delete from x; > delete from y; > delete from z; > drop x;

Re: [sqlite] crash dropping table

I will try to produce a repro case that I can share out (the database I was testing on has lots of personal data that I will first try to delete). Thanks for the responses. @David Note that those weren't the precise commands (i.e. drop command was "drop table x;"). On Wed, Apr 18, 2018 at 9:56

Re: [sqlite] crash dropping table

The more specific info the better. Can you reproduce it with a new database or does it only happen on one specific database? What're the schemas of x, y and z? Are those the exact commands you're giving it? (For example: "drop x;" should give you a syntax error, but not crash) What journal

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

"Banishing" means configuring IP filters on the server to silently discard any and all IP packets that originate from the targeted range of IP addresses. This is the best method that I have ever used and I can tell you that your ipfilter rules can get quite long using this approach. In truth

Re: [sqlite] crash dropping table

On 18 Apr 2018, at 5:59pm, Mark Wagner wrote: > I will try to produce a repro case that I can share out (the database I was > testing on has lots of personal data that I will first try to delete). Before you do anything else to it, make a copy and use the SQLite shell to do

Re: [sqlite] crash dropping table

On Wed, 18 Apr 2018 15:47:47 +, Mark Wagner wrote: > Sorry for my ignorance but is there a procedure for > submitting bugs for things like this? The procedure is to mail bugs to this mailing list, including version info, so you did exactly the right thing. -- Regards,

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

Just got my first one after my last post. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, April 18, 2018 8:41 AM To: SQLite mailing list Subject: Re: [sqlite] Are you getting spam when you post to

Re: [sqlite] crash dropping table

On 4/18/18, Mark Wagner wrote: > I have a simple test case wherein I delete from a number of tables and then > drop one of those tables. This crashes sqlite3. > > So something like this: > > begin; > delete from x; > delete from y; > delete from z; > drop x; << crashes here

Re: [sqlite] Changes on sqlite3 parser and why not ?

On 4/17/18, petern wrote: > 3. In tables with serially related data it can be cumbersome to reference > columns in the working table when columns must be computed from existing > rows in the same table. I don't understand this point. Can you provide an example? --

[sqlite] JDBC driver experience

Are you using SQLite with JDBC? If so, can you please answer a few questions below? You can post on this mailing list or send your reply directly to me. 1. Which JDBC are you using? 2. For how long have you been using it? 3. What issues you had with this driver? 4. What advise do you have for

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

On 4/18/18, Dennis Clarke wrote: > >> "Banishing" means configuring IP filters on the server to silently >> discard any and all IP packets that originate from the targeted range >> of IP addresses. > > This is the best method that I have ever used and I can tell you that >

[sqlite] Any operation to trigger osMunmap?

Hi, I have one process using sqlite with “pragma mmap_size=30M”. The operations of my process is insert-select-insert-select. So the PSS(private clean) will increase along with the growing of the db which is treated as memory leak by Mem-Analysor tool. I guess calling sqlite3_close() or pragma

[sqlite] [PATCH] Feature request: support cli variables

Hi all. After read i wanted to try to do the same with my sqlite queries. Sadly, the sqlite command line shell don't support variables. For that i want to suggest to add the support of variables in the command line shell. For start thinking

Re: [sqlite] Changes on sqlite3 parser and why not ?

Some points on working table alias: 1. If upsert goes to trunk, there is already a INSERT table alias test case (do_execsql_test upsert3-210) that must succeed: https://www.sqlite.org/src/info/907b5a37c539ea67 2. Obviously PostgreSQL already supports a working table alias universally:

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

Wouldn't it be as simple as subscribing to the mailing list and harvesting the emails directly from the inbound content? Because as it is, everyone's real email already comes to me in the list messages I receive (as 'sqlite-users on behalf of x...@yyy.com') The spam message I just received used

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

I block by domain as in *.dognuts *.spammers *.dating *.evildoers for basically every johhny-cum-lately domain (ie, that has not existed since before 1995) -- one strike and the whole TLD is fileterd (as in packet routed to the null0 interface). Then tere is the checks on SPF, protocol

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

On 18 Apr 2018, at 11:19pm, dave wrote: > Wouldn't it be as simple as subscribing to the mailing list and harvesting > the emails directly from the inbound content? No need to subscribe. This mailing list is gated to web fora. Just scrape some web pages. I don't think

Re: [sqlite] JDBC driver experience

1. Xerial 2. Couple years? 3. None. But I am just a dumb user. I use JetBrains IDE's (RubyMine, Rider, Datagrip). The IDE's provide direct access to the datasource for looking at the db, manipulating data, manipulating tables. That sort of stuff. Never once have I had an issue with the driver

Re: [sqlite] Any operation to trigger osMunmap?

So the PSS will not decrease even if the db becomes smaller after some DELETE/vacuum operations? I think it is a better way to free the mmap memory after every query automatically inside sqlite. Why not? -- Sent from: http://sqlite.1065341.n5.nabble.com/

Re: [sqlite] JDBC driver experience

1. Xerial 2. A year or so, relatively heavily. 3. * MAX_MMAP_SIZE is too small by a few hundred megabytes. It's safe to set to around a terabyte. * No way to effectively use multiple threads, even on a read-only mmap'd database. * Planner sometimes misses plans - does it need better STAT

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

It has to be a subscriber. I just got spam in the form of an almost-immediate reply to my last message to the list, including message-ids. Web wouldn't bother including that metadata, and is unlikely to be quite so real-time. On 04/18/2018 11:35 PM, Simon Slavin wrote: On 18 Apr 2018, at