I am currently learning how to use database in Android. For one of my app, I need to stock 500 string values in order to read them. Actually to fill my database, I read a .txt file at the database creation with all the string values inside. For each lines of .txt (corresponding to a string value), I create a new data in the database. The thing is I know that accessing a file can be long it is not a very good thing if there are thousands of values. According to that, I have two questions :   Is it really usefull to create a database ? (because I can directly access the string values by reading the .txt) Is there a better way to fill the database ? Or a way to create a database already filled before the activity creation ? (because currently, each time you close the activity you close the database and each time you reopen it, it recreate and refill the database.)
If your application requires a database and it comes with built in data, what is the best way to ship that application? Should I:   Precreate the SQLite database and include it in the .apk? Include the SQL commands with the application and have it create the database and insert the data on first use?   The drawbacks I see are:   Possible SQLite version mismatches might cause problems and I currently don't know where the database should go and how to access it. It may take a really long time to create and populate the database on the device.   Any suggestions? Pointers to the documentation regarding any issues would be greatly appreciated.
What is the purpose of -e in sed command? I can't find any documentation about the sed -e switch, for simple replace, do I need it?  e.g.  sed 's/foo/bar/'   VS  sed -e 's/foo/bar/' A map is continuous if and only if for every set, the image of closure is contained in the closure of image As a part of self study, I am trying to prove the following statement:  Suppose $X$ and $Y$ are topological spaces and $f: X \rightarrow Y$ is a map. Then $f$ is continuous if and only if $f(\overline{A})\subseteq \overline{f(A)}$, where $\overline{A}$ denotes the closure of an arbitrary set $A$.   Assuming $f$ is continuous, the result is almost immediate. Perhaps I am missing something obvious, but I have not been able to make progress on the other direction. Could anyone give me a hint which might illuminate the problem for me? Is using std::deque or std::priority_queue thread-safe? Disk Utility won't Unmount HD for formatting Why do people call their characters "toons"? I've seen that in games like MMORPGs and the Diablo series, where the player has an "arsenal" of several characters, people refer to their characters as "toons".  What is the origin of this term? Uncertainty in parenthesis I have used the code shown below to draw a static CMOS inverter. I have tried to use the TikZ library calc to calculate the point at which drains of the PMOS and the NMOS devices meet; and the mid-point of the line which connects the gates of the two devices. Apparently calc gets the y coordinates of the points right. However, calc seems to get the x coordinates of the points wrong. What could I be doing wrong?  Here is the TikZ code:  \documentclass{standalone} \usepackage[americaninductors]{circuitikz} \usetikzlibrary{calc} \begin{document} \begin{circuitikz} \draw % Draw MOSFETs: (0,0) node [pigfete,yscale=-1,anchor=S] (M1) {} (M1.D) node[nigfete,anchor=D] (M2) {} (M1.G)--(M2.G) % The line connecting the gates of the MOSFETs. ; % Draw the power rails: \draw ($(M1.S)-(2.0,0)$) -- (M1.S) -- ($(M1.S)+(1.2,0)$); \draw ($(M2.S)-(2.0,0)$) -- (M2.S) -- ($(M2.S)+(1.2,0)$); % Input and output nodes: \node (I) at ($0.5*(M2.G)+0.5*(M1.G)$) {}; % The mid-point between the gates. \node (O) at (M1.D) {}; % The point at which the drains of the MOSFETs are conneted. % The Input and output lines. \draw ($(I)-(.8,0)$) -- (I); \draw (O) -- ($(O)+(0.8,0)$); \end{circuitikz} \end{document}   Here is the figure that I get: Note that that input and the output lines are not connected to the rest of the circuit. Can we attribute the problem of the lines not being connected, to the rest of the circuit, to the way I am using calc? How to find files that contain one criterion but exclude a different criterion How do keyboard input and text output work? How to run a LaunchAgent that runs a script which causes failures because of System Integrity Protection After upgrading to Mojave, my rsync based backup script run via a launch agent in ~/Library/LaunchAgents, could no longer read some directories in ~/Library. Check the uniform convergence of series of functions Check that given series converges uniformly for $x\in(-\pi,\pi)$ or not  1) $\sum_{n=1}^{\infty} (\frac{x}{n})^n$  2) $\sum_{n=1}^{\infty}\frac{1}{((x+\pi)n)^2}$  first series is power series so I find the radius of convergence that comes $R=e$ which is inside the given set so I am not able to give the final conclusion. after this I were thinking to apply $M_n$ test , but I am not able to find $M_n$. Please help to solve this problem. The   echo one; echo two &gt; &gt;(cat); echo three;    command gives unexpected output.  I read this:  and many other articles about process substitution on the internet, but don't understand why it behaves this way.  Expected output:  one two three   Real output:  prompt$ echo one; echo two &gt; &gt;(cat); echo three; one three prompt$ two   Also, this two commands should be equivalent from my point of view, but they don't:  ##### first command - the pipe is used. prompt$ seq 1 5 | cat 1 2 3 4 5 ##### second command - the process substitution and redirection are used. prompt$ seq 1 5 &gt; &gt;(cat) prompt$ 1 2 3 4 5   Why I think, they should be the same? Because, both connects the seq output to the cat input through the anonymous pipe - .  Question: Why it behaves this way? Where is my error? The comprehensive answer is desired (with explanation of how the bash does it under the hood). Change Text Color in Blender Game Engine? I want to change the color of some text in my game. I've tried adding materials, but whenever I press P to play the game, the text stays the same white color. Any ideas? Mysql crashed, dumped DB's in recovery mode. What now? Seeking world map with boundaries of regions and communities for commercial use? This is an unproven proposition I've come across in multiple places.   Suppose $A$ is a commutative Noetherian ring, and $S$ a multiplicative subset of $A$. Then $S^{-1}A$ is Noetherian.  Why is this? I thought about taking some chain of submodules $$ S^{-1}M_1\subset S^{-1}M_2\subset\cdots $$ and pulling back to a chain  $$ M_1\subset M_2\subset\cdots $$ of submodules of $A$ which must eventually stablize. Is there more to it than this? I kind of wary of assuming all submodules of $S^{-1}A$ have form $S^{-1}M$ for $M\leq A$. Changing permissions on serial port I'm using the Arduino IDE in Ubuntu, and am having issues with the serial port. It has worked in the past, but for reasons that may be unnecesary, I felt the need to change the ownership of some of the files from root ownership to my users ownership.  This made the IDE work correctly, but I lost the ability to use the correct serial port.  In the dev folder, the port I need is listed as permission 166. Someone (who is no longer in the area to help me) swapped the permissions to 666, which made it all work gloriously.  However, it reverted back as soon as I restarted my computer, and if I now try to use the command:  sudo chmod 666 ttyACM0   nothing happens. No error messages, but no permission change either.    How can I change it, and how can I get it to change permanently.  I apologize if this question is overly simplistic or unclear, I'm an ubuntu noob, and I wouldn't begrudge feedback! Hide parameterless constructor on struct Understanding the definition of the order of an entire function in Ahlfors's Complex Analysis Let $f: \mathbb C \to \mathbb C$ be an entire function. The order of $f$ is defined by $$\lambda=\limsup_{r \to \infty} \frac{\log \log M(r)}{\log r}, $$ where $$M(r)=\max_{|z|=r} |f(z)| .$$  Ahlfors in his Complex Analysis claims that     "According to this definition $\lambda$ is the smallest number such that       $$M(r)\leq e^{r^{\lambda+\varepsilon}} $$ for any given $\varepsilon &gt; 0$ as soon as $r$ is sufficiently large."   Why is this true?  My attempt:  We know that $$\lambda=\lim_{\rho \to \infty} \sup_{r \geq \rho} \frac{\log \log M(r)}{\log r}. $$  From the definition of the limit we have that for any $\varepsilon&gt;0$, there exists some $\rho_0&gt;0$, such that $$\left\lvert \sup_{r \geq \rho} \frac{\log \log M(r)}{\log r}-\lambda \right\rvert \leq \varepsilon ,$$ for every $\rho \geq \rho_0$. In other words $$\frac{\log \log M(r)}{\log r} \leq \lambda+\varepsilon $$ for every $r \geq \rho_0$. From here it is easy to see that $$M(r)\leq e^{r^{\lambda+\varepsilon}}, $$ for all $r \geq \rho_0$. I cannot see why $\lambda$ is the smallest number with this property.  Thanks in advance. How To Display Too Much Data We're building a web-based platform where the main dashboard shows a table of data for users to view and analyze. As we're growing this tool, we seem to be adding more and more columns and are running out of horizontal space on smaller screen resolutions (we're seeing some data wrap). It is important to the user to view all columns at once, so column hiding is somewhat out of the question, as is horizontal scrolling (per the boss's request and because horizontal scrolling sucks anyways). I was wondering if anyone knew of a clever UI for tables with many columns.  EDIT  Below is a screen capture of the layout of the table. Unfortunately for security purposes I had to blur out the column titles. This example has rows with practically no data in them, but in use they will have lots of data that will expand wider than their respective column titles. In response to some of the answers, it is imperative that the user see all the columns, as they are all necessary to analyze the data to make certain decisions. All the data is numeric aside from the first three columns. Thanks again for any feedback.    Ok so I see that uploading this image doesn't really do it justice... it takes up the full width of the screen at 1680x1050 resolution (22") and as data fills in the columns, the left column w/the text shrinks down a bit.  EDIT 2 I just wanted to say thank you to everyone's awesome ideas. I can only select one answer, but a lot of your ideas have proven very useful and may end up in the final product. Thanks again!