http://blog.gmane.org/gmane.comp.db.metakit hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.metakit/2370 <pre>Is there anyone who could help get a version of metakit with python on windows? I attempted to use the pre-compiled version from the site which does not work. (Spits out a "module Mk4py not found"). Could either a pre-compiled python version working or a step-by-step guide to get a version compiled. Thanks for your help and time -- Thadeus </pre> Thadeus Burgess 2011-03-31T16:41:08 http://comments.gmane.org/gmane.comp.db.metakit/2369 <pre>Is it possible to quickly extract a list of a single column without having to do list comprehension? -- Thadeus </pre> Thadeus Burgess 2011-03-30T15:21:59 http://comments.gmane.org/gmane.comp.db.metakit/2362 <pre>Are there any good detailed comparisons of metakit vs HDF5 (mk4py vs pytables). -- Thadeus </pre> Thadeus Burgess 2011-03-28T21:20:53 http://comments.gmane.org/gmane.comp.db.metakit/2359 <pre>What happens when the file goes over 1.5GB ? In my testing, generating random data to provide a metakit file of about 2GB (about 11milliion records). Metakit seems to be able to open and parse the file as normal. Is there any specific reason the GB file limit has been placed? -- Thadeus </pre> Thadeus Burgess 2011-03-28T20:13:12 http://comments.gmane.org/gmane.comp.db.metakit/2358 <pre> I have a view that contains ~20,000 rows. Each row has a startedAt property, when the action began. I would like to get the 20 most recent actions. Using the Tcl interface I tried all sorts of things, for example: foreach row [mk::select logdb.log -rsort startedAt -count 20] { puts $row } That simply returns 19 18 17 16 15 14 ... 0 ... Those are the oldest ones (not in order). I also tried: mk::select logdb.log -rsort startedAt -start [expr {[mk::view size logdb.log] - 20}] but that didn't work either as the entries are not placed in the db in sequence according to date. That returned the last 20 rows in what seemed to be in random order. I typically program with SQL and what I want to accomplish is this: SELECT * FROM log ORDER BY startedAt DESC LIMIT 20 How can I accomplish this using the Tcl interface to MetaKit? Thanks, Jeremy Cowgar </pre> Jeremy Cowgar 2010-09-14T00:10:46 http://comments.gmane.org/gmane.comp.db.metakit/2357 <pre>Hello everyone, I'm "testdriving" metakit 4 py now, and I have a little trouble with hashed view: when the number of keys in view starts exceeding 2000, filling up a hash view becomes extremely slow. Is there some way to fill a view that is hashed to begin with, so the db knows its way around db and adding rows becomes faster? The code is below. Also, could someone please explain to me what's the meaning of 'del map[:]' in def hash_ini(n=1000): t0 = time(); for i in xrange(n): del map[:] vwh = vw.hash(map) print ' hash_ini %d times, size %d: %g sec' % (n, len(map), time() - t0) in examples/find.py in metakit distribution? And why vw.hash(map) has to be repeated n times? Sadly, the docs do not explain what's this all about. #!/usr/bin/python ##import wingdbstub import Mk4py, sys mk = Mk4py print sys.argv[0], '- Mk4py', mk.version, '-', sys.platform db = mk.storage("demo2.db",1) vw = db.getas('words[idxs1:S,idxs2:S,idxi:I,val:S]') map = db.getas('map[_H:I,_R:I]') vwh = None def fillit(): num = 0 for line in open('testfile.txt'): vw.append(val=line, idxs1=line[:2].lower(), idxs2=line[2:4].lower(), idxi=num) num +=1 if num % 1000 == 0: print num db.commit() def fillithash(): num = 0 for line in open('testfile.txt'): vw.append(val=line, idxs1=line[:2].lower(), idxs2=line[2:4].lower(), idxi=num) num +=1 if num % 1000 == 0: print num print map for i in xrange(num-1): del map[:] vwh = vw.hash(map) if i % 100 == 0: print i db.commit() def selall(): vwh = vw.hash(map) for r in vwh: pass if __name__ == "__main__": fillithash() selall() </pre> Marcin Krol 2010-03-04T19:37:48 http://comments.gmane.org/gmane.comp.db.metakit/2353 <pre>Hello: Thanks again for Metakit... Big fan... When the size of the data in my application is reduced, I would like to reflect this in the size of the associated data file. The Metakit file format documentation states: "For those cases where slack is unacceptable, a simple full re-save can be used to produce a fresh, optimally-packed datafile." Given a c4_View created with a backing c4_Storage (which is associated with a file), how do I do a "full re-save" ??? Here, again, my goal here is to reduce the size of the data file by removing all of the "free space". Thanks. Bill </pre> Bill 2009-11-11T19:41:07 http://comments.gmane.org/gmane.comp.db.metakit/2352 <pre>Dear Members List, I'm using Metakit to store data sent by a lab analyser each 1 second. I have a doubt if I should open, commit and close the database every time to store data or should store data in a variable and store a package of data in database to decrease the disk access. Thanks for any sugestion, Jose </pre> Jose Brasil 2009-11-02T14:09:15 http://comments.gmane.org/gmane.comp.db.metakit/2351 <pre> Hi. Has anyone succeeded in compiling Metalkit and interfacing it with Lua on Windows using MingW? If there's such a person, would you kindly post the instructions here? Thank you! Yasuro --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "metakit" group. To post to this group, send email to metakit&lt; at &gt;googlegroups.com To unsubscribe from this group, send email to metakit-unsubscribe&lt; at &gt;googlegroups.com For more options, visit this group at http://groups.google.com/group/metakit?hl=en -~----------~----~----~----~------~----~------~--~--- </pre> Yasuro 2009-10-30T10:21:44 http://comments.gmane.org/gmane.comp.db.metakit/2350 <pre> Dear Members List, I intend to use Metakit for Tcl and I joined to this group to exchange informations about Metakit in Tcl applications. And many thanks for Mr. Jean-Claude Wippler for his work, which helps many people in their jobs around the world. Best regards, Jose Brasil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "metakit" group. To post to this group, send email to metakit&lt; at &gt;googlegroups.com To unsubscribe from this group, send email to metakit-unsubscribe&lt; at &gt;googlegroups.com For more options, visit this group at http://groups.google.com/group/metakit?hl=en -~----------~----~----~----~------~----~------~--~--- </pre> Jose 2009-10-28T10:53:00 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.metakit