RE: [sqlite] sorry for the confusion re: academic software
I'm sorry if this isn't really in line with the current thread, because I've only been reading bits and pieces. If you just want Delphi, have you checked Borland's site lately? They used to give away the personal version of Delphi, as long as you didn't write anything commercial with it. Of course, I don't think it was the latest version, but for free it works. You can also get the Borland command line tools for free, and there are a number of different IDEs on the net that support various compilers. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: jim mcnamara [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 6:13 PM To: [EMAIL PROTECTED] Subject: [sqlite] sorry for the confusion re: academic software hi- i was recently a student but not any longer. I should have grabbed an academic copy of delphi on my way out the door when i graduated from college last year (poor planning...i am kicking myself). I am disabled and work part time and am on ssdi. I confused everyone when I mentioned the classes i use to take and that i was working part-time. It certainly made it seem like i am currently a student and i apologize. I will check maybe with a couple places and see if i can get a deal if i am disabled and do NOT build anything commercial. Maybe they cant get me a price any cheaper than what they already offer but they might take an extra minute to clarify a license issue if am confused. Thanks for writing. I will come up with some ideas eventually. I have lots of free time to think about it. I hope i can write some sqlite software tools or other free software soon. thanks, jim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] getpid() and linux threads in sqlite
Hello, "Mrs. Brisby" <[EMAIL PROTECTED]> 03/06/2004 01:37 PM To: Daniel K <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject:Re: [sqlite] getpid() and linux threads in sqlite > On Wed, 2004-06-02 at 01:53, Daniel K wrote: > > The getpid() call on my Redhat9 linux box is causing > > some trouble for SQLite. It's reasonably complicated, > > but SQLite currently assumes that on linux the > > getpid() function returns a different value in > > different threads. > Anyway, it shouldn't cause any harm. SQLite only uses the pid to help > work around problems with fcntl-locking (esp. when using NFS) and to > seed the random number generator. I believe the software Mr K is working on is sqlite version 3, and that it is file locking issues he's looking into. Benjamin. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Sqlite Secure backup
David Costa <[EMAIL PROTECTED]> 03/06/2004 09:26 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Sqlite Secure backup > I am in the process of writing a PEAR package to handle Sqlite backups > (both local backups and remote backups) and I am looking for some > suggestions. > Is the right way to proceed the db dump ? I assume that copying the db > will result in a corrupted file if the db is used at the time of > backup. Using .dump in the sqlite command-line utility is always going to be the simplest, lowest risk solution. I recommend it, especially for small databases. Using .dump, you don't have to worry about other readers and writers. You don't have to worry about stray -journal files. All of this is taken care of by the engine itself. You end up with a sequence of sql commands that are suitable for rebuilding the sqlite database. This list has a number of advantages over the basic file format: 1) Although sqlite database changes have in the past been forward compatible, it is more likely that the .dump format of an ancient version will be restorable on modern sqlite versions than that the old database files is restorable. 2) .dump output is more likely to be backwards compatible, in case you decide you have to downgrade your sqlite version 3) The dump file is human readible and is more likely to be able to be applied to other database software if the need arises 4) The .dump output is more compressable than the original file format. In gzip form it will usually take up less space than the gzip of the original database file. The only significant downside to the .dump format in my experience is that it takes longer to restore from your media than a straight ungzip would take. this is particularly true if you have large tables with indices. On some (old) hardware I use a 400meg file takes only a few seconds to restore from gzip on backup media, but the equivalent .dump format takes in the order of half an hour to rebuild its tables and indices. If you have large tables and restoration time is critial, the original sqlite files are probably the best thing to backup. If you're more interested in the security of your data, I recommend backing up the .dump output instead. Benjamin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] sorry for the confusion re: academic software
hi- i was recently a student but not any longer. I should have grabbed an academic copy of delphi on my way out the door when i graduated from college last year (poor planning...i am kicking myself). I am disabled and work part time and am on ssdi. I confused everyone when I mentioned the classes i use to take and that i was working part-time. It certainly made it seem like i am currently a student and i apologize. I will check maybe with a couple places and see if i can get a deal if i am disabled and do NOT build anything commercial. Maybe they cant get me a price any cheaper than what they already offer but they might take an extra minute to clarify a license issue if am confused. Thanks for writing. I will come up with some ideas eventually. I have lots of free time to think about it. I hope i can write some sqlite software tools or other free software soon. thanks, jim
Re: [sqlite] help with evaluation of sqlite db tool
Jim, all you need to be careful of is the license that accompanies the academic version. Most prevent the author from using the software for "commercial" purposes (that is generally defined within the license). If you are enrolled in school then you are a student so it wouldn't be dishonest to buy the software at the discounted price. If you intend on developing something to be used commercially just make sure you carefully read the academic license.. -- - Mitchell Vincent - kBilling - Invoice Software - http://www.k-billing.com Darren Duncan wrote: At 2:44 PM -0400 6/3/04, jim mcnamara wrote: I work part-time in an electronics department at a mass retailer. I better not be dishonest and buy academic software. I will look at python free or cheap tools and activestate unless I run across any other ideas. FYI, lots of students work part time to make ends meet. But if they attend classes in a semblence of full time then they are still students. Full time classes means only a small amount of time to work, vs full time work, meaning a lot less money earned. If you are taking a lot of classes then getting educational prices is perfectly fair. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Triggers & last_inserted_id
At 10:53 AM +0200 6/3/04, Pix wrote: No... I need the id of the row inserted by the TRIGGER... the trigger operations should be atomic, so no other db activity should be a problem... I still don't think you need last_insert_id. Try this in your trigger: INSERT INTO OldContacts (ID, name, surname) VALUES (old.ID, old.name, old.surname); UPDATE messages SET contactID = old.ID, contactWasDeleted=true Of course, this version will be different, in that the rows in OldContacts will be exactly the same as those in contacts, including the ids, though the way I see it this conceptually is what should be happening. Your older version, if it works, would not preserve all of the contact row in OldContacts, as the ID value may change. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] help with evaluation of sqlite db tool
IF you are still a student, have you checked out "Educational Pricing" for software at your school's bookstore? > -Original Message- > From: jim mcnamara [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 03, 2004 2:32 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] help with evaluation of sqlite db tool > > > hi- > > i worked on a sqlite db tool a couple of months ago. > i finished the project because i didnt know what direction to go from > there. > i'd like to expand the project and make it bigger with more features. > i was wondering if someone could glance at it and give me some ideas > for the basic features that most people would like to see that are > lacking. > i want to stick to the basics. i only have 2 semesters in c++ and one > semester of cobol programming education. i am just a hobbyist and am > trying to make a little better and more useful program for myself > first and if it ever ends up being something someone else uses > down the road that is great too. > > an example of a suggestion might be that you must include > constraints or limiting the tool to only one db open at a time for > queries is no good and i'd never consider using it without that feature. > please put basic, intermediate, or advanced next to a feature so i can > prioritize. > > one final note. i used visualtcl and love it but the code for the > project is > already around 100k (gui code and application code). i noticed that > namespaces > arent really used with visualtcl . i know that it is very procedural > and xotcl hasnt come up with anything to help with gui design. i'd like > to know > if you recommend another tool for a larger scale project. i cant beat > the visualtcl > price though (free). it is really expensive for me to cough up 1000 > dollars on > delphi or java from borland for a hobby. has anyone used any python > tools > with tkinter for a project larger than 100k? how did you like it if so? > the program is created with visual tcl and tcl/tk. > > the site address is http://j_m_mc.tripod.com > > i know this is lots to ask and if you can answer any part of these > questions i > greatly appreciate it. it gets so boring working 22 hours and then > coming home and doing nothing. customer service gets very repetitive > and > i'd like to have a project to work on that isnt always doing the same > thing. > > thanks so much, > marvin > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Sqlite Secure backup
On Jun 3, 2004, at 2:17 AM, Darren Duncan wrote: At 2:04 AM +0200 6/3/04, David Costa wrote: so in this case you just check if a file .journal exist and if it does you keep that file right ? Yes. But check the sqlite.org website documentation to make sure that is the correct file name. from here http://www.sqlite.org/fileformat.html it looks like is a file with -journal appended. Now (hope will be my last question and sorry again for bothering) am I right to assume that if a -journal file exist something has gone wrong and that file should be part of the backup for the relevant rollback ? Secondly, for testing purposes, how can I create the situation where something doesn't go as planned and the -journal file appears ? thanks David Costa It would be interesting to see how you did it in Perl The function I describe isn't implemented yet, but should be around release 5 or 6 of my Rosetta-Extensions distribution on CPAN ( http://search.cpan.org , that Perl repository which PEAR emulates for PHP ). Meanwhile, the (pre-alpha) API is already documented in the SQL-SyntaxModel distribution under "commands". -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] is there a list of built-in functions?
> is there a browseable list of supported functions such as > date,time,datetime...etc? http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] help with evaluation of sqlite db tool
-Original Message- From: jim mcnamara [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 3:32 AM To: [EMAIL PROTECTED] Subject: [sqlite] help with evaluation of sqlite db tool hi- >>one final note. i used visualtcl and love it but the code for the project is already around 100k (gui code and >>>application code). i noticed that namespaces arent really used with visualtcl . i know that it is very procedural and >>xotcl hasnt come up with anything to help with gui design. i'd like to know if you recommend another tool for a larger >>scale project. i cant beat the visualtcl price though (free). it is really expensive for me to cough up 1000 dollars >>on delphi or java from borland for a hobby. has anyone used any python tools with tkinter for a project larger than 100k? how did you like it if so? the program is created with visual tcl and tcl/tk. I just remembered activestate sells tcl developer tools. they are much cheaper than delphi or java builder. I'd definitely consider using activestate tools. I guess I can use python with the activestate product as well. I'd probably get komodo if I started this project again because it has a gui builder. thanks again, marvin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] help with evaluation of sqlite db tool
hi- i worked on a sqlite db tool a couple of months ago. i finished the project because i didnt know what direction to go from there. i'd like to expand the project and make it bigger with more features. i was wondering if someone could glance at it and give me some ideas for the basic features that most people would like to see that are lacking. i want to stick to the basics. i only have 2 semesters in c++ and one semester of cobol programming education. i am just a hobbyist and am trying to make a little better and more useful program for myself first and if it ever ends up being something someone else uses down the road that is great too. an example of a suggestion might be that you must include constraints or limiting the tool to only one db open at a time for queries is no good and i'd never consider using it without that feature. please put basic, intermediate, or advanced next to a feature so i can prioritize. one final note. i used visualtcl and love it but the code for the project is already around 100k (gui code and application code). i noticed that namespaces arent really used with visualtcl . i know that it is very procedural and xotcl hasnt come up with anything to help with gui design. i'd like to know if you recommend another tool for a larger scale project. i cant beat the visualtcl price though (free). it is really expensive for me to cough up 1000 dollars on delphi or java from borland for a hobby. has anyone used any python tools with tkinter for a project larger than 100k? how did you like it if so? the program is created with visual tcl and tcl/tk. the site address is http://j_m_mc.tripod.com i know this is lots to ask and if you can answer any part of these questions i greatly appreciate it. it gets so boring working 22 hours and then coming home and doing nothing. customer service gets very repetitive and i'd like to have a project to work on that isnt always doing the same thing. thanks so much, marvin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
