Re: [sqlite] sqlite db transfer
thank you.. how can i use sqlite_db_readonly function.. On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena wrote: > i will explain.. i created a sqlite db.. now i should tranfer it also > transfered.. while opening a db it should ask password.. for that while > creating db i should enable some password or read only mode.. > > > On Thu, Jul 17, 2014 at 4:27 PM, Kees Nuyt wrote: > >> On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena >> wrote: >> >> > i sent a sqlite db from server to client using c program .. in this >> how i >> > set a password for the db to open in sqlite browser... >> >> In short: you can't. >> >> SQLite does not implement SQL access control (GRANT/REVOKE). The only >> protection you can rely on are the access control features of the >> filesystem the database resides in. >> >> You could buy a licence for the SQLite encryption extension (named SEE), >> <http://www.hwaci.com/sw/sqlite/see.html> , which enable you to encrypt >> the database, but I doubt sqlite browser would be able to open an >> encrypted SQLite database. >> >> Hope this helps >> >> -- >> Regards, >> >> Kees Nuyt >> >> >On Fri, May 9, 2014 at 6:05 PM, Simon Slavin >> wrote: >> > >> >> >> >> On 9 May 2014, at 1:23pm, Sky Meena wrote: >> >> >> >> > i working in server client... c program. i need to transfer db from >> >> server >> >> > to client. in udp socket .. i to send a db. >> >> >> >> SQLite does not involve a server or a client. All processing and >> access >> >> of the database is done inside your application. It does not >> communicate >> >> over IP, or use a socket, or anything like that. >> >> >> >> You can write your own server if you want, and many people have. Or if >> >> all you want is to send an entire database, you can use any method >> which >> >> would send a text file from one computer to another. For SQLite, if no >> >> program is accessing a database then the database is just one file. >> >> >> >> Simon. >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite db transfer
i will explain.. i created a sqlite db.. now i should tranfer it also transfered.. while opening a db it should ask password.. for that while creating db i should enable some password or read only mode.. On Thu, Jul 17, 2014 at 4:27 PM, Kees Nuyt wrote: > On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena > wrote: > > > i sent a sqlite db from server to client using c program .. in this > how i > > set a password for the db to open in sqlite browser... > > In short: you can't. > > SQLite does not implement SQL access control (GRANT/REVOKE). The only > protection you can rely on are the access control features of the > filesystem the database resides in. > > You could buy a licence for the SQLite encryption extension (named SEE), > <http://www.hwaci.com/sw/sqlite/see.html> , which enable you to encrypt > the database, but I doubt sqlite browser would be able to open an > encrypted SQLite database. > > Hope this helps > > -- > Regards, > > Kees Nuyt > > >On Fri, May 9, 2014 at 6:05 PM, Simon Slavin > wrote: > > > >> > >> On 9 May 2014, at 1:23pm, Sky Meena wrote: > >> > >> > i working in server client... c program. i need to transfer db from > >> server > >> > to client. in udp socket .. i to send a db. > >> > >> SQLite does not involve a server or a client. All processing and access > >> of the database is done inside your application. It does not > communicate > >> over IP, or use a socket, or anything like that. > >> > >> You can write your own server if you want, and many people have. Or if > >> all you want is to send an entire database, you can use any method which > >> would send a text file from one computer to another. For SQLite, if no > >> program is accessing a database then the database is just one file. > >> > >> Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite db transfer
i sent a sqlite db from server to client using c program .. in this how i set a password for the db to open in sqlite browser... On Fri, May 9, 2014 at 6:05 PM, Simon Slavin wrote: > > On 9 May 2014, at 1:23pm, Sky Meena wrote: > > > i working in server client... c program. i need to transfer db from > server > > to client. in udp socket .. i to send a db. > > SQLite does not involve a server or a client. All processing and access > of the database is done inside your application. It does not communicate > over IP, or use a socket, or anything like that. > > You can write your own server if you want, and many people have. Or if > all you want is to send an entire database, you can use any method which > would send a text file from one computer to another. For SQLite, if no > program is accessing a database then the database is just one file. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Setting boundaries in a search
how to set a password to open a sqlite db in sqlite browser On Thu, Jul 17, 2014 at 7:18 AM, RSmith wrote: > > On 2014/07/16 14:55, Rob Willett wrote: > > I’ll second what Simon says, I use the very same technique for a table >> with 4M+ records in and its so fast I thought I had an error and looked for >> bugs in my code. I >assumed (incorrectly) that it would be very slow, It >> isn’t. >> > > In a similar fashion I had made this system for basically loading CSV > files into an SQLite DB, then running all kinds of rules on it (which I > could make with a designer) such as search-replace, substitute column > values, do checks, delete rows with empty values in a certain column, etc. > etc. and then finally export it to a CSV again, all basically streamlining > a datafeed alteration process into a one-click thing. The viewer I used was > based on a method discussed in another thread where the virtual view would > get actual data only for items in the visible field by primary key. I > tested it with some CSV tables over 250MB big resulting in 10mil+ rows, and > here was my surprise, whether I looked at the top of the list, or the > bottom, or anywhere else, the data retrieval was instantaneous - retrieving > a page worth of records at whatever speed I can scroll the vertical > scrollbar - not a single slow-down as I got further down or indeed any > other slowness. I have come to expect great performance from SQLite as a > standard, but I am still often surprised at just how quick it can be. > > (btw: This app is freely shared if anyone needs something of the kind or > fancy testing the above, just mail me) > > ...// I have come to realise that the people who answer here are real >> experts, I will not embarrass them by naming names//... >> > > Oh don't worry, we know exactly who you mean... ;) > > It's Igor right? > > We all want to be like Igor when we grow up... *sighs dreamily* > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite db transfer
i working in server client... c program. i need to transfer db from server to client. in udp socket .. i to send a db. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] WITHOUT ROWID option
i need to transfer sqlite.db from server to client in udp socket.. working in c language.. .. i dont know how to transmit db. in client side it should create copy of db. if client ask name of db to server . server should transmit.. On Fri, May 9, 2014 at 3:09 PM, Stephan Beal wrote: > On Fri, May 9, 2014 at 11:38 AM, Stephan Beal > wrote: > > > i don't think a WHERE is necessary to improve the efficiency. The > > statement only gets prepared, not stepped, and i would not expect any > > analysis of results until the first step() (but maybe i'm assuming too > > much). > > > > In fact, a WHERE, if it's not optimized out, might even add memory cost for > the tokens required for parsing it. > > > -- > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of > those who insist on a perfect world, freedom will have to do." -- Bigby > Wolf > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users