Running Tiki with SQLite???

View: New views
3 Messages — Rating Filter:   Alert me  

Running Tiki with SQLite???

by alain_desilets :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I'm an SQL virgin, so I thought I would ask folks here about this.

Would it be possible to run Tiki with SQLite instead of MySQL, for the purpose of doing fast, automated tests?

SQLite is a very fast SQL DB whick keeps all tables in memory.

It's of course not a good idea to use it for a real Tiki installation, but for the purpose of testing, where the DB mostly consists of empty tables, it might work.

Just a thught.

----
Alain Désilets, MASc
Agent de recherches/Research Officer
Institut de technologie de l'information du CNRC /
NRC Institute for Information Technology

alain.desilets@...
Tél/Tel (613) 990-2813
Facsimile/télécopieur: (613) 952-0215

Conseil national de recherches Canada, M50, 1200 chemin Montréal,
Ottawa (Ontario) K1A 0R6
National Research Council Canada, M50, 1200 Montreal Rd., Ottawa, ON
K1A 0R6

Gouvernement du Canada | Government of Canada
 



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Re: Running Tiki with SQLite???

by Kissaki :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes,
install sql script still has to be converted (the converter corrected)
but then it should be possible just like PostgreSQL.
When I find some time for it again I will do SQLite script as well.
Always planned to do that. :)

Desilets, Alain wrote:

> I'm an SQL virgin, so I thought I would ask folks here about this.
>
> Would it be possible to run Tiki with SQLite instead of MySQL, for the purpose of doing fast, automated tests?
>
> SQLite is a very fast SQL DB whick keeps all tables in memory.
>
> It's of course not a good idea to use it for a real Tiki installation, but for the purpose of testing, where the DB mostly consists of empty tables, it might work.
>
> Just a thught.
>
> ----
> Alain Désilets, MASc
> Agent de recherches/Research Officer
> Institut de technologie de l'information du CNRC /
> NRC Institute for Information Technology
>
> alain.desilets@...
> Tél/Tel (613) 990-2813
> Facsimile/télécopieur: (613) 952-0215
>
> Conseil national de recherches Canada, M50, 1200 chemin Montréal,
> Ottawa (Ontario) K1A 0R6
> National Research Council Canada, M50, 1200 Montreal Rd., Ottawa, ON
> K1A 0R6
>
> Gouvernement du Canada | Government of Canada
>  
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Tikiwiki-devel mailing list
> Tikiwiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Re: Running Tiki with SQLite???

by alain_desilets :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Re: [Tikiwiki-devel] Running Tiki with SQLite???
Great! This should make automated testing much faster. Please report back to this list when it's done.
 
Alain


From: Kissaki [mailto:kissaki@...]
Sent: Sun 25/10/2009 6:13 AM
To: Tikiwiki developers
Subject: Re: [Tikiwiki-devel] Running Tiki with SQLite???

Yes,
install sql script still has to be converted (the converter corrected)
but then it should be possible just like PostgreSQL.
When I find some time for it again I will do SQLite script as well.
Always planned to do that. :)

Desilets, Alain wrote:


> I'm an SQL virgin, so I thought I would ask folks here about this.
>
> Would it be possible to run Tiki with SQLite instead of MySQL, for the purpose of doing fast, automated tests?
>
> SQLite is a very fast SQL DB whick keeps all tables in memory.
>
> It's of course not a good idea to use it for a real Tiki installation, but for the purpose of testing, where the DB mostly consists of empty tables, it might work.
>
> Just a thught.
>
> ----
> Alain Désilets, MASc
> Agent de recherches/Research Officer
> Institut de technologie de l'information du CNRC /
> NRC Institute for Information Technology
>
> alain.desilets@...
> Tél/Tel (613) 990-2813
> Facsimile/télécopieur: (613) 952-0215
>
> Conseil national de recherches Canada, M50, 1200 chemin Montréal,
> Ottawa (Ontario) K1A 0R6
> National Research Council Canada, M50, 1200 Montreal Rd., Ottawa, ON
> K1A 0R6
>
> Gouvernement du Canada | Government of Canada
>  
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Tikiwiki-devel mailing list
> Tikiwiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Tikiwiki-devel mailing list
Tikiwiki-devel@...
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel