I started Android development a few months ago, but was not able to find any good resources on how to debug my sqlite database. Most of the tips & tutorials you’ll find recommend to get root access and/or copy the database file to your local machine. Others require to purchase apps that run as root. Android Studio seems to lack support for this important task as well.
I want to share my current strategy to ask for improvements, potential drawbacks and different solutions and to help those who are running into the same problem. With the following 3 steps I’m able to read and modify the database on my phone from my PC with a GUI while the app is running and without any expensive tools, copying files or the use of the command line:
To create the database extend SQLiteOpenHelper. In the constructor of your subclass, add this line:
super(context, BuildConfig.DEBUG ? context.getExternalFilesDir(null).getAbsolutePath()+ File.separator + DATABASE_NAME : DATABASE_NAME, null, DATABASE_VERSION);
(this should write the database to the external storage in DEBUG mode and to the private/protected storage in production)
Install SQLite Manager for Firefox and run it
Click open, change the file filter to “all files” and browse to \[YOUR PHONE]\Phone\Android\data\[YOUR PACKAGE]\[DATABSE NAME].db
One drawback is that whenever the database changes one has to reopen (not refresh) the view. I also tried SQLiteBrowser but it wouldn’t load the database file from SD card.
some people asked me for the cross compiler and the next steps. Unfortunately, I don’t have the time to fully elaborate on all the details so this is a work in progress post. I’ll try to make some updates and comments to this post when I find the time. If you are interested in a particular thing leave a comment so that I can address it first.
The C# to JS cross compiler is written in C# and is using Roslyn:
The .NET Compiler Platform (“Roslyn”) provides open-source C# and Visual Basic compilers with rich code analysis APIs
A lot of things have changed since my early tests with Roslyn one year ago: Roslyn is now a very popular and focused project. This also means that a lot of things have changed in the Roslyn code. Please have this in mind when using the code listings that are provided here.
The goal of the Roslyn project is to provide an API to the C# compiler pipeline.
maybe someone noticed it – my site was offline yesterday after an update of WordPress to version 4.3.
I found an easy way to trace back the issue and fix it (this is why you can read this text now) and I want to share it here.
The problem I had was the so called “white screen of death”. People who would visit this site would see nothing. Just a white empty page.
This problem occurred after I started the WordPress update routine without doing a health check afterwards.
Another big issue was, that I weren’t able to login back into the dashboard. It feels as if WordPress just died and all your content is lost – but don’t panic. Here is a solution. Continue reading FIX WordPress Blank White Page After Update To 4.3→
Since more and more people show interest for this topic/posts and I just discovered a question on Stackoverflow mentioning this blog there is no more room for excuses – I owe you a second part. So I will just start and see how far I can come this time…
Last time, I showed you that XAML which is rendered into beautiful UIs is just a XML dialect and that we can use this knowledge to transform it into another XML representation: (X)HTML.
There was just one problem: our browser does not know about any WPF tags but instead speaks div, span, etc… But with Polymer to the rescue we were able to teach our browser how to read, simulate and render XAML. This allowed us to reuse our existing Desktop UI and display it in a modern browser.
But this was just a cool side effect and not what we really wanted. I promised you more: write code once and run it everywhere (smartphone, web, mac, linux)
I will show you in this post a concept of how to turn arbitrary desktop software that was written for example in C#/WPF into HTML5 cross platform solutions, with the help of new HTML5 features like Web Components. Or in other words, the next generation of hybrid software.
But before we jump into the details, I will provide some background information, why this technique can save you as developer a lot of time and your company tons of money:
It has been more than half a year, since I was accepted at MIT. After all the exams, the visa and scholarship application; after selling a complete household, my car, and being one month ‘homeless’; after filling out dozens of forms and getting gray hair, I’m just relieved and happy to enjoy a beautiful summer here in Cambridge.
The next year will be exciting and I’m looking forward to take part in promising and challenging projects, meet and work together with talented people, travel a lot and enjoy my new American everyday life.
I will try to share my insights, lessons learned, impressions and a lot more on this blog and thereby try to improve my English skills 😉
this post is about creating a Chrome Extension to enrich the functionalities of Google Contacts and to manage more than 10k entries in an easy way.
The story starts one month ago, when I was confronted with the following requirements:
“Build a Chrome Extension that is capable of managing all our Google Contacts (12k+)”
“We want a simple login”
“We want inplace editing for some cells, as well as batch editing for a subset of all cells”
“The extension should support fuzzy search, sorting, inverse search(exclude matching entries), multimail, quick filtering by age, notes/tags, …” – unfortunately, Google’s Contacts API is lacking a lot or nearly all this functionality right now
Welcome to the last part of this series on how to create an animated HTML5 logo for your blog.
Hopefully you’ve finished your animated logo and are now ready to integrate it into your WordPress blog. (You should have finished it – you had half a year to do so 😉 )
This post will be on