yippeeapp / pleasebaome

A useful tool to view SQLite file in Web browser during app running procedure.

PleaseBaoMe

A useful tool to view SQLite file in Web browser during app running procedure.

Why it's called PleaseBaoMe?

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.

Installation

There are three ways to use PleaseBaoMe in your project:

• using Cocoapods
• copying all the files into your project

With Cocoapods

Podfile:

pod "PleaseBaoMe"

Copying all the files

All needed files are in "Classes" folder. And all dependencies are in "FMDB" folder. You can copy them into your project to import PleaseBaoMe.

How To Use

You can see the sample code in Demo project.

Step1: start

You can start the serve by using:

[PBMTool start];

Step2: setup

Then please set file path for your database file:

[PBMTool setDBFilePath:writableDBPath];

Step3: finish

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.

Function

Input SQL in URL

You can input your SQL query in the URI just like this:

http://192.168.xxx.xx:12345/SELECT * from test_table

Convenient Filter

You can set TableName、 LIMIT、 OFFSET in navigation bar easily.

License

MIT