the implementation is about as good as it can
be.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users
before xBestIndex and xFilter support was added). Due to the
requirements of the implementation, POSIX reader/writer locks are used
so there is some low-contention locking overhead.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick
little additional overhead) vs a native table?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users
no one
has posted a follow-up on.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users
her thread?
In this use case is sqlite3 usage "thread safe" or is behavior
unstable due to sqlite3_step(), sqlite3_reset(), and result column
accessors accessing/disrupting data from the result set of the other
thread?
Thanks,
Bob
--
Bob Friesenhahn
bfrie...@simpl
On Wed, 15 Feb 2017, Simon Slavin wrote:
On 14 Feb 2017, at 11:51pm, Bob Friesenhahn <bfrie...@simple.dallas.tx.us>
wrote:
One of our Linux programs (not written by me) is reporting errors of the form
"SQLITE_CORRUPT: database disk image is malformed database corruption".
e the most likely cause of the
problem. Windows headers are very unclean and its pre-processor
definitions often overwrite user code.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.Graphics
, or if it is a SQLite3 implementation logic issue
(something to do with a deferred moveto). Why should destroying a
prepared statement care about a cursor's deferred moveto?
Bob
On Wed, 15 Feb 2017, Bob Friesenhahn wrote:
It turns out that I have more data on the problem. The error message
reported
0;
70278 p->cacheStatus = CACHE_STALE;
70279 return SQLITE_OK;
70280 }
Ideas?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
s
On Tue, 14 Feb 2017, Richard Hipp wrote:
On 2/14/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
Due to memory constraints
(at least 1MB is consumed per connection!), only one database
connection is used. Any thread may acquire and use this one database
connection at an
the other thread?
Not if they’re using the same statement. A statement is a stateful
object, so using it on multiple threads is probably going to cause
problems.
To be clear, each thread is using its own prepared statement.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http
an approach where table rows are updated
one by one so that we can know which table row update failed. This
causes other issues since whole-row or inter-table consistency checks
may temporarily fail.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen
intended to ease certain
aspects of SQLite development which are assisted from a portable
implementation with no external dependencies.
The mere existence of an implementation does not mean that it is a
defect.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users
u may have an issue with write
amplification at the filesystem level.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing l
. The useful mass storage
offerings for hardware running MacOS is rather limited.
Operating systems where fsync() or fdatasync() do not truely commit
data to hardware are broken.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick
rrect code to return? If a cursor is being navigated,
then I would prefer that the cursor continue to the next result row.
Thanks,
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.Graphics
. The case
where the row might no longer exist is for xRowid(), but this function
does not seem to be called for the table I am looking at.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
exploit opportunities and now SQL
injection exploit opportunities also become shell exploit
opportunities.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
CPU usage? If sqlite3 consumes 2X less "CPU
cycles" since 2009 is there a way to measure how much less actual CPU
time that it takes in order to validate that there is a clear
relationship?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfri
time it is executed. Any other factor on the machine would
impact perf results.
It seems that cachegrind produces absolutely consistent results which
do not depend on I/O, multi-core, or VM artifacts.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users
On Thu, 29 Dec 2016, Richard Hipp wrote:
On 12/29/16, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
Is there a way to know how well cachegrind CPU
cycles map to real-world CPU usage?
Not that I know of. If you have any suggestions, please speak up.
I tried to make clear in th
.
That would explain the inflection point and more rapid progress
starting at that time.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite
0 0 0 vtab:CB170000
29String80 110 bar00
30Goto 0 1 000
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsM
improperly
constructed and was implemented based on observed behavior at the
time. There is inadequate tracing in the code so proper tracing will
be added when it is re-written.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintaine
rstand why the libtinfo requirement was added for libedit.
Lonnie
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Bob Friesenhahn
bfrie...@simple.dallas
tries to improve apparent performance by intentionally
not obeying the rules.
Transaction performance over NFS may not be very good (depending on
properties of server and client) but that does not equate to
corruption or failed locking.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us
tly as-is in the SQL field of the schema table
(main.sqlite_master) and is easy to parse out later, or use a standard tool
Are these comments loaded into memory used by each program which
connects to the database? If so, more resources are consumed.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.t
are not supported, then
it becomes prohibitive to enable this mode on an existing code base.
Given that each sqlite connection duplicates the entire database
schema in RAM, this shared cache mode becomes quite useful on limited
memory systems. It would be good if it worked `proper
, the database
schema reduces to just 62k so there is a 10X benefit. With 10
processes/connections, almost 6MB could be saved with our database.
It is likely that the compression ratio is less when compressing many
small fragments of text.
Thoughts?
Bob
--
Bob Friesenhahn
bfrie
m all to 4
characters? That isn't a lot of space, but it is a start.
This seems like a good idea and does not limit human comprehension
much, particularly if it is done as a step while preparing the final
database.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesy
should be consumed.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
In sqlite_master I see quite a lot of "sql_autoindex" indexes. Do
these auto indexes consume the same RAM as explicit indexes?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.Graphics
On Thu, 16 Mar 2017, Richard Hipp wrote:
On 3/16/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
The schema (already stripped to remove white space and comments) for
our database has reached 664K
Yikes. That's about 10x or 20x what we typically see. Are you able
to shar
ly see admonishments about
problems which may occur in sqlite3_close() if other requests have not
been completed properly.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagi
On Thu, 6 Apr 2017, Simon Slavin wrote:
On 6 Apr 2017, at 2:38pm, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
Is calling sqlite3_close() prior to exiting a requirement in general for
sqlite? I was not aware of this requirement.
Do you explicitly call sqlite3_sh
e bash is very popular, it is hardly a representation of a
standards-conformant/enforcing shell. It is popular because of its
extensions and because of its interactive behavior.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Main
ode or refer to them specifically within the
namespace you created. I have done this successfully across many C++
compilers for 19 years already.
It would definitely be best if sqlite does not pollute the name space
with names not starting from a common prefix.
Bob
--
Bob Friesenhahn
bfrie...@simpl
On Sun, 9 Apr 2017, dip wrote:
What happens with mangling then? extern "C" functions inside a namespace just
do not get mangled? If so, sounds like a workaround.
Yes, extern "C" functions don't get mangled.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://w
or everyone.
A way to get rid of the annoying 'sqlite::' prefix for plain C
functions is to import the functions actually planned to be used into
global scope or into the namespace of the using code:
namespace MyNamespace
{
using sqlite:sqlite3_exec;
}
Bob
--
Bob Friesenhahn
bfrie...@simpl
memory-mapping the database may speed access by decreasing
programmed I/O for queries which only do reads. This assumes that
there is some commonality among the data used by the queries so there
is a high probability that often accessed data is already in RAM.
Bob
--
Bob Friesenhahn
bfrie
under Windows.
Based on my experience, Python with the APSW extension is an excellent
way to create "write once" code as long as you are able to use Python.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintaine
On Wed, 1 Mar 2017, Simon Slavin wrote:
On 1 Mar 2017, at 7:27pm, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
What is the recommended approach to diagnosing "Database is locked" errors and
determining the guilty party?
Are you checking the result codes return
it is closed.
What is the correct expectation?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users
it.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
s free to adopt this same test.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqli
then there will be
severe problems.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
an attacker was able to
write into).
Apple's OS X and Microsoft Windows always try to load from the current
directory.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
__
enable
== 1 order by name;
names
rf_band verbose moca_core_trace_enable preferred_nc lof_update bonding
Notice that adding a 'where' clause has caused the order to be
reversed from what was requested in the query. Why is this and what
can I do to correct it?
Thanks,
Bob
--
Bob Friesenhahn
On Tue, 15 Aug 2017, Dan Kennedy wrote:
On 08/15/2017 10:12 PM, Bob Friesenhahn wrote:
select group_concat(name, ' ') AS 'names' from moca_config where enable ==
1 order by name;
Maybe this:
select group_concat(name, ' ') AS 'names' from (
SELECT name FROM moca_config where enable == 1
/O operations possible within a given amount of time (IOPS) rather
than the bandwidth (bytes/second) available.
If the database is small enough to fit in the OS filesystem cache,
then hardly any I/O operations to underlying store will be needed to
satisfy requests.
Bob
--
Bob Friesenhahn
bfrie
the solution is to
just not use icc?
Sqlite3 has been cycle-optimized for GCC. You now have 29-days to
also cycle-optimize it for ICC.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
st by 2050.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlit
ld be using a different sqlite version.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@maili
On Wed, 9 Aug 2017, Lars Frederiksen wrote:
I would appreciate very much if you clever people out there have some
booktitles or links to tutorials (websites, video etc) about SQLite.
The O'Reilly book "Using SQLite" has been the most useful book for me
thus far.
Bob
--
Bob F
rogramming practices resulting in SQL injection attacks. Sqlite
should not promote such practices.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.Graphics
On Fri, 4 Aug 2017, Peter Da Silva wrote:
On 8/4/17, 8:29 AM, "sqlite-users on behalf of Bob Friesenhahn"
<sqlite-users-boun...@mailinglists.sqlite.org on behalf of bfrie...@simple.dallas.tx.us>
wrote:
Lazy programmers who request such things are of the same ilk which
ovided by other operating systems.
I am still using NFS mounted home directories across all systems here
(since 1993). No significant problems have been encountered during
that time.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
Graphics
Does anyone know why using 'PRAGMA cache_size=0' (or some other small
value) to attempt to decrease memory usage (and it is reported as
immediately decreased in the shell by .stats) actually significantly
increases heap memory usage?
I find this to be an interesting phenomena.
Bob
--
Bob
On Thu, 18 May 2017, Simon Slavin wrote:
On 18 May 2017, at 5:10pm, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote:
Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) to
attempt to decrease memory usage (and it is reported as immediately dec
On Thu, 18 May 2017, Kim Gräsman wrote:
On Thu, May 18, 2017 at 6:10 PM, Bob Friesenhahn
<bfrie...@simple.dallas.tx.us> wrote:
Does anyone know why using 'PRAGMA cache_size=0' (or some other small value)
to attempt to decrease memory usage (and it is reported as immediately
dec
schema takes a bit over 1MB to load on a 32-bit CPU. The
increased usage we are seeing is on the order of 200k so it is not the
schema. Regardless, the application is using the database immediately
so it must always consume the schema.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http
for me to do is
to send you the modified file privately.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite
s, 'pragma integrity_check' never finds a problem with
the database. Regardless, it seems that once the problem starts
happening, it recurs given the same starting database. The starting
database is already a product of VACCUM before any other software
starts to use it.
Bob
--
Bob Friesen
better for all platforms and compilers )
This causes problems given that there are varying configuration
methods, but this annoying logic should get rid of the warning:
#if defined(SQLITE_4_BYTE_ALIGNED_MALLOC) && SQLITE_4_BYTE_ALIGNED_MALLOC
Bob
--
Bob Friesenhahn
bfrie...@simple.dall
s unsigned types.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlit
. Sqlite could fix its copy
but you should report this upstream from where it came from so that
all Tcl extensions which update their TEA package will benefit.
See http://wiki.tcl.tk/327 and https://github.com/tcltk/tclconfig
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http
icense text in
documentation (assuming that the dependent software provides any
documentation).
https://opensource.org/licenses/BSD-2-Clause
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagi
tried setting the POSIX standard TMPDIR environment variable?
This might have useful influence under Android.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
HTTPS
connection to the remote server.
Many HTTPS clients have been found to be doing wrong things.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
;wget" are slightly
out of date.
The certificates used by the browser are usually provided by the
browser vendor and so they are not necessarily provided by the OS
vendor. If 'wget' does not know about 'Lets Encrypt' then merely
waiting is unlikely to solve the problem.
Bob
--
Bob Friesen
if server certificate checks are disabled.
It is much easier to add to the certificates used by the system given
that wget already works.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
Encrypt-friendly machine or from the Let's Encrypt site.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users
is
willing to consume?
The range of a double value is typically 2.225074e-308 to
1.797693e+308.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
SMTP email (I don't
remember that it does), then the problem is worse.
If only one new subscription is allowed on the list per day, then
there is a trivial DOS (no new valid subscriptions are possible) as
soon as the one daily subscription has been consumed.
Bob
--
Bob Friesenhahn
bfrie...@simpl
that is not true.
Something else which can take substantial time which is not attributed
to the program is memory page faults. These might not be attributed
to the program (e.g. as 'sys' time) since a kernel driver performs the
I/O for page faults.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us
system stores files in a MS-DOS/Windows FAT
filesystem then you are subject to the limitations of that filesystem.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
ing of software from source code should always be under the
complete control of the person who is performing the build and should
inherently support use of local files which may contain local changes.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfri
common in laptop PCs.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailingl
you think that it
is appropriate to pass it the string 'xyzzy'?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sq
necessary safe-guards to ensure that only valid
data goes into the database, sqlite puts the using application at risk
(security and stability) with its wishy-washy ways.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintaine
' in 'sqlite3' does not prohibit the same database from being
developed by many programers using a variety of programming languages
and scripts to solve very large problems. The stability of the sqlite
file format and column type integrity are two different things.
Bob
--
Bob Friesenhahn
bfrie
On Fri, 29 Jun 2018, Richard Hipp wrote:
On 6/29/18, Bob Friesenhahn wrote:
Without adding all the necessary safe-guards to ensure that only valid
data goes into the database, sqlite puts the using application at risk
(security and stability) with its wishy-washy ways.
Can you provide
.
The security of SQLite depends on how it is built, the environment in
which it is used, and the arguments supplied to it.
If arbitrary SQL commands can be sent into SQLite, then good luck and
best wishes regarding security.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http
. Are there such tools available for Fossil?
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
with a DVCS, the whole repository normally needs
to be duplicated first.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing
on depends on
_POSIX_C_SOURCE >= 1 || _XOPEN_SOURCE || _BSD_SOURCE || _SVID_SOURCE
|| _POSIX_SOURCE
but Solaris is proven to be Unix-compliant so the rules could be
somewhat different.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagi
An Autoconf configure script which uses this macro:
AC_USE_SYSTEM_EXTENSIONS
will likely expose those prototypes.
Solaris has the __EXTENSIONS__ define (e.g. -D__EXTENSIONS__=1) to
enable all extensions. Otherwise you could try -D_XOPEN_SOURCE=500
and see if that helps.
Bob
--
Bob Friesenhahn
bfrie..
with VmSwap=0) is more interesting since it indicates how
much memory is actually being used.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org
memory which could be
from a heap allocation (with no subsequent writes to it) or due to
memory mapping something such as a file. The cause of the the usage
may be deduced by inspecting the /proc/[pid]/smaps content on a Linux
system where '[pid]' is the process id of the program.
Bob
--
Bob
If you really only have 160KB of RAM (vs 160MB), then that would be
prohibitive. Linux and SQLite are not going to be able to run with
160KB of RAM.
Otherwise, it sounds like a fine idea.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen
90 matches
Mail list logo
