1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>For SQLite: GNOME Data Access 5 manual</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.79.1">
<link rel="home" href="index.html" title="GNOME Data Access 5 manual">
<link rel="up" href="limitations.html" title="Limitations">
<link rel="prev" href="limitations_postgres.html" title="For PostgreSQL">
<link rel="next" href="limitations_sqlcipher.html" title="For SQLCipher">
<meta name="generator" content="GTK-Doc V1.32 (XML mode)">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="5"><tr valign="middle">
<td width="100%" align="left" class="shortcuts"></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="16" height="16" border="0" alt="Home"></a></td>
<td><a accesskey="u" href="limitations.html"><img src="up.png" width="16" height="16" border="0" alt="Up"></a></td>
<td><a accesskey="p" href="limitations_postgres.html"><img src="left.png" width="16" height="16" border="0" alt="Prev"></a></td>
<td><a accesskey="n" href="limitations_sqlcipher.html"><img src="right.png" width="16" height="16" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="limitations_sqlite"></a>For SQLite</h2></div></div></div>
<p>
The following limitations apply to SQLite databases accessed via Libgda:
</p>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.3"></a>Last inserted row's values</h3></div></div></div>
<p>
The <a class="link" href="GdaConnection.html#gda-connection-statement-execute-non-select" title="gda_connection_statement_execute_non_select ()">gda_connection_statement_execute_non_select()</a>'s last_insert_row attribute uses the hidden "_ROWID_" column for each table, but it may fail if the table has a column with the same name.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.4"></a>Date and time</h3></div></div></div>
<p>
As SQLite stores dates and times as strings, <span class="application">Libgda</span> only handles dates in the format recommended by SQLite,
which is "YYYY-MM-DD" for dates, "HH:MM:SS" for times and "YYYY-MM-DD HH:MM:SS" for timestamps (see
<a class="ulink" href="http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions" target="_top">SQLite's documentation</a>).
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.5"></a>Timezone information</h3></div></div></div>
<p>
Timezone information associated with time and timestamp data types is not stored by PostgreSQL, so when executing
statements all the variables containing a time or timestamp information are converted to GMT (timezone 0) before
the execution happens. The consequence is that for example if a variable holds the "11:23:55+2" time (11 hours,
23 minutes and 55 seconds, at GMT + 2), then the actual time stored in the database will be "09:23:55", the same
time but GMT.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.6"></a>Multi threaded environment</h3></div></div></div>
<p>
No limitation if sqlite has been compiled with the SQLITE_THREADSAFE=1 flag (which is the case for the
embedded version of SQLite). If the system installed SQLite is used and if it was not compiled using that
flag, then <span class="application">Libgda</span> sets the SQLite library in a state where multi threading is fully supported.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.7"></a>Error reporting</h3></div></div></div>
<p>
If there is not enough free space on the disk which stores an SQLite database, you may have some
"Disk I/O error" errors. This is also true for meta data connections which are by default
created in a temporary location.
</p>
</div>
</div>
<div class="footer">
<hr>Generated by GTK-Doc V1.32</div>
</body>
</html>
|
