Jump to content


Photo

Putting SQLite DB outside document root

sqlite than

Best Answer Jacques1, 01 August 2014 - 10:54 PM

Option b) makes no sense for your requirements, because the database file is in the document root. It's the document root of your subdomain.

 

So what's left is a).

Go to the full post


  • Please log in to reply
2 replies to this topic

#1 Stefany93

Stefany93

    Advanced Member

  • Members
  • PipPipPip
  • 178 posts
  • Age:20

Posted 01 August 2014 - 08:22 AM

Howdy,

 

So I am creating a website with SQLite and this time I decided to follow the rule of putting the SQLite DB outside of the document root. However, the admin would need to admin, basically, the DB, so I have two choices:

 

a) Put PhpLiteAdmin (The SQLite DB manager like PHPmyAdmin is for MySQL) in the document root while giving it a path to the actually DB that is outside of the document root;

 

b) Set a subdomain to a directory outside of the document root of course and put both PhpLiteAdmin and the SQLite DB there and the admin would access it like this - db.Awesome-Website.com;

 

Which one of those two options are safer?

 

 

 

Thank you very much!


"Put your faith in God and keep your powder dry" - Oliver Cromwell
My site - http://dyulgerova.info

My history website - http://www.studyingthepast.com


#2 Jacques1

Jacques1

    Advanced Member

  • Members
  • PipPipPip
  • 1,007 posts

Posted 01 August 2014 - 10:54 PM   Best Answer

Option b) makes no sense for your requirements, because the database file is in the document root. It's the document root of your subdomain.

 

So what's left is a).



#3 Stefany93

Stefany93

    Advanced Member

  • Members
  • PipPipPip
  • 178 posts
  • Age:20

Posted 02 August 2014 - 01:47 AM

^^ Thank you for the help, but it wouldn't have killed you to be more polite!


"Put your faith in God and keep your powder dry" - Oliver Cromwell
My site - http://dyulgerova.info

My history website - http://www.studyingthepast.com





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com