SQLite is well suited for these types of applications. It has no engine (process) that runs, just a flat file with a client that can be used to access it using standard SQL syntax. It is available as a work released into the Public Domain.
http://www.sqlite.org/ Axton On Fri, Oct 9, 2009 at 11:37 AM, LJ Longwing <[email protected]> wrote: > ** > Well Jason, many hands make light work :)....so I encourage you to dust off > your C++ skills and join us on a worthy journey....the DB I was referring to > was more of a flat file kinda thing that wouldn't need an engine....but > hmmm...what about it having an option of being a Remedy app that stored its > stuff in forms?....who knows if that would work....one of the things I > always loved about ARInside when I was a simple user was the ability to > 'deliver' documentation to a client for a product I developed....I gave them > a CD that contained all of the design docs, etc...with a folder for the > documentation...it was awesome...I dunno...would it be better to have less > files, but the same information?...like maybe all field information for a > form was in a single file with bookmarks instead of each field having its > own file... > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Jason Miller > Sent: Friday, October 09, 2009 10:14 AM > To: [email protected] > Subject: Re: ARInside 3.0 Beta > > ** > On the subject of keeping a db... What is the feasibility of storing the > data in a db vs. +100k html files at over 1gb of disk space (and this isn't > even ITSM 7)? I would think if the object id's are maintain in a db then > the data could be normalized and alleviate all of the data that is now being > duplicated to link all of the html files every which way. This could also > add searching capabilities. > > The down side I see is now this is another db/web app that administrators > need to maintain instead of a ton of "dumb" html files you place on a web > server. However... With a full blown app maybe you could do such things > as keep previous version and restore/migrate straight to a server? > > Now that I have thrown all of that out there I guess I should pick up C++ > again so I can help out. > > Jason > > On Fri, Oct 9, 2009 at 7:35 AM, LJ Longwing <[email protected]> wrote: >> >> Hey Misi, >> Before I got into the code, I wondered the exact same thing, unfortunately >> the ability to do that is limited with the current design. As ARInside >> grabs objects from the server (in the order it grabs them, which can be >> different each time), it assigns an 'internal id' to the object, and that >> internal id is what it uses to process objects. To do a 'difference' run >> you would need to keep a db of some sort around of what your object id's >> were for your last run, and then assign them back to the same id's on the >> next run. It's definitely possible, but is a rewrite of a significant >> part >> of the code I think....that's not to say it won't be done, just that it >> won't be 'now'...:)....if you want, please feel free to log it as an >> enhancement request though :) >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of Misi Mladoniczky >> Sent: Friday, October 09, 2009 1:15 AM >> To: [email protected] >> Subject: Re: ARInside 3.0 Beta >> >> Hi, >> >> In theory, it should be possible to leverege the modify-time of the server >> objects to do an incremental update of the previous run. >> >> All ARGetList*()-functions has a last-modify-date parameter, to allow >> retrieval of changed objects. >> >> You will also need to remove any objects that has been deleted. >> >> This would be a really good improvement on performance. >> >> I have not looked at the code (yet...) though. >> >> Best Regards - Misi, RRR AB, http://www.rrr.se >> >> Products from RRR Scandinavia: >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. >> * RRR|Translator - Manage and automate your language translations. >> Find these products, and many free tools and utilities, at http://rrr.se. >> >> > We ran it against a 7.1 and 7.5 server with Help Desk, SLA 6 and a ton >> > of custom apps with no issue. I didn't notice any change in >> > performance. >> > The >> > batch file we use to kick it off logs the start and stop time. It >> > still averaged about 4.75 hours for both servers. >> > >> > It is much cleaner now with the default of not being verbose and the >> > web service stuff looks great! >> > >> > Thanks for keeping this alive. >> > >> > Jason >> > >> > On Thu, Oct 8, 2009 at 1:04 PM, LJ Longwing <[email protected]> >> > wrote: >> > >> >> Definitely good to hear. We are apparently having issues with some >> >> 7.5 ITSM that we are working on, but that's the only issue we have >> >> encountered thus far. We have also added web service setfield >> >> input/output mapping information, so you can now see what fields are >> >> mapped to what elements.... >> >> >> >> -----Original Message----- >> >> From: Action Request System discussion list(ARSList) >> >> [mailto:[email protected]] On Behalf Of Misi Mladoniczky >> >> Sent: Thursday, October 08, 2009 1:37 AM >> >> To: [email protected] >> >> Subject: Re: ARInside 3.0 Beta >> >> >> >> Fantastic work!!! >> >> >> >> It ran like a charm. >> >> >> >> Best Regards - Misi, RRR AB, http://www.rrr.se >> >> >> >> Products from RRR Scandinavia: >> >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >> >> logs. >> >> * RRR|Translator - Manage and automate your language translations. >> >> Find these products, and many free tools and utilities, at >> >> http://rrr.se. >> >> >> >> > I'm pleased to announce the start of the 3.0 Beta for ARInside. >> >> > Please head out to http://www.arinside.org/downloads to get the >> >> > latest copy. >> >> > >> >> > Below you will find a list of the enhancements and bug fixes done >> >> > thus far. >> >> > We are working on getting this to be cross platform capable at some >> >> > point as well. Please log onto http://www.arinside.org/newticket >> >> > to log any issues with the beta so we can get them fixed before we >> >> > finalize anything. >> >> > >> >> > Enhancements >> >> > Added support to parse 'Special Runprocess Commands' for form and >> >> > field information Modified output of application to be brief, moved >> >> > most output to the -v command line parameter Modified Selection >> >> > Label display to properly display enumerated values Added >> >> > granularity to containers inside containers, it now tells you what >> >> > type of container it is (AL Guide, Packing List, etc) Field >> >> > references in Indexes now link to the index page for the form Added >> >> > full support for Date and TimeOfDay fields Optimized speed of the >> >> > get server info from the server Added 'Status History' references >> >> > where appropriate Added 'Error Handler' references Added Escalation >> >> > Pool to the information displayed about an Escalation Added a new >> >> > 'RunNotes' section to settings.ini to allow for run documentation >> >> > Enhanced performance of setfield actions Added 'Hover' and 'Template' >> support Added 'Tooltip' >> >> > message support Added 'Service' execute on support for Filters >> >> > Added additional 7.1 and 7.5 AL Execute on conditions Upgraded API >> >> > from >> >> > 7.0.1 to 7.5 Added support for form settings of 'Entry Point', >> >> > 'Archive', and 'Audit' >> >> > Added enhanced options added with 7.1 release >> >> > >> >> > Defect Fixes >> >> > when an Exclude list was specified, the exclude list itself was >> >> > processed wasting time If Field ID was > 10 characters the app >> >> > crashed Selection Fields with custom numbering weren't referencing >> >> > in workflow references properly Menus specified in exclude list >> >> > were still processed Visibility of fields in 'Change Field' actions >> >> > wasn't processed properly 'Wait' and 'Goto' AL Actions weren't >> >> > properly documented Default value of Integer was showing (null) >> >> > when it should have been 0 Not all Server Info and field properties >> >> > were being displayed properly 'Run Time' was not being calculated >> >> > properly Corrected () placement in setfield if statements SQL Menu >> >> > Labels were not displaying properly SQL Set Field actions from >> >> > another server were displaying current server >> >> > >> >> > >> >> > ___________________________________________________________________ >> >> > ___ _________ UNSUBSCRIBE or access ARSlist Archives at >> >> > www.arslist.org Platinum >> >> >> >> Sponsor:[email protected]<sponsor%[email protected]>ARSlist: >> >> "Where the Answers Are" >> >> > >> >> > -- >> >> > This message was scanned by ESVA and is believed to be clean. >> >> > >> >> > >> >> >> >> >> >> _____________________________________________________________________ >> >> _______ >> >> ___ >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum >> >> Sponsor:[email protected] >> >> <sponsor%[email protected]>ARSlist: "Where the Answers Are" >> >> >> >> >> >> _____________________________________________________________________ >> >> __________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> >> Platinum >> >> >> >> Sponsor:[email protected]<sponsor%[email protected]>ARSlist: >> >> "Where the Answers Are" >> >> >> > >> > ______________________________________________________________________ >> > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > Platinum Sponsor:[email protected] ARSlist: "Where the Answers >> > Are" >> > >> > -- >> > This message was scanned by ESVA and is believed to be clean. >> > >> > >> >> >> ____________________________________________________________________________ >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum >> Sponsor:[email protected] ARSlist: "Where the Answers Are" >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
