SQLite [Answered]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

SQLite [Answered]

Postby CarlosV » 23. February 2012 12:42

I know XAMPP have SQLite but I d0n't see how to execute phpSQLiteAdmin. Who can help me?
CarlosV
 
Posts: 5
Joined: 23. February 2012 12:37
Operating System: Windows

Re: SQLite

Postby Altrea » 23. February 2012 18:59

Hi CarlosV,

Because phpSQLiteAdmin is not part of the XAMPP project, we can't provide help for this script here.
Please try to get help for this script on its own project page.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQLite

Postby CarlosV » 23. February 2012 19:10

But XAMPP, in Components, says
"XAMPP components
XAMPP combines many different sofware packages into one package. Here's an overview of all packages.

Many thanks to the developers of these programs.

Apache HTTPD, MySQL, PHP, Perl, FileZilla FTP Server, phpMyAdmin, OpenSSL, Freetype, Webalizer, mod_perl, eAccelerator, mcrypt, SQLite, Mercury Mail Transport System, fake sendmail for windows, FPDF Class

In the directory \xampp\licenses you will find all licenses files of these programs. "

Then, how do I manage SQLite from XAMPPP?

Thanks Altrea.
CarlosV
 
Posts: 5
Joined: 23. February 2012 12:37
Operating System: Windows

Re: SQLite

Postby Altrea » 23. February 2012 19:26

CarlosV wrote:But XAMPP, in Components, says
"XAMPP components
XAMPP combines many different sofware packages into one package. Here's an overview of all packages.

Many thanks to the developers of these programs.

Apache HTTPD, MySQL, PHP, Perl, FileZilla FTP Server, phpMyAdmin, OpenSSL, Freetype, Webalizer, mod_perl, eAccelerator, mcrypt, SQLite, Mercury Mail Transport System, fake sendmail for windows, FPDF Class

Yes. Do you see any "phpSQLiteAdmin" in the list?

CarlosV wrote:Then, how do I manage SQLite from XAMPPP?

AS can be written on the SQLite Homepage:

Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.


best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQLite

Postby CarlosV » 24. February 2012 11:02

Was phpSQLiteAdmin 0.2 in XAMPP 1.6.2 / 1.6.3?
CarlosV
 
Posts: 5
Joined: 23. February 2012 12:37
Operating System: Windows

Re: SQLite

Postby Altrea » 24. February 2012 18:55

it cost max. 10 minutes of your time to download the versions and check it out on your own.
I know many XAMPP versions between 1.4.13 and 1.8.0beta, but don't know exactly all components of them.
I don't use SQLite.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQLite

Postby hackattack142 » 24. February 2012 23:47

I can help you to an extent but configuring/using it or debugging any PHP errors you get while using it, you are on your own.

If you wanted to set it up similar to phpMyAdmin, you could do the following:
1. Extract it to your XAMPP root (it would end up being /xampp/phpsqliteadmin03a1)
2. Open up your '/xampp/apache/conf/extra/httpd-xampp.conf'
3. Go under the '<IfModule alias_module>' block
4. Add
Code: Select all
Alias /phpsqliteadmin "/xampp/phpsqliteadmin03a1/"
    <Directory "/xampp/phpsqliteadmin03a1">
        AllowOverride AuthConfig
    </Directory>

5. Find this block of code at the bottom of that file
Code: Select all
<LocationMatch "^/(?i:(?:xampp|licenses|phpmyadmin|webalizer|server-status|server-info))">
    Order deny,allow
    Deny from all
    Allow from ::1 127.0.0.0/8
    ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var
</LocationMatch>
and modify it so be
Code: Select all
<LocationMatch "^/(?i:(?:xampp|licenses|phpmyadmin|webalizer|server-status|server-info|phpsqliteadmin))">
    Order deny,allow
    Deny from all
    Allow from ::1 127.0.0.0/8
    ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var
</LocationMatch>

6. Save and restart Apache
7. You should be able to access it via http://localhost/phpsqliteadmin
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: SQLite

Postby CarlosV » 27. February 2012 10:16

Thank you very much hackattack142, you're very kind.
CarlosV
 
Posts: 5
Joined: 23. February 2012 12:37
Operating System: Windows

Re: SQLite

Postby CarlosV » 27. February 2012 13:47

Altrea wrote:it cost max. 10 minutes of your time to download the versions and check it out on your own.
I know many XAMPP versions between 1.4.13 and 1.8.0beta, but don't know exactly all components of them.
I don't use SQLite.


You can see a example of SQLite in option Phone Book of XAMPP Menu.
Thanks.
CarlosV
 
Posts: 5
Joined: 23. February 2012 12:37
Operating System: Windows

Re: SQLite [Answered]

Postby Altrea » 27. February 2012 20:12

Hi CarlosV,

Thank you very much for your tips.
I already know what SQLite is and how to use it.
I don't use SQLite because my databases are quite bigger so that MySQL or Oracle is in most cases the better solution.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: SQLite [Answered]

Postby hopper3011 » 20. September 2012 16:51

Woah Altrea, I don't know what your problem is, but get help. If you're not interested in a topic, then don't contribute, but there's no need to be rude.
hopper3011
 
Posts: 1
Joined: 20. September 2012 16:45
Operating System: Windows Vista


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 150 guests