Re: [sqlite] HELP!

[Clemens Ladisch]

am...@juno.com wrote:
> I work for a company that has a many locations with more than one
> person in every location. I want to share the databases I have built
> using SQLITE with some of the people in each location. Do any of you
> good people know is SQLITE on the cloud?

It's not; SQLite is file based.  The only way to share this would be to
make a file share in the company-wide network, i.e., to make the file
\\COMPANYSERVER\SomeShare\MyLittleDB.sqlite directly accessible from
everywhere.  (This is likely to be inefficient.)

Consider replacing SQLite with a client/server database:



Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] HELP!

[Dingyuan Wang]

There are some cloud solutions:
https://dbhub.io/ for sharing
https://bedrockdb.com/ for distributed hosting

2018/11/11 8:49, am...@juno.com:
> November 10, 2018 Dear Good People: I work for a company that has a many 
> locations with more than one person in every location. I want to share the 
> databases I have built using SQLITE with some of the people in each location. 
> Do any of you good people know is SQLITE on the cloud? lf so, I  would be 
> most appreciative if you would tell me how to access it. 2) If SQLITE is on 
> the cloud, how do I restrict access--so that one information (not like 
> spelling errors) is inputted, the information cannot be removed. 3) Is there 
> a spell checker function on SQLITE? ?if so, please advise very specifically 
> how to find and use it. If any of you good people can help me solve these 
> dilemmas, I would be most appreciative. Thank you very much in advance for 
> helping me solve these problems. Respectfully yours, Alex Stavis
> 
> 1 Simple Trick Removes Lip Lines & Eye Bags in Seconds
> Fit Mom Daily
> http://thirdpartyoffers.juno.com/TGL3131/5be77c818908f7c813b2est01vuc
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Connect Failure: too many open files

[Jens Alfke]

You must not be closing the SQLite connection when the app goes into the 
background. Then the file descriptors stay open, and new ones are opened (on 
the same file) when you reopen when the app activates.

—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] HELP!

[Jens Alfke]

> On Nov 10, 2018, at 4:49 PM, am...@juno.com wrote:
> 
> November 10, 2018 Dear Good People: I work for a company that has a many 
> locations with more than one person in every location. I want to share the 
> databases I have built using SQLITE with some of the people in each location. 
> Do any of you good people know is SQLITE on the cloud?

No. SQLite is a library (with a command-line tool.)

There are some GUI apps that use SQLite, but they’re not part of SQLite itself. 
If you’re using one of those apps, you should  contact its developer (i.e. not 
this list.)

—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] HELP!

[am...@juno.com]

November 10, 2018 Dear Good People: I work for a company that has a many 
locations with more than one person in every location. I want to share the 
databases I have built using SQLITE with some of the people in each location. 
Do any of you good people know is SQLITE on the cloud? lf so, I  would be most 
appreciative if you would tell me how to access it. 2) If SQLITE is on the 
cloud, how do I restrict access--so that one information (not like spelling 
errors) is inputted, the information cannot be removed. 3) Is there a spell 
checker function on SQLITE? ?if so, please advise very specifically how to find 
and use it. If any of you good people can help me solve these dilemmas, I would 
be most appreciative. Thank you very much in advance for helping me solve these 
problems. Respectfully yours, Alex Stavis

1 Simple Trick Removes Lip Lines & Eye Bags in Seconds
Fit Mom Daily
http://thirdpartyoffers.juno.com/TGL3131/5be77c818908f7c813b2est01vuc
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Connect Failure: too many open files

[Simon Slavin]

On 10 Nov 2018, at 1:57pm, Simon Slavin  wrote:

> Do you test the code returned by sqlite_close() to make sure it is returning 
> SQLITE_OK and not an error ?

Sorry, I forgot a possibility.

If your application has a statement which is not terminated, it cannot close 
the database.  For example, you might do

sqlite_prepare(), sqlite_step(), sqlite_step(), sqlite_step()

the last step might return SQLITE_DONE.  But the SQLite library doesn't release 
the resources until you call either sqlite_reset() or sqlite_finalize().  And 
one of the resources is the database connection.

So if you use sqlite_step() anywhere, make sure you finalize after the last 
step.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Connect Failure: too many open files

[Simon Slavin]

On 10 Nov 2018, at 12:52pm, Paresh Sukhiya  
wrote:

> 9. Whenever the app goes in background we Shut Down the SQLite connection and 
> on Activation we Initialize the SQLite again in Serialized mode.

If the problem really is with SQLite, and not some other thing which is opening 
files, then my guess is that your detection of backgrounding is faulty, or that 
your app is being choked off before it can close the database.

What hardware are you programming for, and what library are you using to make 
SQLite calls ?

Do you test the code returned by sqlite_close() to make sure it is returning 
SQLITE_OK and not an error ?

As a temporary test, after detecting being moved to background, and closing the 
database, deinitialise SQLite by calling sqlite3_shutdown() or whatever 
equivalent your library allows.  It should be impossible for SQLite to hold a 
file open after this call, even if it wasn't able to close all databases 
without errors.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation of SQLite

[Dan Kennedy]

On 11/10/2018 05:44 PM, Patrik Nilsson wrote:

Dear All,

Where can I find the downloadable HTML documentation? Not so long ago I
could download it on the download page.


It was forgotten for the 3.25.3 release. It's back up now.

Dan.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Connect Failure: too many open files

[Paresh Sukhiya]

Dear SQLite people,

Please help me with the issue occurring while using SQLite in sqlite3. Connect 
Failure: (Too many open files)

I’ll let you know the whole scenario and if you could then please help.
We use sqlite3 in a mobile apps.
I have created a SQLite connection with Serialized mode with the following 
configuration 

1. I have set SQLite Open Flags to ReadWrite ,Create ,SharedCache ,FullMutex 
,ProtectionComplete.
2. PRAGMA journal_mode = WAL
3. PRAGMA page_size = 4096
4. PRAGMA default_cache_size = 1024
5. PRAGMA cache_size = 1024
6. PRAGMA synchronous = 1
7. PRAGMA locking_mode = EXCLUSIVE
8. PRAGMA sqlite3_temp_directory = tempPath (I have set a path)
9. Whenever the app goes in background we Shut Down the SQLite connection and 
on Activation we Initialize the SQLite again in Serialized mode.
10. We use a single connection in the whole application which gets closed when 
app goes in background.

Now the issue is after using the app for some time we get the issue as

Connect Failure (too many open files)
When I found the list of files open  I found that out of 256 file descriptors 
around 210-220 file descriptors were used by a file named SQliteDB.db3-shm
And one was SQLiteDB.db3-wal

So my question is : 
1. How this can be solved or if any alternative or If have done any mistake 
while setting the configuration mode?
2. How to clear those temporary db3-shm files?


Thanks for your help!

Sincerely,
Paresh Sukhiya.







___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with https://www3.sqlite.org

[Richard Hipp]

On 11/10/18, Domingo Alvarez Duarte  wrote:
> Hello Richard !
>
> It seems that you have a problem again with https://www3.sqlite.org for
> several days now.
>
> It can't be reached.

Thanks.  Rebooted now and working again.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Documentation of SQLite

[Patrik Nilsson]

Dear All,

Where can I find the downloadable HTML documentation? Not so long ago I 
could download it on the download page.


Best regards,
Patrik

--
PGP-key fingerprint: 1B30 7F61 AF9E 538A FCD6  2BE7 CED7 B0E4 3BF9 8D6C

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem with https://www3.sqlite.org

[Domingo Alvarez Duarte]

Hello Richard !

It seems that you have a problem again with https://www3.sqlite.org for 
several days now.


It can't be reached.

Cheers !

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users