Re: [sqlite] Proof that a line has been modified

without adding a revocation system. Nor can you prove that the DB/FS has no malicious content in it -- only that an approved entity signed it as "approved". Nico Paxdo <mailto:pa...@mac.com> 7 septembre 2017 à 10:16 Hi all! For security reasons, a customer wants to be sure that

Re: [sqlite] Proof that a line has been modified

ire database file in the repository. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Paxdo <mailto:pa...@mac.com> 7 septembre 2017 à 10:16 Hi

Re: [sqlite] Proof that a line has been modified

and its salt could make changes on the table and recalculate all checksums. :-( Paxdo <mailto:pa...@mac.com> 7 septembre 2017 à 10:16 Hi all! For security reasons, a customer wants to be sure that a database line cannot be modified after its initial insertion (or unmodified without being v

[sqlite] Proof that a line has been modified

Hi all! For security reasons, a customer wants to be sure that a database line cannot be modified after its initial insertion (or unmodified without being visible, with proof that the line has been modified). Including by technicians who can open the database (SQLITE of course). Is there a

Re: [sqlite] Row_number?

2|Arthur > 3|23|Bill > 4|34|Ron > 5|43|William > sqlite> create table mylist as select id,name from people order by name; > sqlite> select rowid,* from mylist; > 1|12|Arthur > 2|23|Bill > 3|5|Chris > 4|34|Ron > 5|43|William > > > -Original Messag

[sqlite] Row_number?

Hello, I have a problem and I do not find the solution with Sqlite. I need an equivalent to ROW_NUMBER. Here's the problem: SELECT id, name FROM people ORDER BY name On this, I would like to know the line number of the ID 34, how? example: SELECT id, name FROM people ORDER BY name Result:

Re: [sqlite] dates and optimizations

> > > But do you really do things like run a search on "invoices made ​​on a Monday > in February" ? Yes. For example, in a store, it is useful to have sales statistics by day of the week, or by time slot, etc.. > Most of the time I store a date I'm storing it for three purposes: > > A)

[sqlite] dates and optimizations

Hello, To search and sort the dates in SQLite, the SQL methods (strftime and date) are they fast enough on long dates (as '2012-12-07 01:48:45')? Or would you prefer to store separately the day, year, etc..? example: select invoice.date from invoice where strftime('%m', invoice.date)='02'

Re: [sqlite] Processing time of a transaction

Perfect, thank you M. Hipp! Le 18 oct. 2012 à 20:32, Richard Hipp <d...@sqlite.org> a écrit : > On Thu, Oct 18, 2012 at 1:57 PM, Paxdo Presse <pa...@mac.com> wrote: > >> >> Hello, >> >> in FAQ http://www.sqlite.org/faq.html : >> >>

[sqlite] Processing time of a transaction

Hello, in FAQ http://www.sqlite.org/faq.html : "Actually, SQLite will easily do 50,000 or more INSERT statements per second on an average desktop computer. But it will only do a few dozen transactions per second. Transaction speed is limited by the rotational speed of your disk drive. A

Re: [sqlite] Handled images in database: URL or blob ?

Thank you very much Keith, Simons, Clements, it helped me a lot! Sorry for the late reply, olivier Le 8 oct. 2012 à 18:14, Keith Medcalf a écrit : >>> Images are handled in the app: photo of products, photos of customers, etc. >>> Each client can have thousands. >>>

Re: [sqlite] Handled images in database: URL or blob ?

sch <clem...@ladisch.de> a écrit : > Paxdo Presse wrote: >> The context: >> - Web application >> - Billing application >> - Sqlite with WAL mode >> - The database is shared among many clients. >> >> Images are handled in the app: photo of products, photos of

[sqlite] Handled images in database: URL or blob ?

Hello, The context: - Web application - Billing application - Sqlite with WAL mode - The database is shared among many clients. Images are handled in the app: photo of products, photos of customers, etc. Each client can have thousands. Advise you manage images as blob in the database? or have

Re: [sqlite] How point numbers are they stored in sqlite?

ok, thank you all! Le 17 avr. 2012 à 11:35, Richard Hipp a écrit : > > Key point: Floating point numbers are approximations. This is an inherent > property of IEEE floating point numbers, not a limitation of SQLite. If > you need an exact answer, use integers. > > -- > D. Richard Hipp >

[sqlite] How point numbers are they stored in sqlite?

Hi, How point numbers are they stored in sqlite? In a field with REAL affinity: round(11.578767 / 2 , 4) is displayed "5.7894" in SQLite/Navicat :-), but "5,78939997" in the cursor of my development language when I get it to sqlite. Internally, SQLite works with 5.7894 or

Re: [sqlite] How to handle the locks with WAL mode?

Thank you Simon and Igor. >> Are we to understand that the pending / exclusive locks function differently >> and allow simultaneous shared locks? > > Yes. Note that, with WAL, writers never write to the same areas of files that > readers may read from. This would mean that with wal mode,

Re: [sqlite] How to handle the locks with WAL mode?

locks? What locks/transactions should be used, to allow simultaneous readers and one writer? Thank you Le 16 déc. 2011 à 15:40, Igor Tandetnik a écrit : > Paxdo Presse <pa...@mac.com> wrote: >> With WAL mode, >> there may be multiple readers and one writer, SIMULTANE

[sqlite] How to handle the locks with WAL mode?

Hi, With WAL mode, there may be multiple readers and one writer, SIMULTANEOUSLY. is very different from the rollback mode. Should we handle locks and transactions differently? Thank you, olivier ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] No error when deleting a record already deleted?

ok, Thank you to both. Le 15 déc. 2011 à 16:24, Richard Hipp a écrit : > On Thu, Dec 15, 2011 at 10:08 AM, Pavel Ivanov <paiva...@gmail.com> wrote: > >> On Thu, Dec 15, 2011 at 10:05 AM, Paxdo Presse <pa...@mac.com> wrote: >>> It's normal not to get an error

[sqlite] No error when deleting a record already deleted?

Hi all, It's normal not to get an error message when trying to remove or edit a record that has already been removed? Thank you, olivier ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Number of transactions per second with WAL mode

ok, thank you all. Le 14 nov. 2011 à 16:57, Simon Slavin a écrit : > > On 14 Nov 2011, at 3:49pm, Paxdo Presse wrote: > >> I hesitate a lot in my choice of database for my web application. >> I guess the use of SSD dramatically increases the performance of SQLite. &g

Re: [sqlite] Number of transactions per second with WAL mode

Thank you. I hesitate a lot in my choice of database for my web application. I guess the use of SSD dramatically increases the performance of SQLite. SQLITE work properly on SSD? Le 14 nov. 2011 à 16:37, Simon Slavin a écrit : > > On 14 Nov 2011, at 3:05pm, Paxdo Presse wrote: >

Re: [sqlite] Number of transactions per second with WAL mode

Thanks to both :-) It's not easy to calculate how many simultaneous users the database can handle. Le 14 nov. 2011 à 15:58, Petite Abeille a écrit : > > On Nov 14, 2011, at 3:53 PM, Paxdo Presse wrote: > >> If each thread writing (a transaction that contains one or more &

Re: [sqlite] Number of transactions per second with WAL mode

, at 3:33 PM, Paxdo Presse wrote: > >> If my write transactions consume an average of 10 ticks (1 ticks = 60th of a >> second), it means that I can get very approximately 6 write operations per >> second? (with a recent computer powerful enough). >> At the same time, how

Re: [sqlite] Number of transactions per second with WAL mode

Le 14 nov. 2011 à 15:38, Igor Tandetnik a écrit : > Paxdo Presse <pa...@mac.com> wrote: >> a question from a beginner please: >> >> SQLITE with WAL mode. >> >> If my write transactions consume an average of 10 ticks (1 ticks = 60th of a >> second

Re: [sqlite] Number of transactions per second with WAL mode

I know it depends on many things. But in your experience, how many write transactions and read transactions could you see at most per second or minute? Very approximately ? with transactions fast enough. Le 14 nov. 2011 à 15:33, Paxdo Presse a écrit : > > Hi, > > a question fro

[sqlite] Number of transactions per second with WAL mode

Hi, a question from a beginner please: SQLITE with WAL mode. If my write transactions consume an average of 10 ticks (1 ticks = 60th of a second), it means that I can get very approximately 6 write operations per second? (with a recent computer powerful enough). At the same time, how many

Re: [sqlite] sql server management studio like tool for SQLite

I like Base : http://menial.co.uk/software/base/ But no triggers. olivier Le 6 nov. 2011 à 19:04, Pete a écrit : > Opinions on the best one for OS X? > Pete > > > > > > >> Message: 6 >> Date: Sat, 05 Nov 2011 15:46:36 -0500 >> From: John Horn >> To:

Re: [sqlite] Lock and transaction

Great. Thanks to both. (and sorry for my bad english) Le 5 nov. 2011 à 00:05, Petite Abeille a écrit : > > On Nov 4, 2011, at 11:59 PM, Paxdo Presse wrote: > >> Are we sure that another process is not going to create another row between >> my "INSERT" and

[sqlite] Lock and transaction

Hello, a question from beginner please : In this transaction (with wal-mode) : BEGIN TRANSACTION INSERT INTO SELECT last_insert_rowid() COMMIT Are we sure that another process is not going to create another row between my "INSERT" and "SELECT LAST ROWID"? The "LAST ROWID" is it for

Re: [sqlite] WAL mode is reliable?

> >> I feel that WAL is rarely used now. > > It is used on my Android phone running 2.3. That is almost 100 million > devices with all sorts of programs and crash scenarios. Is that rare? Roger, I meant: I feel that WAL is rarely used with its new capabilities. SQLite + WAL may, perhaps,

Re: [sqlite] WAL mode is reliable?

Thank you M. Hipp ! I feel that WAL is rarely used now. It is difficult to get opinions / feedback on this feature. And for users of database servers (MySQL, Postgres, etc.). It is impossible to have a reliable database without a server. You think SQLite can handle a website / web app that

Re: [sqlite] WAL mode is reliable?

> For concurrency it works fine. The amount of time a connection takes is very > small: just long enough to open, set timeout, do a single query/exec, and > close the connection. So even with lots of users there aren't that many > concurrent connections to the database file. > > Looking

Re: [sqlite] WAL mode is reliable?

Thank you Simon! How did you get concurrent connections? (about) Le 3 nov. 2011 à 14:32, Simon Slavin a écrit : > > On 3 Nov 2011, at 1:22pm, Paxdo Presse wrote: > >> What do you think of SQLite with WAL mode? >> >> Is it reliable? >> >> It is for

[sqlite] WAL mode is reliable?

concurrents access can handle this database? Thank you, olivier Paxdo Presse France ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users