litesql-users — LiteSQL users list

Re: [litesql] MySQL backend no longer needs /NODEFAULTLIB:LIBCMT

[gulliver <gul...@tr...>]

Hi Erik,

I would prefer https://sourceforge.net/p/litesql/patches/ for the patch. But I think we need a separate cmake-flag 
for older Visual Studio Compilers or MYSQL Connectors. 

Kind regards,
Gulliver

Am 25.02.2014 um 02:49 schrieb Rapert, Erik <er...@ut...>:

> I commented this stuff out of CMakeLists.txt:
> “””
> # the precompiled mysql client libraries are compiled with libcmt - this causes duplicate symbols
> if (MSVC)
>                set(CMAKE_EXE_LINKER_FLAGS "${CMAKE_EXE_LINKER_FLAGS} /NODEFAULTLIB:LIBCMT")
> endif(MSVC)
> “””
> 
> Now it builds no problem.
> 
> So it seems that the MySQL guys fixed  the /NODEFAULTLIB:LIBCMT problem and thus this flag is no longer needed.
> 
> How should I contribute a patch to you guys?


> ------------------------------------------------------------------------------
> Flow-based real-time traffic analytics software. Cisco certified tool.
> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
> Customize your own dashboards, set traffic alerts and generate reports.
> Network behavioral analysis & security monitoring. All-in-one tool.
> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk_______________________________________________
> Litesql-users mailing list
> Lit...@li...
> https://lists.sourceforge.net/lists/listinfo/litesql-users

[litesql] MySQL backend no longer needs /NODEFAULTLIB:LIBCMT

[Rapert, E. <er...@ut...>]

My system:

OS:                         Windows 7 64-bit

Compiler:            Visual Studio 2013 32-bit

MySQL:                MySQL Connector C 6.1 32-bit

Litesql:                  v0.3.5??  "git clone
git://git.code.sf.net/p/litesql/litesql litesql-litesql"    from sourceforge
on 2014-02-24

CMake:                v2.8.12

Mingw:                 v4.0

 

To build I did this in a mingw terminal:

                "mkdir build"

                "cd build"

                "cmake -DLITESQL_WITH_MYSQL=ON ../"

 

The resulting Visual Studio project failed to build under Release mode with
linker errors.

 

I commented this stuff out of CMakeLists.txt:

"""

# the precompiled mysql client libraries are compiled with libcmt - this
causes duplicate symbols

if (MSVC)

                set(CMAKE_EXE_LINKER_FLAGS "${CMAKE_EXE_LINKER_FLAGS}
/NODEFAULTLIB:LIBCMT")

endif(MSVC)

"""

 

Now it builds no problem.

 

So it seems that the MySQL guys fixed  the /NODEFAULTLIB:LIBCMT problem and
thus this flag is no longer needed.

 

How should I contribute a patch to you guys?

Re: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

[Rahul H. <Rah...@pe...>]

Hello Gulliver, 

I checked the code, 'config.h' writes what is supported and what is not on the current compiler. The code internally is well equipped to use the alternate code if those files (inittypes.h, stdint.h, unistd.h, dlfcn.h) are not supported. I will need to check the references for failure. I guess I should be able to solve this.

Sorry for the confusion.

Rahul

-----Original Message-----
From: Rahul Hegde 
Sent: Thursday, October 04, 2012 5:09 PM
To: 'Gulliver'
Cc: lit...@li...
Subject: RE: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

Thanks Gulliver.

I did install Visual Studio 2005 (not an express edition now, as it was not able to find like 'devenv' utility to execute the development environment for express edition) and by using cmake, I provided the source + build path. Clicked on configure to select the visual studio 2005 aka 8 compiler. This now created the 'config.h' but there were some include header checks during 'cmake configure' which failed because 'inittypes.h, stdint.h, unistd.h, dlfcn.h' files are not part of visual studio. Also there were are some linux supported function used like gettimeofday, localtime_r and string functions.

I guess the pass through to this compilation successful is to add a similar windows version file/function support. Do let me know if this is what I need to do.

Rahul

-----Original Message-----
From: Gulliver [mailto:gul...@fa...] 
Sent: Thursday, October 04, 2012 1:42 PM
To: Rahul Hegde
Cc: lit...@li...
Subject: Re: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

Hello Rahul,

Am 03.10.2012 um 14:54 schrieb Rahul Hegde:
> Today as learning, I was trying to compile liteSQL on Windows7 having MS Visual Studio Express Edition 2010. I did download, the cmake executable and the source code to get the MS Visual Studio solution. I did open this solution, the compilation failed due to want of 'config.h'. This file is generated through configure command upon running it on linux system.

On Windows we use CMake instead of configure to generate the config.h and the project files for building litesql from sources.

Probably the fastest way to do this, is running the Batch-File "release_it.bat" (http://sourceforge.net/apps/trac/litesql/browser/trunk/release_it.bat) in the project root dir. 
Alternatively you can open the CMake-GUI, select Project-Dir and a target-dir for the VIsual Studio Project Files. Then push the "Configure" Button, if it runs successful you can push the "Generate"-Button to generate the Project-files.

After this you can open the Projects and compile the Project.

> I would like to know if there is documentation that would help me to compile the liteSQL on windows system having OS  as Windows7 (can be any Windows System) and Microsoft Visual Studio 2010 Express Edition (can be any MS compiler). I am planning to use backend as MS SQL.

Sorry, we don't have a Guide for building it from sources for Windows (and also not for the other platforms - perhaps this should be added to the wiki).
If you want to use MS SQL as Backend you have to write a Backend for it, we don' t have a backend for MS SQL.

Regards,
Gulliver


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Re: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

[Rahul H. <Rah...@pe...>]

Thanks Gulliver.

I did install Visual Studio 2005 (not an express edition now, as it was not able to find like 'devenv' utility to execute the development environment for express edition) and by using cmake, I provided the source + build path. Clicked on configure to select the visual studio 2005 aka 8 compiler. This now created the 'config.h' but there were some include header checks during 'cmake configure' which failed because 'inittypes.h, stdint.h, unistd.h, dlfcn.h' files are not part of visual studio. Also there were are some linux supported function used like gettimeofday, localtime_r and string functions.

I guess the pass through to this compilation successful is to add a similar windows version file/function support. Do let me know if this is what I need to do.

Rahul

-----Original Message-----
From: Gulliver [mailto:gul...@fa...] 
Sent: Thursday, October 04, 2012 1:42 PM
To: Rahul Hegde
Cc: lit...@li...
Subject: Re: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

Hello Rahul,

Am 03.10.2012 um 14:54 schrieb Rahul Hegde:
> Today as learning, I was trying to compile liteSQL on Windows7 having MS Visual Studio Express Edition 2010. I did download, the cmake executable and the source code to get the MS Visual Studio solution. I did open this solution, the compilation failed due to want of 'config.h'. This file is generated through configure command upon running it on linux system.

On Windows we use CMake instead of configure to generate the config.h and the project files for building litesql from sources.

Probably the fastest way to do this, is running the Batch-File "release_it.bat" (http://sourceforge.net/apps/trac/litesql/browser/trunk/release_it.bat) in the project root dir. 
Alternatively you can open the CMake-GUI, select Project-Dir and a target-dir for the VIsual Studio Project Files. Then push the "Configure" Button, if it runs successful you can push the "Generate"-Button to generate the Project-files.

After this you can open the Projects and compile the Project.

> I would like to know if there is documentation that would help me to compile the liteSQL on windows system having OS  as Windows7 (can be any Windows System) and Microsoft Visual Studio 2010 Express Edition (can be any MS compiler). I am planning to use backend as MS SQL.

Sorry, we don't have a Guide for building it from sources for Windows (and also not for the other platforms - perhaps this should be added to the wiki).
If you want to use MS SQL as Backend you have to write a Backend for it, we don' t have a backend for MS SQL.

Regards,
Gulliver


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Re: [litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

[Gulliver <gul...@fa...>]

Hello Rahul,

Am 03.10.2012 um 14:54 schrieb Rahul Hegde:
> Today as learning, I was trying to compile liteSQL on Windows7 having MS Visual Studio Express Edition 2010. I did download, the cmake executable and the source code to get the MS Visual Studio solution. I did open this solution, the compilation failed due to want of ‘config.h’. This file is generated through configure command upon running it on linux system.

On Windows we use CMake instead of configure to generate the config.h and the project files for building litesql from sources.

Probably the fastest way to do this, is running the Batch-File "release_it.bat" (http://sourceforge.net/apps/trac/litesql/browser/trunk/release_it.bat) in the project root dir. 
Alternatively you can open the CMake-GUI, select Project-Dir and a target-dir for the VIsual Studio Project Files. Then push the "Configure" Button, if it runs successful you can push the "Generate"-Button to generate the Project-files.

After this you can open the Projects and compile the Project.

> I would like to know if there is documentation that would help me to compile the liteSQL on windows system having OS  as Windows7 (can be any Windows System) and Microsoft Visual Studio 2010 Express Edition (can be any MS compiler). I am planning to use backend as MS SQL.

Sorry, we don't have a Guide for building it from sources for Windows (and also not for the other platforms - perhaps this should be added to the wiki).
If you want to use MS SQL as Backend you have to write a Backend for it, we don' t have a backend for MS SQL.

Regards,
Gulliver

[litesql] Compiling LiteSQL on OS: Windows7, Microsoft VS 2010 Express Edition

[Rahul H. <Rah...@pe...>]

Hello Group,

Today as learning, I was trying to compile liteSQL on Windows7 having MS Visual Studio Express Edition 2010. I did download, the cmake executable and the source code to get the MS Visual Studio solution. I did open this solution, the compilation failed due to want of 'config.h'. This file is generated through configure command upon running it on linux system.

I would like to know if there is documentation that would help me to compile the liteSQL on windows system having OS  as Windows7 (can be any Windows System) and Microsoft Visual Studio 2010 Express Edition (can be any MS compiler). I am planning to use backend as MS SQL.

I could not find much on Google and In your alias mailing list. Please provide your help here.

Regards,
Rahul

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Re: [litesql] LiteSQL Project Status

[Gulliver <gul...@fa...>]

Hi Matt,

some words from the maintenance man...

Am 18.09.2012 um 22:09 schrieb Zachara, Matt:
> That said, the LiteSQL’s current project status worries me a little. The project status is listed as: “0.3.x version is a proof-of-concept implementation, works for non-critical use”.

This status was setted by the original author, i did not change it because i want to put some new features into 0.4.x and change the status with the change to 0.4.
I saw 0.3.x as testbed for new features. 
The actual status may sound a little bit like an understatement but it is true and what we actually promise.

A Question to the list -  what does the actual users think?

> I’d like to hear some feedback on accuracy of this statement and possible reasons for what makes this statement true. I understand that LiteSQL may have limitations such as limited/no multithreading support. Are there any significant known issues that should be taken into consideration? For example, should I have legitimate concerns of data corruption when using LiteSQL?

All known issues are in the issuetracker (and the trac-instance) on sourceforge, but there are no significant issues to take into consideration. 
Data corruption caused by the usage of LiteSQL is highly impropable.

Kind Regards,
Gulliver

[litesql] LiteSQL Project Status

[Zachara, M. <Zac...@sh...>]

Hi there,

I am evaluating options for object relational mapping of the SQLite database objects with C++. To date LiteSQL appears to be compelling option. I have thus far compiled and tested the library with small a prototype and I think the interface is appropriate for our needs.

That said, the LiteSQL's current project status worries me a little. The project status is listed as: "0.3.x version is a proof-of-concept implementation, works for non-critical use".

I'd like to hear some feedback on accuracy of this statement and possible reasons for what makes this statement true. I understand that LiteSQL may have limitations such as limited/no multithreading support. Are there any significant known issues that should be taken into consideration? For example, should I have legitimate concerns of data corruption when using LiteSQL?

I appreciate any comments / feedback on the subject.

Regards,
Matt

------------------------------------------------------------

This e-mail message (including any attachments) contains confidential, non-public information. It also may be protected by the attorney/client or other applicable privileges. It is intended to be communicated only to the designated recipient(s). Unauthorized use, reproduction, dissemination, or communication of this message or any information contained in this message is strictly prohibited and may be unlawful. If you are not an intended recipient of this message, please notify the sender promptly by e-mail or telephone at the sender's location indicated above or contact Shure Incorporated at in...@sh... or 800-25-SHURE (800-257-4873).

------------------------------------------------------------

Re: [litesql] Bugs

[Gulliver <gul...@fa...>]

Hello Preston,

Am 25.07.2012 00:47, schrieb Preston Scott:
> I am currently using the litesql code on a project at work and have a 
> few bug fixes I thought I should relay.  These are using Visual C++ & 
> litesql
> 
> Blob class has no way of retrieving the raw data, I added the following 
> to field.cpp
> void Blob::getData(char * buffer, size_t bufferLength)
> {
>   if(buffer == NULL || bufferLength < m_length)
>     return;
>   memcpy(buffer, m_data, m_length);
> }

for reading partially this will be better:
void Blob::getData(char * buffer, size_t& bufferLength,const size_t
offset =0)
{
// ... needs implementation ;)
}

I will extend your implementation for this.

> Blob to string conversion was not working, modified the convert template 
> implementation in field.cpp to:
> string convert<const Blob&, string>(const Blob& value)
> {
>   if(value.isNull())
>   {
>     return "NULL";
>   }
>   else
>   {
>     string hexVal;
>     //hexVal.append("X'"); <--- not the correct syntax for litesql
>     hexVal.append(value.toHex());
>     //hexVal.append("'");
>     return hexVal;
>   }
> }

Ack.

> Finally, when reading a bigint from the database it is truncated to a 
> 32bit int, the following needs to added to compatibility.cpp
> #ifndef HAVE_STRTOLL
> long long int strtoll(const char *nptr, char **endptr, int base) {
> #indef WIN32
>   return _strtoi64(nptr, endptr, base);
> #else
>   return strtol(nptr, endptr, base);
> #endif
> }
> #endif

Thank you for your reports and solutions, a fixed version should be
available until Tuesday.

Kind regards,
Gulliver

[litesql] Bugs

[Preston S. <ps...@sm...>]

I am currently using the litesql code on a project at work and have a 
few bug fixes I thought I should relay.  These are using Visual C++ & 
litesql

Blob class has no way of retrieving the raw data, I added the following 
to field.cpp
void Blob::getData(char * buffer, size_t bufferLength)
{
  if(buffer == NULL || bufferLength < m_length)
    return;
  memcpy(buffer, m_data, m_length);
}

Blob to string conversion was not working, modified the convert template 
implementation in field.cpp to:
string convert<const Blob&, string>(const Blob& value)
{
  if(value.isNull())
  {
    return "NULL";
  }
  else
  {
    string hexVal;
    //hexVal.append("X'"); <--- not the correct syntax for litesql
    hexVal.append(value.toHex());
    //hexVal.append("'");
    return hexVal;
  }
}

Finally, when reading a bigint from the database it is truncated to a 
32bit int, the following needs to added to compatibility.cpp
#ifndef HAVE_STRTOLL
long long int strtoll(const char *nptr, char **endptr, int base) {
#indef WIN32
  return _strtoi64(nptr, endptr, base);
#else
  return strtol(nptr, endptr, base);
#endif
}
#endif

Re: [litesql] Integration

[Gulliver <gul...@fa...>]

Hello khaldon,

Am 23.04.2012 um 10:36 schrieb khaldon hmesheh:
> could you please add more information how to do that. I have tried to use it but I have got a lot of problems.

Ask for your concrete problems and you will get an answer. The usage of cmake(-gui) is documented on http://cmake.org.

Kind Regards,
Gulliver

[litesql] Integration

[khaldon h. <kha...@ya...>]

Hi,

I want to ask how to get Litesql work with MVC2008 under XP.

Thanks in Advance


Khaldon

[litesql] Implementation

[khaldon h. <kha...@ya...>]

Hello All,


I am interested in using LiteSQL - C++ Object-Relational Persistence Framework, but I have a lot of problems to make it work, could you please tell me, which step should I follow to make it run. I use mvc08 with xp.


Thanks in Advance

Khaldon

Re: [litesql] Search for an attribute from the base type

[Kitten <kit...@gm...>]

> Hi all,
>
> <object name="School" >
>    <field name="name" type="string" />
> </object>
> <object name="Person" >
>    <field name="name" type="string" />
> </object>
> <object name="Student" inherits="Person" >
>    <field name="classroom" type="string" />
> </object>
> <object name="Teacher" inherits="Person" >
>    <field name="salary" type="integer" />
> </object>
> <relation>
>    <relate object="School" handle="people" limit="one" />
>    <relate object="Person" handle="school" />
> </relation>
>
> I have a particular school, and I want to select all students from
> that school in a particular classroom. Is there any way I can do this
> without constructing the SQL manually: (select * from Student_ where
> id_ in (select Person1_ from School_Person_ where School2_ =
> SCHOOL_ID_HERE))
>
> School school(db);
>
> school.people().get( ?? ); // anything I can put in here?

So now I have it down to:

student = select<Student>(db, Student::Classroom == "SomeClassroom" &&
Student::Id.in(school.people().get().idQuery())).one();

but this is three or four times slower than:

student = select<Student>(db, Student::Classroom == "SomeClassroom");

by itself. The resulting query of the first one is:

SELECT Person_.id_,Person_.type_,Student_.classroom_ FROM
Person_,Student_ WHERE ((Student_.classroom_ = 'CLASSROOM_NAME_HERE')
and (Person_.id_ in (SELECT Person_.id_ FROM Person_ WHERE Person_.id_
in (SELECT Person_School_.Person1_ FROM Person_School_ WHERE
Person_School_.School2_ = 'SCHOOL_ID_HERE')))) and (Person_.id_ =
Student_.id_)

notice the Person_.id_ in (SELECT Person_.id_ FROM Person_ WHERE
Person_.id_ in (...

[litesql] Search for an attribute from the base type

[Kitten <kit...@gm...>]

Hi all,

<object name="School" >
    <field name="name" type="string" />
</object>
<object name="Person" >
    <field name="name" type="string" />
</object>
<object name="Student" inherits="Person" >
    <field name="classroom" type="string" />
</object>
<object name="Teacher" inherits="Person" >
    <field name="salary" type="integer" />
</object>
<relation>
    <relate object="School" handle="people" limit="one" />
    <relate object="Person" handle="school" />
</relation>

I have a particular school, and I want to select all students from
that school in a particular classroom. Is there any way I can do this
without constructing the SQL manually: (select * from Student_ where
id_ in (select Person1_ from School_Person_ where School2_ =
SCHOOL_ID_HERE))

School school(db);

school.people().get( ?? ); // anything I can put in here?

Re: [litesql] Compilation Problem

[Gulliver <gul...@fa...>]

Hi,

I was wrong, Makefile.am was also only changed on my laptop. 
The corrected Files are in svn, an updated package follows soon.

Kind regards,
Gulliver

Re: [litesql] Compilation Problem

[Gulliver <gul...@fa...>]

Hi dispy,

Am 13.10.2011 um 14:26 schrieb dispy:
> I encountered a problem compiling LiteSQL on my ubuntu machine:
> 
> libmodel.a(generator.o): In function `AbstractFactory':
> /home/user/Arbeitsfläche/Quikka/Libs/litesql-src-0.3.12/litesql-src-0.3.12/src/generator/generator.hpp:67: 
> undefined reference to `litesql::wxFormBuilderGenerator::NAME'
> libmodel.a(generator.o): In function 
> `litesql::CodeGenerator::Factory<litesql::wxFormBuilderGenerator>::create()':
> /home/user/Arbeitsfläche/Quikka/Libs/litesql-src-0.3.12/litesql-src-0.3.12/src/generator/generator.hpp:94: 
> undefined reference to 
> `litesql::wxFormBuilderGenerator::wxFormBuilderGenerator()'
> collect2: ld returned 1 exit status
> 
> 
> I don't have any clue what is going wrong there. Especially: Why does 
> litesql attempt to use some kind of wx* things?? I installed 
> wxFormBuilder using synaptic but, as expected, didn't help.

I added a generator (experimental, not complete for now) for generating wxFormbuilder files with ui-elements for the different objecttypes.

A real dependency to wxWidgets is only added for building the also not anounced "Visual Litesql"-Tools, which contains a gui for 
editing the xml-files and starting code generation.
 
Actually there seems to be an old version of Makefile.in in svn, which doesnt contain the sources for wxFormbuilderGenerator. 
Will have a look at it as soon as possible but i am actually short of time. 

A possible fix could be (if you are using configure) a run of:
./autogen.sh #this regenerates the the automake stuff and configure
./configure 
make



HTH & Kind regards,
Gulliver

[litesql] Compilation Problem

[dispy <dis...@go...>]

Hi guys,

I encountered a problem compiling LiteSQL on my ubuntu machine:

libmodel.a(generator.o): In function `AbstractFactory':
/home/user/Arbeitsfläche/Quikka/Libs/litesql-src-0.3.12/litesql-src-0.3.12/src/generator/generator.hpp:67: 
undefined reference to `litesql::wxFormBuilderGenerator::NAME'
libmodel.a(generator.o): In function 
`litesql::CodeGenerator::Factory<litesql::wxFormBuilderGenerator>::create()':
/home/user/Arbeitsfläche/Quikka/Libs/litesql-src-0.3.12/litesql-src-0.3.12/src/generator/generator.hpp:94: 
undefined reference to 
`litesql::wxFormBuilderGenerator::wxFormBuilderGenerator()'
collect2: ld returned 1 exit status


I don't have any clue what is going wrong there. Especially: Why does 
litesql attempt to use some kind of wx* things?? I installed 
wxFormBuilder using synaptic but, as expected, didn't help.


Regards

Re: [litesql] DatabaseError: Unknown backend: sqlite3

[Sandeep <sa...@b-...>]

Hello Gulliver,

Thanks for the prompt reply. I have luckily solved the problem myself, but
for others who may encounter the same issue I am putting down the steps on
how I solved the problem.

Ubuntu Linux
-----------------
I was initially having Sqlite3 installed from binaries, so it did not
generate any header files in standard locations (like /usr/include) and
hence when I did ./configure on litesql, I observed that litesql was not
detecting SqLite3, hence when I ran any example Program I was getting the
error "DatabaseError: Unknown backend: sqlite3". So I installed SqLite3 from
sources, which in turn generated header files in standard location
(/usr/include), and when I did ./configure on litesql again, it was able to
detect SqLite3 and hence the error got vanished. My hint to other users in
such scenarios is, your ./configure of litesql may pass without errors, but
you must keep an eye on SqLite3 support being added or not in the
config.log.

@@Gulliver: But I feel that liteSql must detect SqLite3 even when SqLite3 is
installed from binaries rather than sources???

Thanks and Best Regards,
-Sandeep A

-----Original Message-----
From: Gulliver [mailto:gul...@fa...] 
Sent: Monday, August 22, 2011 12:29 PM
To: Sandeep
Subject: Re: [litesql] DatabaseError: Unknown backend: sqlite3

Hello Sandeep,

Am 21.08.2011 um 08:54 schrieb Sandeep: 
> 
> When I run the example program (./example) present in the examples
directory of litesql, I get the error "DatabaseError: Unknown backend:
sqlite3". I am not able to figure out what is going wrong?
> I have installed sqlite3 already and I also tried out some commands on
sqlite3 command line interface. But when I try to connect using the example
program I am getting the error "DatabaseError: Unknown backend: sqlite3".

On which operating system do you work? 
How did you configure litesql - with cmake or autotools, do you have any
outputs of these run?

sqlite3(-backend) is in any case included on Windos, on *NIX-System it
depends on the sqlite3-headers (a package name like sqlite3-dev). 

Kind Regards,
G.

[litesql] DatabaseError: Unknown backend: sqlite3

[Sandeep <sa...@b-...>]

Hello all,

 

When I run the example program (./example) present in the examples directory
of litesql, I get the error "DatabaseError: Unknown backend: sqlite3". I am
not able to figure out what is going wrong?

I have installed sqlite3 already and I also tried out some commands on
sqlite3 command line interface. But when I try to connect using the example
program I am getting the error "DatabaseError: Unknown backend: sqlite3".

 

Please help me out as we have to start the project immediately and we want
to use LiteSql and SqLite3.

 

Thanks and Best Regards,

-Sandeep A

Re: [litesql] Some questions on litesql

[Tero L. <ter...@ik...>]

Hello Joe,

The support and development of litesql is somewhat limited at the
moment. There is no built-in support for lazy loading nor for smart
handling of large datasets. Also, the documentation online is
basically the only documentation there is.

Best Regards,
Tero Laitnien

On Sat, Jul 23, 2011 at 3:16 PM, dem...@li... <dem...@li...> wrote:
> Hello to all,
>
> I have come across litesql while looking for a C++ ORM framework for a cross
> platform application using sqlite3. I have some questions:
>
> - Do you plan on keeping supporting and developing litesql in the future?
> - Does litesql support lazy loading and/or other mechanism for smartly
> handling large datasets? Are these configurable?
> - Is there documentation available? I have found only the Documentation links
> at http://sourceforge.net/apps/trac/litesql
>
> I haven't yet browsed through the sources so I apologize if the questions are
> trivial.
>
> Thank you and great job!
> Best Regards,
> Joe
>
> ------------------------------------------------------------------------------
> Storage Efficiency Calculator
> This modeling tool is based on patent-pending intellectual property that
> has been used successfully in hundreds of IBM storage optimization engage-
> ments, worldwide.  Store less, Store more with what you own, Move data to
> the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
> _______________________________________________
> Litesql-users mailing list
> Lit...@li...
> https://lists.sourceforge.net/lists/listinfo/litesql-users
>

[litesql] Some questions on litesql

[<dem...@li...>]

Hello to all,

I have come across litesql while looking for a C++ ORM framework for a cross 
platform application using sqlite3. I have some questions:

- Do you plan on keeping supporting and developing litesql in the future?
- Does litesql support lazy loading and/or other mechanism for smartly 
handling large datasets? Are these configurable? 
- Is there documentation available? I have found only the Documentation links 
at http://sourceforge.net/apps/trac/litesql

I haven't yet browsed through the sources so I apologize if the questions are 
trivial.

Thank you and great job!
Best Regards,
Joe

[litesql] Cannot find litesql-utild.lib

[Dilip R. <mis...@gm...>]

I have two problems with litesql. I recently downloaded version 0.3.11

1) I am unable to successfully link my application in debug mode without
litesql-utild.lib. The win32 distribution only installs litesql-util.lib
(i.e the release version). For the other two binaries there are both debug
and release versions (litesql/litesqld, litesql_sqlite/litesql_sqlited).
Without the debug version of litesql-util.lib, the linker complains (using
Visual C++ 2010):

litesql-util.lib(string.obj) : error LNK2038: mismatch detected for
'_ITERATOR_DEBUG_LEVEL': value '0' doesn't match value '2' in MyFile.obj
litesql-util.lib(split.obj) : error LNK2038: mismatch detected for
'_ITERATOR_DEBUG_LEVEL': value '0' doesn't match value '2' in MyFile.obj

2) Where is the link to the latest litesql dtd file? The changelog for
0.3.11 says that support for 'bigint' has been added but the dtd file
present at the link:
http://sourceforge.net/apps/trac/litesql/attachment/wiki/DefiningDatabase/litesql.dtddoesn't
say anything about bigint.

Re: [litesql] 64 bit integers?

[Gulliver <gul...@fa...>]

Hello Rush,

Am 28.06.2011 01:00, schrieb Rush Manbert:
> Does litesql support 64 bit integer types? It doesn't look like it, but there may be some magic that I'm missing.

You are right, there is actually no support for 64-bit integers (bigint
in mysql and postgres). I have added a ticket "support for bigints" to
the list of enhancements for version 0.4.1.

Kind regards,
gulliver

[litesql] 64 bit integers?

[Rush M. <ru...@ma...>]

Hi,

Does litesql support 64 bit integer types? It doesn't look like it, but there may be some magic that I'm missing.

Thanks,
Rush