[pysqlite] what is best data structure

"Dinesh B Vadhia" <[email protected]> Tue, 14 Jul 2009 08:44:50 -0700
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
This is a multi-part message in MIME format.

--===============2052241042==
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00B1_01CA045F.5986EF60"

This is a multi-part message in MIME format.

------=_NextPart_000_00B1_01CA045F.5986EF60
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Using Python, lists of integers are stored in sqlite as strings ie. "123 =
234 345 456 567 678 789 890 901 1012 1123 etc." .  The strings can be =
very long and of variable length.  Next, I want a non-Python program =
(eg. C/C++) to be able to read the sqlite db (ie. data portability).  Is =
there a faster data structure than a list or a more compact format than =
character strings available to store the lists of integers in a sqlite =
db and ensure portability?

Dinesh






------=_NextPart_000_00B1_01CA045F.5986EF60
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3DWindows-1252 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18783"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#000080 face=3DGaramond>Using Python, lists of =
integers are=20
stored in sqlite as strings ie. "123 234 345 456 567 678 789 890 901 =
1012 1123=20
etc." .&nbsp; The strings can be </FONT><FONT color=3D#000080 =
face=3DGaramond>very=20
long and of variable length.&nbsp; Next, </FONT><FONT color=3D#000080=20
face=3DGaramond>I want a non-Python program (eg. C/C++) to be able to =
read the=20
sqlite db (ie. data portability).&nbsp; Is there a faster data structure =
than a=20
list or a more compact format than character strings available to store =
the=20
lists of integers in a sqlite db and ensure portability?</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 face=3DGaramond>Dinesh</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 face=3DGaramond></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 =
face=3DGaramond></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00B1_01CA045F.5986EF60--


--===============2052241042==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
--===============2052241042==--