Databases
StackOverflow2013
Postsdbo
POManage data within application
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POManage data within application
    primarykey
    data
    text
    <p>I have a project that will require merging multiple snippets of text together. There will be a record of multiple snippets of text, that depending what boxes a user ticks, will be merged in to a single output file. </p> <p>I suppose you could imagine it as each snippet is a sentence of text that has one or more tags. as then if the user clicked on tag name in the application it would pull out all sentences with that tag in to an array/list. </p> <p>What is the best way to achieve this?</p> <ul> <li><p>I need the users to be able to add new snippets as they go and to be<br> stored when the application is shut down.</p></li> <li><p>Must be easy to copy all the snippets from one instance of the application to another, ideally simply copying a folder, or single file to export/import.</p></li> <li><p>It may have more than 500 snippets of code, each a few hundred lines long. So I'm not sure simply storing each item as a text file would work or would not slow down the application too much. </p></li> <li><p>I don't want a centralized db server. It needs to work completely stand-alone as I can't guarantee the user would have network access. </p></li> <li><p>If it uses a Database needs it to be contained within the app. I don't want the user to need to install a 3rd party app or DB server to use the tool.</p></li> </ul> <p>So how do I go about storing this in a DB and how can I make the date exportable between separate instances?</p> <p>I am sure that I could work together my own DB code, but I am sure that would be horrendous and slow. Is there a standard method that I should be looking at. Don't need to know how to do it. I just want some ideas to look at before I run of down the wrong path. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USslugster
    1. USDevilWAH
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload