SQLite on Mac

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

SQLite on Mac

Postby T800 » 03. August 2009 10:33

Hello all,

I need to have SQLite running via Apache on my mac.

I downloaded Xampp and everything looked OK, I was instructed to edit the php.ini and delete the semicolon before „extension=php_pdo_sqlite.dll“

I went into the php.ini and the option isn't there but I noticed that Windows uses .dll and Unix (which I think is mac) uses .so

extension=sqlite.so is there and doesn't have a ";" before it, does that mean SQLite is running on mac anyway?

If not how do I get SQLite running on my mac?

Thanks
T800
 
Posts: 4
Joined: 03. August 2009 10:23

Re: SQLite on Mac

Postby Wiedmann » 03. August 2009 11:17

does that mean SQLite is running on mac anyway?

If you want see which extensions are running, you can use phpinfo().

BTW:
"sqlite" and "pdo_sqlite" are different things.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: SQLite on Mac

Postby T800 » 03. August 2009 12:38

Thanks

I was told I needed an apache webserver with mod_php and mod_sqlite installed. Does Xampp give me this?
T800
 
Posts: 4
Joined: 03. August 2009 10:23

Re: SQLite on Mac

Postby Wiedmann » 03. August 2009 12:55

I needed an apache webserver with ... mod_sqlite installed.

"mod_sqlite" is not part of the XAMPP package.
(because it's a 3rd party module)
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: SQLite on Mac

Postby T800 » 03. August 2009 12:59

Do they do the same thing though?
T800
 
Posts: 4
Joined: 03. August 2009 10:23

Re: SQLite on Mac

Postby Wiedmann » 03. August 2009 13:21

they do the same thing

The same thing as?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: SQLite on Mac

Postby T800 » 03. August 2009 13:42

Not sure really, each other?

As you can probably tell I don't have a clue about web servers/PHP/SQL etc.

I was told by a Windows user to uncomment "extension=php_pdo_sqlite.dll" in the php.ini to get the web server I need to host the frontend of a media server.

I looked in the .ini and it isn't there. I downloaded the Windows version just to have a look and the Windows version and it does have a "extension=php_pdo_sqlite.dll" that can be adjusted.
T800
 
Posts: 4
Joined: 03. August 2009 10:23

Re: SQLite on Mac

Postby Wiedmann » 03. August 2009 14:02

I needed an apache webserver with ... mod_sqlite installed.
...
I was told by a Windows user to uncomment "extension=php_pdo_sqlite.dll" in the php.ini to get the web server I need to host the frontend of a media server.

- "mod_sqlite" is a module for the Apache webserver
- "pdo_sqlite" is a extension for PHP (in detail, it's a database driver for the "pdo" extension)

extension=sqlite.so is there and doesn't have a ";" before it

"sqlite" is a extension for PHP, too. (but not compatible to "pdo"/"pdo_sqlite".


Well,
- for mod_sqlite I know, it's not part of the XAMPP package.
- "sqlite" is part of the XAMPP package, and it's enabled (see your post above)
- "pdo" is part of the XAMPP package, and should be enabled
- IMHO "pdo_sqlite" is also part of the XAMPP package

Regarding pdo/pdo_sqlite:
- open phpinfo() and search for "PDO".
- in the "PDO" section you can see, if the PDO drivers sqlite and sqlite2 are enabled.

(and of course, I can't know if you need Apaches mod_sqlite, PHPs sqlite, or PHPs pdo_sqlite.)
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 21 guests