Good point. I guess I'm just used to storing disposable data in disposable variables. I won't worry too much about it seeing as I already have it working and focus on getting the editing elements working now.
Thanks for the feedback. On Monday, 8 September 2014 22:38:39 UTC+1, Derek wrote: > > The best way would be sqlite. It's certainly not overkill. > If you don't know what sqlite is, look here: > http://www.sqlite.org/about.html > > It's a very easy read... the way they describe it: Think of SQLite not as > a replacement for Oracle <http://www.oracle.com/database/index.html> but > as a replacement for fopen() <http://man.he.net/man3/fopen> > so yea, you're doing it right. I wouldn't bother storing it in ram, since > as you said it's not a lot of data, which means that disk access times will > be minimal as well. > > you could try putting the data in your session object, but that would > likely be stored on disk as well, so better leave it as sqlite in that case. > > The other option is redis, but if this is only one machine, it would be > pointless for that.. > > in other words, you have a small file, and you are complaining about > storing it on disk? why? too much disk space? too much work? Does it make > that much of a difference if it takes 15ms to access or 1ms? > > On Monday, September 8, 2014 3:59:39 AM UTC-7, Niels Jensen wrote: >> >> Hi All, >> >> I've just started learning Python and have a decent understanding on the >> core elements. Most of my programming experience prior to Python was >> vb.net, which I'd use it to put together some simple applications that >> would help me automate some tasks at work (I'm a sysadmin). I wanted to >> step away from a single platform and look at app development that didn't >> depend on the OS that was used. >> >> So I developed my first Python application which uses Paramiko to SFTP a >> DNS config file from my enterprise's central DNS servers. It then parses >> the file and pulls out the zones and relevant data that's then stored in a >> list of tupples. >> >> I then thought wouldn't it be great to display these zones in a nice >> tabular format that can be edited. Did some research and found web2py. >> I've since run throuth the Overview section of the docs and built my first >> Web2Py App. Instead of saving the information to a list of tupples, it now >> saves it to a SQLite DB (which it truncates each time the config file is >> fetched). I can then use SQLFORM.grid to generate a nice looking table in >> my app. I've not got to the editing part yet, but that will come in time. >> >> The issue I have with the above method however is that is seems a little >> overkill to use a fully functional db. In vb.net, I'd create a >> datatable in memory and manipulate the table before writing the changes >> back to the config file when told to do so. As any of my colleagues may >> change the DNS config file at any time, loading the config file as required >> into RAM makes more sense to me than loading it into a database. >> I looked at how I might do this in Python and it seems that I can load a >> SQLite db into memory or the user's session but from what I can see in >> various searches, people are saying that this may not be a good idea. >> >> So I'm just wondering what would be the best way to do this? Any advice? >> >> Thanks >> Niels >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
