EDIT: This post was marked as "duplicate," which I think missed my original point. So I have clarified my question, and I hope it will be re-opened.  I recently came across a situation in which I needed random access to a collection of Python objects. The collection did not fit in memory, so I consulted the .   The documentation mentions two options for non-serial persistence:  and .   shelve is a Python-specific library that works with some kind of Unix built-in. (I'm not familiar with the specifics.) sqlite3 is a widely supported, highly dependable mini-database that is used all over the place.   So my first reaction was to use sqlite3, as it's highly flexible and has a rich ecosystem. But according to , storing pickled Python objects in sqlite3 is considered very bad form.  In the question marked above, it is noted that pickling data into sqlite3 prevents queries within that data. However, there's nothing stopping me from adding two, three, or many columns by means of which I could retrieve cross-sections of the data. shelve does not enable this.  To me, this presents a whole range of use cases that shelve simply does not offer. Nevertheless, in the post noted above, it is claimed that "doing this sort of thing is indicative of bad design," as well as a host of other judgmental statements.  My question is: why is this? Why is doing this a sign of unhealth? I can think of numerous use cases where I might want the flexibility and capacity of sqlite3 without the overhead of a full-fledged database system.
Any gotchas I should be aware of?  Can I store it in a text field, or do I need to use a blob? (I'm not overly familiar with either pickle or sqlite, so I wanted to make sure I'm barking up the right tree with some of my high-level design ideas.)
Should I use Named Pipes, or .NET Remoting to communicate with a running process on my machine? Use a execute command once align vs equation I always use align in my documents, and avoid equation. Is there anything wrong with that? My reasoning behind this: align > equation, so why not use it? Purpose of else and finally in exception handling How do I make a bootable USB from Windows? We let a>0 and b>0 and  we have $\sum_{n=0}^{\infty}b^n-a^n$. We have to find all values a,b>0 where $\sum_{n=0}^{\infty}b^n-a^n$ is convergent. I think I can use that $$\sum_{n=0}^{\infty} b_n &lt; \infty , \sum_{n=0}^{\infty} a_n &lt; \infty \implies \sum_{n=0}^{\infty} (b_n-a_n) &lt; \infty. $$. And I think $\sum_{n=0}^{\infty}b^n$ and $\sum_{n=0}^{\infty}a^n$ is convergent if a&lt;1 and b&lt;1? It will make sense. But how can I show it? How to change password complexity requirements in Ubuntu 14.04LTS Can misused Schema.org hurt SEO? I've inherited a site where I noticed that    there is an excessive use of Schema.org in all navigation elements pages describing products are marked as itemtype="http://schema.org/CreativeWork"   So I'm wondering if these tags are sending the wrong message and not truly optimized. I realize that the nav (1) is done in some themes, but I'm more worried about (2). Can it be a hit SEO-wise to mislabel pages instead of products? Gravatar profile image not showing sometimes It seems that with some profiles the Gravatar image is broken. I am not sure if this is an issue with SE or Gravatar, or both, so posting here.  As an example,  shows an error on , which shows a HTTP 500 on Gravatar.  Profile image on SO:        Image on Gravatar:        Switching to the MSE profile of the user, the image is working (but has a different hash).  Is this a bug on the SE side? Can anything be done to make Gravatar fix this?    Update 2016-10-04:  It happened to me again two times today. The last user profile was . Calling the service two or three times fixes the issue. Statistics interview questions Proving or disproving inequality $ \frac{xy}{z} + \frac{yz}{x} + \frac{zx}{y} \ge x + y + z $ 8.4 - Use entity browser in a module block from in same way as I would in a custom block I am having trouble adding an image picker to a block form defined in a custom module.  If I create a custom block type I can define an image field as entity_reference and in the block's form view tell it to use entity_browser and media_entity_browser.  This provides me with an picker with which I can select my image:    I am trying to recreate this in a block provided by my custom module, without much success  // /src/Plugin/Block/MyCustomBlock.php  function blockForm($form, FormStateInterface $form_state)  {     ...      $form['image'] = [       '#type' =&gt; 'entity_browser',       '#entity_browser' =&gt; 'media_entity_browser',       '#title' =&gt; $this-&gt;t('Image'),       '#default_value' =&gt; $this-&gt;configuration['image'] ?? null,       '#weight' =&gt; '0',     ];      ... }   This gives me the following.  Note the lack of the bounding box, title and option to edit remove items:     Exporting the configuration files for the working form view gets me this:  // core.entity_form_display.block_content.lead_block.default.yml      ...  field_image:     weight: 1     settings:       entity_browser: media_entity_browser       field_widget_display: rendered_entity       field_widget_edit: true       field_widget_remove: true       selection_mode: selection_append       field_widget_display_settings:         view_mode: default       open: false     third_party_settings: {  }     type: entity_browser_entity_reference     region: content   ...   But if I try and use 'type' =&gt; 'entity_browser_entity_reference' in my blockForm function the field disappears altogether.  Looking into various core files I can see that entity_browser is a @FormElement and entity_browser_entity_reference is a @FieldWidget but I don't really understand the difference.  As you might guess I am fairly new to Drupal and I feel like I am missing something fundamental.  I (think I) understand that custom block types are actually nodes internally and that they are subject to different rules to blocks which I define in my custom modules, but I don't fully grasp what the differences here are.  Is is it possible to use the entity browser in my custom module block form in the same way as it is used in the form which I build through the admin's custom block type builder?  Thank you. Word for someone who pays attention to details QGIS ->ArcGIS Server configuration possible? Is it: My apples and orange are/is wrong? Simple question:     My apples and orange are wrong   or     My apples and orange is wrong   I am not a native English speaker, and I am having some trouble choosing between plural are or singular is for that kind of example. I have been playing for almost 2 days, and today it is asking me to sign up again.  I have all my game saved in my google account, but I wonder if I just log in from a trainer account will I keep my progress? Changing isometric drawing's constraint angles in Illustrator HTML from advertisement not rendered correctly I have many times found CSS written on my screen besides images from Stack OverFlow.   It is associated with the advert from Rackspace  Here is a screenshot: Keras CNN with low/constant accuracies Leave Convert to Edit button enabled all the time in the moderator flag list In the moderator flags list, there is a &quot;Convert to Edit&quot; button on answers which are posted by the person who posted the question. This button is disabled at times, and I am not sure that the algorithm used is useful. My proposal is that the Convert to Edit button in the flag list should always be enabled, as it seems fairly frequent that it's disabled when it would be useful. Justification When the button is disabled, it is required that we pop open the answer view in the flag list, and use the regular Mod menu and choose convert to edit there. When we do that, however, we experience this issue:  (that should also be fixed, by the way!) Here are two items currently in the queue:    Note that one has the button enabled, while the other does not. The only differences I can see in those two answers is the age and the number of answers. Neither question has an accepted answer, but the one with the button disabled only has that single answer. I've only just now noticed that difference with these two posts, so I'm not 100% sure if that's the determining factor. 1 It is perhaps coincidental, but these buttons being (dis)abled are reverse of the action needing to be taken. The one with the disabled button needed to be converted to an edit; the one with the enabled button was an attempt to answer their own question. If I'm right about the determining factor here (that the answer is the only one), I'm not sure that's useful. A good bit of the time, an asker will post an answer due to people requesting additional information. In such cases, it seems like it will be likely there are no other answers. 1  Note 1: I was looking to create a userscript to enable these buttons, and I found something that I think is related as to the reason. It looks like the ones which are disabled are on answers which have comments on them. I noticed the title attribute of those buttons says, &quot;There are comments on the post. Please review&quot;. That does seem to make some sense in theory. However, it still seems like I am often converting them, anyway. With the above-linked, separate issue regarding how the 'mod' link on the expanded view works, this is still a bit of an impediment to our workflow. It occurred to me to check if the button was reenabled once you expanded the view, but it does not. Maybe that's an alternate solution. My plan for my userscript is to enable the button, but change the text color (and leave the title attribute), to point out that there are comments.