A useful tool to view SQLite file in Web browser during app running procedure.
Viewing SQLite file in iOS developing brings a variety of inconvenience. Therefore, a visible and effective tool to view SQLite file is terriblydemanded.
Thanks CocoaHTTPServer for making this idea come true. Thanks Tonny for fixing grammar mistakes in README.md. Thanks my friend Mr.Bao, who has enlightened me to use DynamicServer to handle request.
So this project is named after him for showing gratitude.
In Chinese, 'Bao' means 'Hug', and represents purity and happiness.
There are three ways to use PleaseBaoMe in your project:
- using Cocoapods
- copying all the files into your project
Podfile:
pod "PleaseBaoMe"
All needed files are in "Classes" folder. And all dependencies are in "FMDB" folder. You can copy them into your project to import PleaseBaoMe.
You can see the sample code in Demo project.
You can start the serve by using:
[PBMTool start];
Then please set file path for your database file:
[PBMTool setDBFilePath:writableDBPath];
Run your app, you will see the following log in console:
You can see you SQLite in 192.168.xxx.xx:12345
Copy and paste the address to your browser's address bar and press enter key, you will see the entire database in your browser.
You can input your SQL query in the URI just like this:
http://192.168.xxx.xx:12345/SELECT * from test_table
You can set TableName、 LIMIT、 OFFSET in navigation bar easily.
MIT