What is Reddit's opinion of DB Browser for SQLite?

From 3.5 billion Reddit comments

Try opening the files using this: http://sqlitebrowser.org/. Chances are he used a database library and Sqlite is one of the most used.

Edit: If that doesn't work if you post the first couple lines of one or a couple of lines I may be able to give you a clue.

Hey fam you can still see how many times you've downloaded from DogNZB for Sonarr. Grab a DB browser like http://sqlitebrowser.org/ if you're on Windows. Navigate to nzbdrone.db C:\ProgramData\NzbDrone with DBbrower, open and Execute SQL tab.

SELECT SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12, INSTR(SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12), '",') - 1) AS IndexerName, COUNT(*) AS GrabCount FROM History WHERE DATA LIKE '%indexer%' GROUP BY IndexerName ORDER BY GrabCount DESC

And this db of mine was created on November ‎11, ‎2017. https://i.imgur.com/hSLTj4d.png

If you are familiar with SQL syntax, pointing a SQLite Browser at your Plex database is probably the easiest way to aggregate your library data.

Here's a free one : http://sqlitebrowser.org/

edit: and if you need help writing a query I'd be happy to help

If you want a really quick and accessible introduction, check out Simon Allardice's Foundations of Databases series on Lynda.com; it's US$30 for a month's access, and you can often get it free with a library card. Then check out some of the Stanford mini courses on it, particularly Intro, Relational Algebra, SQL, Indexes & Transactions, and Constraints & Triggers. You can watch them for free, and Stanford's series on it is particularly good because it includes the why when many just include the how. Less rote memorisation.

I'd recommend downloading a sample database (here is the popular Northwinds database, representing the records of a fictional company) and practicing doing things with it as you go along. Also grab this visual SQLite tool, which lets you create a database in a simple file and construct its tables visually, then practice querying them and directly viewing result sets; it's a good way to focus on the SQL/DB stuff alone without bringing the C# layer, server and user configs, etc into it (and even outside of the tool SQLite is just massively useful).

Manually, which is probably possible with only few items to add or edit I am using sqliteman which is quite old but it seems that newer alternative could be http://sqlitebrowser.org/

The messages are saved as an sqlite database in ~/Library/Messages/chat.db

So at least in theory it should be simple to find anything you need, since the data is neatly organized! The only hard part is learning SQL. Which, depending on what you're trying to do, actually isn't too hard! If you're not familiar with relational databases, just think of them as big Excel spreadsheets with rows and columns. Each message lives in a spreadsheet with a column describing who sent it, whether it has attachments, whether you've read the message, etc.

You can try downloading something like this open source SQLite browser, opening the chat.db file (just to be safe, maybe copy it to your desktop first), and running a query like this:

SELECT text FROM message WHERE text LIKE '%address%';

Which should return a list of every message containing the string "address".

Or Apple could change the iMessage app.

Once you have collected the scan data close pokemongo-map and copy your pogom.db file somewhere else.

Then use sqlitebrowser (http://sqlitebrowser.org/) to open that file and extract the tables gym and pokestops on Excel files (separated each).

Then edit it in excel or something alike to order the data into 3 columns: description, latitude, longitude. (in both files)

Save said tables as CSV or XLSX

Go to https://www.google.com/mymaps and create a new map. New layer -> Import -> Drop the file (for Gyms and again for Pokestops)

That will get you a nice map of all the gyms and pokestops in a formatting you can share with your friends.

For completeness you can use this post to extract the spawn data in a googlemaps-friendly output:

https://www.reddit.com/r/pokemongodev/comments/4wp2cp/get_your_own_unique_spawn_map_for_your_area/

Check in the comments of that post there is improvements to even add icons. This will not tell you wich pokemon there is right now, but at least mark the spawn point and the spawn time to be able to predict future spawns.

Have fun!

Oops. Running SQL through the API is broken.

1. Shut down PlexPy.
2. Open your plexpy.db file using http://sqlitebrowser.org/

3. Go to the "Execute SQL" tab and run the following SQL:

   DELETE FROM session_history WHERE id NOT IN (SELECT id FROM session_history_metadata); DELETE FROM session_history_media_info WHERE id NOT IN (SELECT id FROM session_history_metadata);

4. Save (write changes) and close the database.

5. Restart PlexPy.

From https://forums.macrumors.com/threads/where-are-previous-recipients-now-stored.1661271/

This worked for me to export the previous recipients to a file from terminal:
$ cd ~/Library/Application\ Support/AddressBook/
$ sqlite3 MailRecents-v4.abcdmr
SQLite version 3.7.10 2012-01-16 13:28:40
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers ON
sqlite> .width 15 15 36 /* make sure the columns are wide enough */
sqlite> .output filename.txt
sqlite> select ZLASTNAME, ZFIRSTNAME, ZEMAIL from ZABCDMAILRECENT;
sqlite> .exit
but opening ~/Library/Containers/com.apple.corerecents.recentsd/Data/Library/Recents/Recents with http://sqlitebrowser.org and exporting the contents of the recents table worked too, but gave three times as many entries and many doublettes and only names without email addresses.

There are different visualization tools for sql which helped me a lot getting a hang on it. For example http://sqlitebrowser.org which is cross platform. Just open a new database and hack around a bit, to see how the commands are build up. Then read the official python docs to sqlite and maybe a tutorial. I was very afraid of sql and databases, but this was more easy as I thought.

You can use SQLite without using CoreData. There's plenty of open source classes out there for ease. Here's a swift implementation that says it supports fts: https://github.com/stephencelis/SQLite.swift

If you need a sqlite front-end for dev purposes I use http://sqlitebrowser.org/. but there are others out there.

Pokeminer is incredibly easy to set up and use. It outputs to a SQLite data base, and the free SQLite Browser can export directly to csv.

As a side note: if your looking to create a map - regular or heat - from the data you can use Google Fusion Tables. It has it built right into the web app - no coding necessary.

Maybe. It may or may not break online play, and I believe you'll have to change it again every time you update the card database.

How To:

Open up your ygopro folder, and look for the file cards.cdb. This is a SQLite database - download an sqlite viewer (I recommend sqlitebrowser for windows and sqliteman for linux).

There are two tables - datas and texts. datas includes all the numbers and stats of the card, like Attack, Level, etc. texts includes the text on the card.

Select the texts table, and find the card in the database.

There will be several columns. The first three are id, name, and text - these should be self-explanatory. The other columns are labeled Str1-Str16. These are the text that appear in the prompts. These are associated with card scripts, so you can't change which order they appear. However, modifying the text there will change the text it prompts you with.

I Repeat: You cannot change the order the options appear, and you cannot add or remove options, without modifying the cards behaviour, and therefore being unable to play online.

For example, Enemy Controller (id 98045062) has Str1 of "Change the Battle Position of 1 face-up monster your opponent controls" and Str2 of "Tribute 1 monster. Select 1 face-up monster your opponent controls. Take control of it until the End Phase". Modifying either of these strings will change what the choices you have will say.

I have not tested this online - I'm not sure how well the server checks the accuracy of your cards.cdb. It may or may not appear when playing online.

EDIT: Apparently card text is done server side when online. This method will only work against the AI.

You can find this in the source code, but all of this is stored in the database file, which is a bog standard sqlite database. You can download http://sqlitebrowser.org/ for OS X or an equivalent from Windows and see what exactly it is doing. In addition, if you enable debug logging from the userProfile.json in your profile, you'll get to see every transaction your client accomplishes. When you see a transaction you want to learn about, copy and paste the text, go to the github repo and search for that text. It will give you exactly the circumstance where / how that transaction happens.

It's totally unrefined but it was the only thing that I could do to get rid of a non-functioning motion sensor. If they won't go away try the DB editor (I think I used this one: http://sqlitebrowser.org/), but make a backup copy of zigbee.db first.

Here's what I did: Go to the Browse Data tab, then for each table (attributes, devices, etc...) click to sort by ieee, and delete all entries that match the hardware address of your device.

For Chrome there is actually a file in the user profile called History, it is a standard SQLite database. So you can use any basic SQLite editor to manipulate the history to your hearts content.

Sqlite with the browser is easy to use. Now, what sometimes happens is that, although the documentation on SQLite is excellent, it may in many instances seem overly complicated for the task you want to do. When that happens, it is pandas to the rescue!

I actually recently archived the entire subreddit with all the comments. You can download it here if you want to look through it. I recommend http://sqlitebrowser.org/

To be clear, the SQLite library will make it easy to connect Python to a SQLite database and query that database. The library (any database library for any database) doesn't eliminate the need for SQL knowledge.

Start with a SQL tutorial. W3Schools has one, there are likely better ones out there. Try DB Browser for SQLite for a nice GUI for creating/accessing SQLite databases.

I personally prefer DB Browser for SQLite.

Also, there is some documentation about the database structure.

Here is a PDF detailing the database schema.

Here is a PDF detailing the API endpoints and response formats.

On iOS 8.4 they're in /private/var/mobile/Library/BatteryLife/ (not sure about iOS 9)

You can use DB Browser for SQLite to open the CurrentPowerlog.PLSQL file and change/view the data

Yes, with v2 Whitelist enabled, you won't be able to install official updates for legit games & apps. But you can delete the 4 triggers added by v2 Whitelist from app.db with SQLite Database Browser (http://sqlitebrowser.org/) to re-enable update. After updating your legit games & apps, you can re-enable v2 Whitelist. Look at the last picture here: http://hackinformer.com/2016/07/30/install-whitelisthax-pstv-henkaku-fw3-60/. The four CHANGE_CATEGORY_XX triggers were added by v2 Whitelist.

You probably need to re-build database to avoid re-installing games after removing or re-enabling v2 Whitelist, either through safe mode or re-inserting Vita card after powering up & powering down without card.

If you install decrypted update with MaiDumpTool (which won't work with the retail cartridge you ordered), you don't need to disable v2 Whitelist.

/data/data/com.valvesoftware.android.steam.community/databases/SteamLocal.db

• Copy that file on your PC and use a software to read SQLite databases. This one does the trick
• Drop the file in that program, go to the "browse data" tab, change the table to "Personas" and note down the steamId of your friend
• Change the table to "Messages", paste steamId on "chatPartnerId", click on "utcTime" until the small arrow is pointing up

And there you go, that should list all the messages from that person

Don't just learn SQL, learn some database theory as well and try playing with some sort of ORM.

Other than that I suggest you use a simple SQLite utility (e.g. http://sqlitebrowser.org/) to fool around. Another useful tool: http://sqlfiddle.com.

No they are not. They are readily available in the SQLite DB. I can read all the encrypted messages. I simply copied cache4.db to my PC and browsed it using DB Browser for SQLite.

>As I am not a developer and have exactly zero coding experience

You won't like this solution as you need to be somewhat tech-savvy but you can change the order.

1. Go to /data/data/com.google.android.leanbacklauncher/databases using ES file explorer

2. Find the launcher.db file and get it on your computer. I just copied and pasted it into my Google Drive account which I have connected to ES File explorer.

3. Download SQLite Browser

4. Open up the file and go the entity_score table

5. Rearrange the scores as you please.

6. Replace the launcher.db file with your newly modified one.

7. Restart the Nexus Player and enjoy your new look.

See this link

But I do agree there should be a easy way to change the order so everyone can do it!

http://sqlitebrowser.org/ There are many .dbs in the Bloodbowl 2 folder, you want to look at the one in MyDocuments/Bloodbowl2/Profiles/ and the profile corresponding to your login (not guest). Its called ManagementOnline_prod.db. Browse the tables bb_player_listings and bb_statistics_players and you need to do some deciphering as to which stats line is which player etc cause they have numbered IDs. You might also need to load up the team in game first and start a game with them for the stats to show up - as it only seems to cache a few at a time (or the most recent player team you used - not sure). Its all read only (for your players anyway), you can write changes to the .db, but they don't get uploaded to the server so people can't cheat this way. I exported the two tables as CSVs and then matched the data together in excel. I guess a tool or viewer could be made, but I'm fairly hopeful it will get implemented in the actual game at some point.

I've actually just started messing with this stuff. I previously looked at the database using my mac's terminal. Don't do that. It's scary and illegible.

Firstly, you have to have a basic understanding of SQL-like stuff. Tables, how they're arranged, etc. You'll also likely need to know SQL commands to do anything useful.

With that said, you would want an sqlite browser. I've been using the suggested one in the Anki docs: http://sqlitebrowser.org/.

Then you can take a look at your database at /path/to/anki/profile/collection.anki2. My database is at /Users/username/Documents/Anki/Profile/collection.anki2 on my Mac. Of course, you'd want to back up the file before messing with it.

All card reviews are stored in revlog. I've found that if you mess with entries in revlog, you'll need to do a complete upload of your database to ankiweb for the changes to move to other devices.

Unfortunately for me, though, messing with the database didn't help me one bit. I did screw with revlog for fun and to fix the graphs by deleting the 50 reviews I did before actually starting on the deck two months later. I've given in to the fact that I'll need to write an extension to get what I want, but I'm not exactly sure how to do that exactly...

Querying movies by resolution is easy.

Download a SQLite browser like this free one (Win/Mac), then open your database file. My database is located at:

~/Library/Application Support/Plex Media Server/Plug-In Support/Databases/com.plexapp.plugins.library

Here's a query for finding all the 720p/1080p movies in your library (with a margin of error for slightly less than 720p).

SELECT metadata_items.title, media_items.width FROM media_items INNER JOIN metadata_items ON media_items.metadata_item_id=metadata_items.id WHERE media_items.width>1000 AND metadata_items.metadata_type=1

Now, as far as querying to include audio type and missing subtitles, that's more difficult. That data is spread across multiple tables, so you'd really have to write an application using multiple queries to achieve that.

If you open Preferences > Privacy & Security > Cookies and Site Data > Manage Data button, do you have a list of sites with the size of their data? If that's empty but the file is still 200 Mb, that seems fishy...

Edit: Sometimes I like to manually remove items from webappsstore.sqlite and for that I use DB Browser for SQLite.

ok I figured out how to get a save out of the local storage file and tested working with firefox, hopefully someone can test with chrome. (this should work with any OS as long as you can find your browser profile folder)

for firefox:

open C:\users<username>\AppData\Roaming\Mozilla\Firefox\Profiles<profile>\ (your profile may be in a different place if you're not using windows 7+) and make a copy of the webappsstore.sqllite file to the desktop or somewhere.

for chrome:

open C:\Users<username>\AppData\Local\Google\Chrome\User Data\Default\Local Storage\ (your profile may be in a different place if you're not using windows 7+). Inside you will find several .localstorage files. Your save is in one of them. make a copy of all of them (NOT the .localstorage-journal files) to the desktop or somewhere.

next, for both browsers:

install this program: http://sqlitebrowser.org/ and open it.

click on 'open database' and choose the file that you copied. (for chrome since there are multiple files you will need to try them one at a time, I suggest starting with the biggest file that has a recent modify date) on the second tab called 'browse data' in the 'key' filter type 'cookie' and you should see a few rows. In the row where the key is called 'CookieClickerGame' the data in the 'value' column is your save (make sure you get the right row, there are also rows for the beta version of the game and version 1.0466). Right click on it and click copy, and then import that directly into cookie clicker. (or copy to a file as needed, make sure the end is END%21 or you don't have the whole save)

CC /u/aktan, /u/orteil

https://www.reddit.com/r/firefox/comments/83ei0z/stop_firefox_from_deleting_history/

History is stored in places.sqlite in your profile folder. This is an SQLite database, so you can use the appropriate tools to export the data (e. g. DB Browser for SQLite).

I use the following database browser. Load up the (backed up) Plex database file, and navigate to the metadata_items table, then export to .csv.

http://sqlitebrowser.org

Let me know if you want more detailed instructions.

Since you seem to be new to this, may I suggest using a graphical database editor like sqlitebrowser?

Though I have to stress what No-More-Stars said: Make sure to create a backup (as in copying the collection.anki2 file to a safe location) before you make any changes.

Thanks for the tutorial but I have a question. How can you stop someone to download a software to explore the SQLite DB and change its values? For example http://sqlitebrowser.org, in there you can set a DB password, but how do you access your DB through code? Is it a connection string parameter? Thanks.

Actually, there is a way to do that in Python.

Python comes with a sqlite3 module that allows you to perform database operations and since Python also comes with a csv module, you can export all data in the DB if needed. In addition, if you don't feel like exporting to a spreadsheet, you can just download the DB Browser for SQLite as a way to interface with the DB.

http://sqlitebrowser.org/

I'm not familiar with SQL very much at all, and I've only used the sqlite3 library in Python, which works with this. I'm not sure whether it is compatible with other SQL databases or not.

You could export the data to a CSV file and query it with this tool: https://github.com/dinedal/textql

Or you could do what I prefer - run DB Browser for SQLite, import the data into a sqlite database, and query it there. You don't have to install SQL Server at all.

THIS IS A REPOST FROM paul30001. Big thanks to him for figuring it out ! <3

Use this to delete the pokemon with the longtimer on the map

Steps:

-http://sqlitebrowser.org/ - get your version

-OPEN a copy of db.sqlite

-Browse Data Tab

-Select Sightings in drop down list on top

-For expire timestamp, put 1473

-Ctrl+A, and Delete all those entries.

-File -> Write Changes.

-Copy and Paste that same db file into Pokeminer.

Doing it the GUI, no. It's doable by editing Kodi's SQLite database if you don't want to remux. The custom settings for a file is saved under the table settings. All files aren't there though, only those with custom settings. So you could make a CSV table and import it into that table. First you'll have to check what the idFile for the episodes are (each is unique but seems to be in ascending order) under the table episode (i.e. if you've scraped the show). The AudioStream values in the settings table are: 0, 1, 2 (1st, 2nd, 3rd...).

So I guess it depends how many episodes it is if it's worth the trouble. Though it's not really hard editing the database. I use DB Browser in Win7. The only work would be to create to CSV file.

Make another profile, use the addon there and password protect the profile.

> What's weird is even if i delete the addon and reinstall the watched videos are still marked.

Watched status is saved in Kodi's database and it's not removed after uninstalling addons. If you want to remove tons of an addon's watched status you could use DB Browser.

E.g. to remove watched status for the Reddit addon

1. Open MyVideosXX.db with DB Browser, the one with the highest number is the current one. C:\Users[username]\AppData\Roaming\Kodi\userdata\Database\
2. Tab "Browse data", Table: files
3. Filter strFilename: %plugin.video.reddit_tv%
4. CTRL+A if you want to remove all of them.
5. Delete Record
6. Write Changes

Thanks for that. I work with SQL daily and I can see your query doesn't need to have a subquery in it. I've simplified it quite a bit, like this:

http://pastebin.com/564K3qhn

For those wondering, to run this, get a copy of the nzbdrone.db file from C:\ProgramData\NzbDrone if you're on Windows.

Then download the SQL Lite Browser from here http://sqlitebrowser.org/

Run the program, open the database, and run that query in the "Execute SQL" tab. This is mine: http://i.imgur.com/3OHyFxC.png

Grab a copy of DB Browser for SQLite (http://sqlitebrowser.org/). Shut down Sonarr and make a copy of your nzbdone.db file so if you mess anything up, your original DB used by Sonarr will still be ok. Open the copy in DB Browser for SQLite and paste the SQL query in the "Execute SQL" tab and hit the run button. That's it!

Ok, I created the bot, here it is https://github.com/achyutreddy24/RedditBots/tree/master/ConLangBot

Download the three files, rename the (renametoconfig.py) file to config.py and add your own information in it.

At the top of main.py, it says /u/fusiongaming surrounded by other symbols, just change that your bots name, all lowercase.

Download python 3

It should come with pip but if if doesn't download that too

Open command prompt, run

pip install praw

then navigate to where you saved the two files with command prompt, use cd or look up how to if you don't know

Then run

python main.py

now you need to leave it running and your bot is working. If you don't want to keep your computer on all the time, you can host it somewhere else but they usually cost money.

The bot will create a third file called data.db

This is what stores all the comments the bot has replied to and all the small questions threads it has found. If you want to view it, download sqlite3browser http://sqlitebrowser.org/ and open it.

If you run into any problems let me know and I'll try to fix them.

I decided not to keep the words in the database and instead refind them every time. Also it only searched until it find the first post with the word, I'll change this later so it will find all of them if you need.

Thanks a lot! I might have been unclear in my description : the information/pics aren't retrieved at runtime, it has been prepared beforehand by a scraper I've also wrote. This way, you can yourself manage the collection / infos etc. of your ROMs.

The major problem of this approach is that, currently, to do so, you need to manually open the database file to modify the database (with a tool like sqlitebrowser). But I'll maybe quickly develop another small app to make it easier.

The command would be run on the command line.

You can download SQLite here.

The SQLite database can also be accessed through third-party GUIs such as DB Browser for SQLite.

I would do what /u/Becer suggested first, but failing that you could export the URLs from the SQlite database that OneTab stores everything in. On Windows this is located here:

> "%LOCALAPPDATA%\Google\Chrome\User Data\Default\Local Storage\chrome-extension_chphlpgkkbolifaimnlloiipkdnihall_0.localstorage"

Make a copy of this .localstorage file, open it with DB Browser for SQLite, click the Browse Data tab, in the State row double-click on (BLOB). After a few seconds another window will open. Select Text from the dropdown box (to the left of the Clear button), click the Export button and save the file somewhere.

The resulting text file looks like it is in JSON format, so if you just want the URLs you will need to find something that can extract those. e.g. grep + suitable regular expression.

Check out sqlitebrowser.org I think that could take care of 2 and 3 for you to set up a DB solution and it's free.

For a data Viz you can check tableau public here. It's the freeware version of tableau. It's pared down so it's not as involved as the full version of tableau.

1. Shutdown Tautulli.
2. Backup your Tautulli database by making a copy and saving it somewhere safe.
3. Open your database with DB Browser for SQLite.

4. Go to the "Execute SQL" tab and copy/paste all of the following SQL. (screenshot)

   DELETE FROM imgur_lookup WHERE id NOT IN (SELECT MIN(id) FROM imgur_lookup GROUP BY img_hash);

5. Click on the "Run" button and make sure the output at the bottom says "Execution finished without errors."

6. Click on the "Write Changes" button.

7. Restart Tautulli.

>database editor

The Radarr wiki suggests DB Browser for SQLite. I'm going to check it out now.

UPDATE:

1. Open nzbdrone.db with DB Browser for SQLite
2. Click the Browse Data tab
3. Next to Table: choose RootFolders and you'll see the list of root folders appear below.
4. Choose Table: Movies and you'll see the Path column below.

I'm not the author of Happy Search, so I can't say much about your first issue. It seems to be a rendering problem, from my experience resizing the window should take care of that.

All data is stored in the sqlite database located under Stored Data/Happy-Search-Local-DB.sqlite. The tables userlist and vnlist in that database should contain the information you're after. If a database is not accessible enough for you, you can easily browse it via SQListe Browser. It even has a simple export-to-text function.

Welcome.

Well, GOG Galaxy indeed stores data in SQLite3 databases. They're located in %ALLUSERSPROFILE%/GOG.com/Galaxy/storage/*.db:

• etags-updater.db (etags* DBs are for security stuff, data is hashed there)
• etags.db
• galaxy.db (the largest of them all one)
• index.db
• jobs.db (DB with download queue)
• ownership.db

and %LOCALAPPDATA%/GOG.com/Applications/<long-app-id>/Storage/Users/<long-user-id>/storage.db (DB related to Cloud Sync per AppID per User).

Quick lookup didn't find anything of interest related to achievements / playtime.

You can browse them yourself with FLOSS SQLite DB Browser or probably even better with Python's sqlite3 / sqlalchemy modules.

If support reaches technical stuff who work on Galaxy - they'll easily give you the answer where this data stored. But there are if's here and you can be given a 'sorry, we can't help you here' which you'd have to accept.

P.S. It seems achievements are online only - https://static.gog.com/wishlist/galaxy/offline_achievements. They are submitted to API endpoint https://gameplay.gog.com

No idea about the root cause (sounds like file locking), but in the future - if you want to try the hard way, you should be able to open SQLite databases with a tool like http://sqlitebrowser.org/ and possibly export/recover some information.

I would suggest SQLite would be the best place to start it is a file based database similar to access. You will need the DB Browser for SQLite

From there I would look at this article Using SQLite wiht Vb.Net

Using a file database makes working with the system easy. The knowledge you will gain from this scales to whatever database platform you want to use. Learning this will enable you to move to Mysql, Postgre, et al without any issue.

For the GUI, I'd suggest toying with Flask or Flexx. Getting your app GUI to be browser (web tech) based can make it more platform independent - good skill, since a lot of app development has shifted into this direction (Electrum based). There's quite a few tutorials on YouTube for them. You can still package it as an independent program if you want, you just use web tech to do the GUI.

As for the .txt or .csv, I'd recommend Sqlite3 if you plan to grow the project at all. It may seem daunting at first, but it's a good learning step into setting up a database which are valuable skills to build upon as you grow. You can use SQLiteBrowser as you develop to help learn the syntax and browse the data / test queries.

FYI, you can grab DB Browser for SQLite and query the Plex DB at

%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.library.db with the following:

SELECT Library, Minutes, Hours, Days FROM ( SELECT name AS Library, SUM(duration)/1000/60 AS Minutes, SUM(duration)/1000/60/60 AS Hours, SUM(duration)/1000/60/60/24 AS Days FROM media_items m LEFT JOIN library_sections l ON l.id = m.library_section_id WHERE library_section_id > 0 GROUP BY name );

sauce

I'm on my PC rather than my phone now, so here are more detailed instructions in case anyone else is interested, also because it's not 100% self explanatory if you have no experience working with databases. (These instructions are for the Windows version of the software, I don't know if/how the OSX version differs.)

1. Backup your database in case something goes wrong.

2. Download the software by using the instructions in the link. (It will re-route to Github for instructions.)

3. Run the program and select Open Database. Navigate to the path of the database file and open it. Use google if you don't know where it is. On my machine it's at C:\Users\[username]\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db

4. Select File > Export > Table As CSV file. Select the table named metadata_items, and save.

5. Enjoy.

This table has way more data than just the file names for your media, but you can export whatever data you want, rather than the entire table if you know a little SQL. Here's some example code for selecting specific data. This code would be executed on the "Execute SQL" tab. There is a button on that tab to export the data from this custom query.

For Windows, I just used DB Browser for SQLite and opened a recent main.db file to view the logs. Not sure how things work for Linux, but it was under the body_xml column within the Messages Table unencrypted.

I'm on a Mac, so I installed SQLite via Homebrew and I use DB Browser for SQLite as a client for easy import/export. I pull data as CSVs, import them to a local SQLite DB file, and run queries to pull everything together. Queries are stored as text files or views under version control. From there, it's back to a CSV if needed for presentation in Excel.

What's nice about doing it this way is SQLite runs without a server (data and schema in a local file) and I can run everything quickly on freshly imported CSV files. No fiddling required to add columns, set up tables, populate formulas, protect against Excel goofing up data formats, etc.

If you're learning SQL, I always recommend this free Stanford Course as a good jumping-off point.

Thank you very much, u/alex199568, for taking your time to write such an indepth comment on Android data storage!

Your comment along with others helped me a lot while trying to figure out how to deal with the database environment and I couldn't answer you properly before doing some tests.

I started creating the SQLite database with DB Browser for SQLite which seems to be a good tool after you understand it a little bit (before getting it, I almost abandoned the database idea to do all the things by hand without databases and such).

I'm dealing with public transportation timetables, so, I thought it'd be as easy as a time list, but now I'm thinking of at least 10 parameters (line number, name, company, route, exceptions and 6 different timetables) all of which are textual besides the line number, of course.

I'm thinking of presenting the time time as a string, but filling a thin TextView so as it looks like a list (I guess some hard work over dimens may help me to achieve this for different devices).

By the moment, I'm just getting a list of lines and I still have to figure out how to make the entries clickable in a fashion users jump to the right activity in which all the information is delivered about the specific entry they clicked in the first place.

Before that approach I had tried Realm as it sounded as a good tool, but Realm Studio isn't available for my system, so, it made me to abandon that path as of now.

Now, I'm going to take a look at the ORMs you mentioned so as to understand how they could help me.

If you have access to MS Office, you might want to look at the Access database that comes with that. Otherwise, you can usually find front-end GUIs for most databases. There's DB Browser for SQLite, for example.

UPD: local storage files for chrome should be stored in %LocalAppData%\Google\Chrome\User Data\Default\Local Storage

They can be opened in http://sqlitebrowser.org/

You can probably find localstorage for http version and restore the save

The log file would likely contain that info.

Also, the KODI database in your Userdata folder would have that info. It's an SQLite database so you could read it with any of the free tools for SQLite like this one: http://sqlitebrowser.org/

If you use an SQLite browser, take a look at the Files table in MyMoviesXXX.db, sort by reverse date, the first entry will be the last URL played.

^(Edit: More info)

I'm still not home but I think I used this http://sqlitebrowser.org/ to update the paths.

and x_radeon elsewhere in this thread has it. you find those two files and change the paths where you're files are.

I think something wrong happened with app.db, i usually modify app.db manually using http://sqlitebrowser.org/, and tutorials from hackinformer, but i can access that site right now, for better result i recommend you factory reset your vita then backup and then doing the process again

This is tutorial i using http://www.xiaomitips.net/news/How-to-install-custom-themes-on-PSVITA/PSTV/

The database is sqlite3 (I think). You can use something like http://sqlitebrowser.org/ to access it. It isn't overly complicated if you already understand relational modeling. Just make a copy and fiddle with that, not the actual db for your application.

https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

Turn off the Plex server, then change the added_at value in the metadata_items table. The database is the file com.plexapp.plugins.library.db that's located in the subfolder Plug-in Support\Databases of your data folder. Plex should be keeping a few backups of the database in same folder but it's a good idea to make another copy of it so you have a fresh one. I personally use DB Browser for SQLite for editing.

With a google search I found this: >Notification settings are saved in an SQLite Database here:

> C:\Users&lt;YOUR USERNAME>\AppData\Local\Microsoft\Windows\Notifications\wpndatabase.db > > You can view the contents with any SQLite Database reader/query, I used this: > > http://sqlitebrowser.org/ > > Just search the 'NotificationHandler' table for the notification you want to delete (select * from NotificationHandler > > ), in my case it was 'Symantec.ToastUI' and it was at 'RecordId' 72. > > Then just delete everything conected to this Handler: > > delete from HandlerSettings where HandlerID = 72 > > delete from Notification where HandlerId = 72 > > delete from WNSPushChannel where HandlerId = 72 > > delete from NotificationHandler where RecordId = 72 > > Save the DB (if you are using the app above) and re-open the Notifications Settings App.

This seems to work somewhat. Edit: Deleting the database file just seems to make everything reappear again.

I would suggest using XAMPP for PHP and DB. Rather than using SQLite. XAMPP gives you a MySQL database which I strongly recommend using in the long run over SQLite. SQLite does not have explicit typing, meaning you select a "Generalized" type and slap the value in there. That means you have to do all the type conversions on your own to not break things. I'm a programmer, Programmer == Lazy, Extra code for Type conversions != Lazy.

Also if you plan to do any development professionally the chances of you working with a SQLite DB are slim. You should get practice using more common DBMS solutions. MSSQL, MySQL, Postgres, etc. Each DBMS has a different "Flavor" of SQL syntax. While at its base level SQL is SQL some DBMS have specific ways they want you to accomplish things. For example a count statement in SQLite is Select Count() from Table in MSSQL (Transact SQL or TSQL) its Select Count(*) from Table They look the same but the difference is the * without that TSQL will throw an exception saying your syntax is wrong.

If you use XAMPP there is a web portal you can use to manage the DB. The web portal allows you to create tables alter tables (Within SQL limits) add or remove values (Again within SQL limits) and more. Its run through PHPMyAdmin so it will clearly work with PHP. You will also use XAMPP for the apache server to run your PHP codes. Just a suggestion as it may be easier. You can find XAMPP Here

If you really want to use SQLite though, you should download the SQLite browser which give you a fairly interactive GUI for SQLite. It's available for windows mac and linux. You can find the browser Here

Edits- Clarity, Content, Links

There is a possibility that just deleting app.db would cause it to be rebuilt automatically (same way deleting the trophy db file does--I do that all the time), but don't take my word for it since I have no way of knowing for sure.

But what he's talking about is using http://sqlitebrowser.org/ to open your app.db and deleting the entry labeled NPSXxXXXX (though he might mean to replace the X's with some sort of game ID).

To clarify, it doesn't affect your ability to have both on your memcard at the same time, you just have to clear database entries after using Vitamin for the same game that you are trying to dump with Mai. Unfortunately, if this is actually the problem with your dump then none of us can do anything with the dump that you've provided.

I would get a free sqlite editor like http://sqlitebrowser.org dump some data in it and play with queries you need. If it's working fine and see it's worth than you can convince IT you need a properly hosted database

I think that plugin is meant to act as a GUI for SQLite. So yeah, you could use it to read Firefox's own database but it's meant for general purpose SQLite usage.

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

For awhile it was the only free SQLite GUI but I've since switched over to DB Browser, FWIW: http://sqlitebrowser.org/

Easy way to get started is to use SQLite. Just did a quick google search this walk through seems pretty good. http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html

SQLite will work well if your rows are less than 10,000 records. Its just a file on the disk. You can use another program outside of python to view the data to help you understand how the table was created or just to view it. http://sqlitebrowser.org/ supports all OS's.

The QHD might be a bit of overkill, but I also think the scaling issues are largely behind it. Here's the only program I use which still has scaling issues. You're probably right about outdoor conditions, but I rarely code outdoors anyway.

Another consideration is that the QHD is more future-proof - if OP is planning to keep it for the next 4 years of college and possibly after, then a FHD screen might be considered pretty dated in the 2020s. To be fair, I just dropped my QHD to 1920x1080 just to test and everything still looks awesome.

If you take a look at: https://support.skype.com/en/faq/FA392/how-do-i-manage-my-conversation-history-in-skype-for-windows-desktop It might help understand a few things.

I've had a quick look on my computer and I found by main.db.

Being curious I opened it with: http://sqlitebrowser.org/

A Google or two revealed: http://www.spokenlikeageek.com/2009/10/02/querying-the-skype-sql-database/

So it would be possible to extract the data from the SQL Lite database format it's in. I guess it depends what you need exactly and how to present it.

I don't have much but after opening the file, I just ran this SQL:

SELECT author, datetime(timestamp, 'unixepoch'), body_xml
FROM messages ORDER BY timestamp

Just to get a feel for the data.

Hope it helps get you going.

Thanks for getting back to me!

I'm on Windows 7 64bit.

I have used both the installer and the zip distribution, and behavior is identical. The program does not save the queue or templates. However, both of them still retain my YouTube account.

I had previously used the zip distribution of 0.5.1.

Right clicking and running the executable as admin doesn't make a difference.

In case it's pertinent, during installation, it was not able to detect that I have Java (v8 u91) installed, and prompted me to download it. I imagine that could possibly be a PATH issue, which I haven't checked.

EDIT: This is interesting.

I found the database. If I open it with a DB browser (from here http://sqlitebrowser.org ), the sqlite_sequence table acknowledges 2 templates, but the templates table is empty. Now, if I view the same db in a text editor, I can see the titles of my templates in there somewhere, so I'm not quite sure what's going on there. Seems odd. The uploads table is empty as well.

All file system permissions for the db are appropriate.

The log just shows opening, a couple OAuth lines, and then closing.

The data files are here:

Windows:​ C:\Users[Username]\AppData\Roaming\openbazaar

​OSX:​ ~/Library/Application Support/OpenBazaar

Linux:​ ~/.openbazaar

You can't view the database file (OB-Mainnet.db) with any standard Office tools; it's a sqlite database. http://sqlitebrowser.org/ is a good editor.

Importing from eBay, Amazon, etc is something that's going to take more work before they can just drop a file somewhere. It's something I'm working on and hope to available on my website soon.

This might not work but it could be worth a try. I was able to restore my Stylish styles from a previous backup of my Chrome folder. If you don't have a backup of your Chrome folder, sometimes you might get lucky if Chrome still has your old Stylish database. Here is how to check:

1. In Chrome navigate to: chrome://extensions/

2. Tick the checkbox for 'Developer Mode'

3. Find Stylish in the list of extensions and look for the ID (mine shows as ID: fjnbnpbmkenffdnngjfgmeleoegfcffe)

4. Copy the ID, open Explorer and navigate to: C:\Users\%username%\AppData\Local\Google\Chrome\User Data\Default\databases

5. Find the folder for Stylish (mine shows as chrome-extension_fjnbnpbmkenffdnngjfgmeleoegfcffe_0)

6. There should be an SQLite database file in that folder (mine shows as '6'). If there is more than one file, it is possible that Chrome has created a new database file for that extension so it is worth checking all the files in this folder.

7. You can download SqliteBrowser to open and view the contents of this database file: http://sqlitebrowser.org/

8. Open SqliteBrowser, drag the database file into SqliteBrowser and select the 'Browse Data' tab at the top

9. In the Table dropdown menu just below the tabs, 'section_meta' lists the domain names and 'sections' lists the CSS code for the styles. If there is nothing in these sections then the database is empty unfortunately.

10. If you find your styles listed under these sections then you have found the correct database! make a backup of it and then you can try to get Chrome to recognize the new file (I just had rename the file to the same number as the empty database and then overwrite it). Failing that you can always just manually copy your styles from SqliteBrowser and import them again that way.

I hope this helps in some way and that you can resolve your issue!

I have some experience with number 2.

Basically, the messages are stored within an SQLite database file. Once you upgrade to a newer operating system, the Messages application changes a version string inside the database that prevents it from being opened using an earlier version. This is done to ensure that an older version of Messages doesn't mess up the database if it has things in it that it doesn't understand.

However, at least for 10.11 -> 10.9 you can use this application to open up the database and simply edit the version string to match the Mavericks version of Messages, which allows the database to be opened in that version. It's been a while since I tried that so I can't remember which key it is exactly that you have to change, but I found it very quickly just by poking around the database.

I'm right there with you on the aesthetics of 10.9 vs. newer versions and I would love to still use that. For me the dealbreaker is the incompatibility with iCloud Drive, which means I can't synchronise data with many of the apps I use on my iPhone (iOS has supported only iCloud Drive since version 9), and it would be too much work to find or create alternate ways to accomplish it. I'm also quite fond of Photos and the way it automatically downloads and organises my iPhone pictures.

Other limitations I can basically deal with, but the process of moving everything over from newer system to an older one (without starting fresh) was such a hassle that I decided to just abort the mission.

Starting with SQLite is an excellent idea, as it comes packaged with Python already. It's also surprisingly complete as far as the SQL language support is concerned. You might also find this useful for setting up and managing SQLite databases: http://sqlitebrowser.org/

Have you tried accessing your stored history on your computer? That might be kept longer than the 3 months that chrome will keep it.

You can find it at C:\users(username)\AppData\local\google\chrome\User Data\Default

There is a history journal and a history. I copied them to my desktop, downloaded sqlite, added a .sql extension to the history file and opened it as a database in DB sql.

Once opened under the first dropdown of tables, I looked at urls. You might be able to filter by domain if you know what you went through for it. Don't know if it will work or not, but figured I'd see if you had tried that if you are out of options.

unlike many databases, which are client server and have a service constantly running, a sqlite database is just a single file.

last time i used sqlite from C# i used https://www.nuget.org/packages/System.Data.SQLite

i would also recommend installing http://sqlitebrowser.org/ if you are using windows

If you are looking to open the file and read what's in there... I have no personal experience with WhatsApp specifically, however the .db suggests that it might be an SQLite file. In which case you could try making a copy of the file (to not disturb the original state of it) and then trying to open it up with a tool such as http://sqlitebrowser.org/

Good luck.

Yes.

Skype, for example, uses a local SQLite database, a full SQL database that's stored in a single file. It gives them compact, convenient storage, but they can treat it like a normal database and run queries on it! For skype it's called main.db and on Windows it's normally in C:\Users\YourUserName\AppData\Roaming\Skype or something similar, on Mac it'll be in /Users/YourUserName/Library/Application\ Support/Skype/YourUserName. Download an SQLite database browser and open the main.db file in your Skype folder and you can see your chat history and run SQL queries against it!

SELECT author, from_dispname, datetime(timestamp, 'unixepoch') as date, body_xml FROM Messages where dialog_partner = 'your_friends_username' ORDER BY timestamp;

I'm using DB Browser for SQLite. I have a settings file is opened even in the notepad and can be read. It encrypts the password in the old launcher.

http://i.imgur.com/C22AUnb.png

The LRCAT file is a database using a database called SQLite. You can open this database using a F/OSS tool like DB Browser for Sqlite. Open the main database file "Lightroom Catalog.lrcat" and look down the names in the Database Structure tab for Adobe_images. Click on that and go to the "Browse Data" tab. Look at the bottom and that will tell you how many images are known to LR. If that number is consistent, then it was just DB compression, as in the cleaning of deleted entries which happens periodically.

There are other tables as well to check, but that is a good start. Remember to exit out cleanly.

Ok here's the info you need to know.

First grab the library.db file from /var/mobile/Library/Grooveshark

Then open it in an sqlclient (I am using DB browser )

Then open the execute SQL tab, paste this in and press the play button.

select songs.title, artists.name from artists, songs, my_music where songs.songId = my_music.songId and artists.artistId = my_music.artistId;

Huge thanks to Xaositek and hatheaded for their help in providing this essential query to get our song names!!

Openvgdb is a SQL database that has the metadata for a game already prefetched. Basically you can search for a game by its name, or whatever you want to search by, it is based on your SQL query. You can have it then spit out a URL to its artwork, or its checksum, or even a get description. If you download their OpenVGDB sql file, you can browse it with http://sqlitebrowser.org/. So you can see what their schema is.

I'm guessing that you can just query the database and add games to it. Try submitting the providence team a pull request, so that they can benefit from your artwork additions.

If you have a SQLite database browser you can open up the Login Data file found in your Chrome data folder. Browse the "logins" table, find the domain name in the "signon_realm" column that matches the username_element column. Look for the "date_created" column in that row which will be a number in milliseconds like "12933827920000000". Using a function we can convert this into human readable format so "12933827920000000" is actually Nov 9, 2010 5:58pm.

Use a function like this to convert it to human readable form. Run it in developer tools console.

// the timestamp value from the Chrome database (replace with yours)
var $timestamp = 12933827920000000;

// convert to unix format var $unix_time = ($timestamp/1000000)-11644473600;

// human readable format function timeConverter(UNIX_timestamp){ var a = new Date(UNIX_timestamp*1000); var months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']; var year = a.getFullYear(); var month = months[a.getMonth()]; var date = a.getDate(); var hour = a.getHours(); var min = a.getMinutes(); var sec = a.getSeconds(); var time = date + ',' + month + ' ' + year + ' ' + hour + ':' + min + ':' + sec ; return time; }

console.log(timeConverter($unix_time));

Use sql inserts (.sql file) and excel-sql inset-generator such as this --> http://tools.perceptus.ca/text-wiz.php?ops=7

or use sqlitedb editor to create/edit master db then export as sql dump file. --> http://sqlitebrowser.org/

also checkout my sqlite wrapper --> https://gist.github.com/fatfingers/d225a88b116a1aadea35

Trying it out, on Windows you can:

1. Download iExplorer.
2. Use iExplorer to browse your apps > Cookie > Documents.
3. There will be a settings.db file that naveen mentioned in the post.
4. Right-click > "Export to Folder".

I'm working on trying to open the file to have a look inside - if it's possible, but that's how I managed to get file.

EDIT: I found out how you can edit the save file of your Cookie Collector. Although I don't reccomend it - That's cheating!. Also, it most likely will destroy your save file if you even try (at least it did for me) - so this is really just for a bit of fun. Make Backups.

1. Download SQLiteBrowser.
2. Launch, and click "Open Database".
3. Navigate to where you saved the "settings.db" file and open it.
4. Click on the "Browse Data" tab.

Also, I'm not kidding when I said make backups - I'm pretty sure I lost my save just now due to me being foolish. It's not much of a deal for me - I only had about 3 Septillion lifetime cookies, but for those further on - make backups.