Re: [sqlite] 3.7.4 possible restore bug
Hi, 12/01/2011 12:27, Max Vlasov wrote: > On Thu, Dec 23, 2010 at 3:10 PM, Max Vlasov<max.vla...@gmail.com> wrote: > >> Hi, >> I experimented with artificial power loss (using hd box) and 3.7.4 both >> library and shell didn't restore the files to the initial state. 3.6.10 >> restores successfully. >> > > > This is a kind of repost, there wasn't any answer for my initial one. Please > let me know is this bug or not a bug, I can't sleep without knowing the > truth :) > > Steps to reproduce without additional test data > [snip] 3.7.2 behaves identically. Before quitting: - select shows nothing - inserting another record removes journal > > Max Vlasov -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite from fossil
Hi, 04/11/2010 14:09, Richard Hipp wrote: > On Thu, Nov 4, 2010 at 3:52 AM, Hakki Dogusan<dogus...@tr.net> wrote: > >> Hi, >> >> 03/11/2010 23:51, Benjamin Peterson wrote: >>> Richard Hipp<d...@...> writes: >>>> Try setting: >>>> >>>>fossil setting autosync off >>>> >>>> before you do the >>>> >>>>fossil update >>> >>> I actually get this from "fossil clone http://sqlite.org/src;, too. >>> >> >> >> I don't know it is same problem as this but I'm getting something like >> "couldn't login" error too. >> >> In my case >> Server (Ubuntu) with: fossil-linux-x86-20101101142335.zip >> Client (WinXP) with : fossil-w32-20101101142335.zip >> >> If I use >> fossil server reponame.fossil >> instead of >> fossil ui reponame.fossil >> then client successfully sync. >> > > In newer versions of Fossil, the "fossil ui" command binds to the loopback > IP only (127.0.0.1) meaning that it will only see TCP/IP traffic coming from > the local machine. This is a security feature. The "fossil server" command > continues to bind to all IP addresses as it always has. > (Possibly a stupid question/suggestion, but) Could "fossil ui" be relaxed to allow local addresses? -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite from fossil
Hi, 03/11/2010 23:51, Benjamin Peterson wrote: > Richard Hipp<d...@...> writes: >> Try setting: >> >> fossil setting autosync off >> >> before you do the >> >> fossil update > > I actually get this from "fossil clone http://sqlite.org/src;, too. > I don't know it is same problem as this but I'm getting something like "couldn't login" error too. In my case Server (Ubuntu) with: fossil-linux-x86-20101101142335.zip Client (WinXP) with : fossil-w32-20101101142335.zip If I use fossil server reponame.fossil instead of fossil ui reponame.fossil then client successfully sync. -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite3 & Code::Blocks
Hi, Gregory A Failing wrote: > Hello everyone. > > While not new to Code::Blocks and SQLite3, I have never until today tried > to use them together. I am having a problem getting my proof-of-concept > code to compile. Any assistance would be appreciated. > > First, my environment: > - WinXP > - Code::Blocks 8.02 w/ MinGW compiler > - wxWidgets 2.8.9 > - SQLite3 3.6.11 > Similar to mine (I'm using svn version of Code::Blocks). If you open to use a wrapper, I recommend wxSQLite3 (http://wxcode.sourceforge.net/components/wxsqlite3/). (If you need project files please ask offline.) > [snipped] > > GAFling > 2009-03-22 > -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Writing double into a socket file
Hi, Alex Katebi wrote: > I am trying to implement remote procedure calls (RPC) for SQLite API to be > used in my application. > In particular sqlite3_column_double( ) returns a floating point double. > How can I write this double value into a TCP socket? > I have tried writing 8 bytes as integer values but the received valued at > the other end of the socket is incorrect. > I don't have a lot of experience with real numbers. Can someone help? > Have a look at YAMI (http://www.msobczak.com/prog/yami/). It has the ability to send/receive following data types: eString = 1; /* ASCII string */ eWString = 2; /* wide string*/ eInt = 3; /* integer*/ eDouble = 4; /* double */ eByte= 5; /* opaque byte*/ eBinary = 6; /* opaque binary data */ > Thanks, > -Alex -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Innovative examples / user stories
Hi, (Sorry, I lost original mail to reply) Mohd Radzi Ibrahim yazmış: > [snipped usage example] > > - Original Message - > From: "Lars Aronsson" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Tuesday, February 12, 2008 1:51 AM > Subject: [sqlite] Innovative examples / user stories > > >> Is there any documentation of how people use SQLite in odd ways in >> their everyday activities? >> [snip] >> I'm using sqlite3 as a configuration file and snippet code(Lua) storage in CairoPad[1] application. My idea was users of CairoPad could share their code with others just transferring one sqlite db file (sharing is not implemented yet). [1] http://www.dynaset.org/dogusanh/download.html#cairopad >> >> -- >> Lars Aronsson ([EMAIL PROTECTED]) >> Aronsson Datateknik - http://aronsson.se -- Regards, Hakki Dogusan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Can't get results from PRAGMA
Hi, Hakki Dogusan wrote: Hi, (I'm cc'ing to you) Paul Simpson wrote: Hi, (I hope we are not getting off-topic) We seem to be, sorry everyone! I trued e-mailing you directly - I hope you don't mind, but your mail server refused the mail! But I can get messages, as you can see :) I'll prepare a sample Code::Blocks project using SQLite, wx, wxSQLite3. I'll send a message here and your address when ready. [snip] I've put a zip file: http://www.dogusan.net/dogusanh/download/cbwxMinimal.zip (58kb) File contains: - Code::Blocks project - wx minimal sample (modified for creating, populating, querying code for db) - wxSQLite3 source - sqlite3.dll import lib Requirements: - Mingw - wx - Code::Blocks - sqlite3.dll Hope it helps... -- Regards, Hakki Dogusan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Can't get results from PRAGMA
Hi, (I'm cc'ing to you) Paul Simpson wrote: Hi, (I hope we are not getting off-topic) We seem to be, sorry everyone! I trued e-mailing you directly - I hope you don't mind, but your mail server refused the mail! But I can get messages, as you can see :) I'll prepare a sample Code::Blocks project using SQLite, wx, wxSQLite3. I'll send a message here and your address when ready. [snip] Meanwhile you may want to investigate my BookWorm application - Written in Lua using wxLua, SQLite. ::) -- Regards, Hakki Dogusan http://www.dynaset.org/dogusanh http://www.dogusan.net/dogusanh - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Can't get results from PRAGMA
Hi, (I hope we are not getting off-topic) Paul Simpson wrote: Hi, [snip] Try as I might, I cn't get it working, so I think you have the advantage! I'm trying to get the sample to work first, but I get LOADS of errors at the linking phase (undefined references to things like sqlite3_free.) Any ideas? Config:- IDE MinGW Developer Studio 2.05 Files in project minimal.cpp wxsqlite.cpp sqlite3.h minimal.rc sqlite3.def (I'm using Code::Blocks IDE. If you wish I can send sqlite project file for it. Project file has gcc,vc,bcc,dmc release and debug build targets.) I think you need an import library. Don't know whether gcc creates it with def file automatically. dlltool -dllname sqlite3.dll -d sqlite3.def --output-lib libsqlite3dll.a I really am lost here, all this C++ stuff is new to me. SQL is old hat (I've used it with php, java, Access etc etc) and I'm now of the age (feeling a very old 41!!) where I don't want hassle so I'm not sure that having direct knowledge of the beast is really beneficial! There is a big conflict: You don't want hassle and choosed C++ ;) Seriously, if your project does not need C++ then give a chance to Lua and wxLua. If you can help me get this working, you really will have my eternal gratitude. Let me first sell Code::Blocks to you :) I promise I'll send you a complete wx-sqlite3 sample project! -- Regards, Hakki Dogusan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Can't get results from PRAGMA
Hi, Paul Simpson wrote: Hi, Paul Simpson wrote: Hi, I'm trying to use the dll version of SQLite within an application written in C++ using wxWidgets. [snip] In case you missed, there is already an interface: http://wxcode.sourceforge.net/components/wxsqlite3 -- Regards, Hakki Dogusan Yes, I did miss and thanks, that will save me LOADS of time and effort (although not as much time and effort as it would have done if I HAD seen it earlier... g!) :) Although there is no way to get time back, your effort is not lost. You now have the direct usage knowledge of SQLite, which I never have (I used only interface libraries; wxSQLite and wxSQLite3). Hope it goes well... -- Regards, Hakki Dogusan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Can't get results from PRAGMA
Hi, Paul Simpson wrote: Hi, I'm trying to use the dll version of SQLite within an application written in C++ using wxWidgets. [snip] In case you missed, there is already an interface: http://wxcode.sourceforge.net/components/wxsqlite3 -- Regards, Hakki Dogusan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Sqllite As server
Hi, Vishal Kashyap wrote: Dear All, We have an existing Sqlite application which till now was fine running on single machine. Now we need flexibility of client server model. Is this possible with Sqlite ? . Or alternatively is it possible to use Sqlite db file from shared drives. -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in I wrote a library for this type of usage. I was needed wxSQLite3 implementation which can be used local/or C/S transparently. For server side I'm using Lua bindings of sqlite3. To communicate with server I'm using Yami messaging library. For client side I'm using -higly modified- wxSQLite3 library. All of the communication/usage etc. is enveloped in a simple interface called: DSAS. Although I started to write this for sqlite3 usage, library is more generic now. Maybe You find a usage for it. For download look given address for DSAS. -- Regards, Hakki Dogusan http://www.dynaset.org/dogusanh
Re: [sqlite] Re: Stored Procedure or Functions
Hi Bogusław Brandys wrote: Igor Tandetnik wrote: "Vishal Kashyap" wrote [snipped] Maybe it would be fine and useful to add lua scripting language to sqlite (maybe in shared library to not broke current code ) Regards Boguslaw Brandys Not aimed to implement stored procedures, but I did something can be used for this. It is a library to execute remote lua code. With using wxSQLite3 (and my Lua binding to it) It may be used for stored procedures. Implementation is at: http://www.dynaset.org/dogusanh named: DSAS (I put some sample code using SQLite in it.) -- Regards, Hakki Dogusan