Hi, Richard, Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Thu, Aug 22, 2013 at 10:38 AM, Markus Schaber <m.scha...@codesys.com>wrote: > > During our internal tests, I recently stumbled across a problem when > > using SVN, which uses SQLite to manage the "wc.db" metadata database > > in the working copy. > > > > SVN itself uses the Apache APR as PAL, which internally uses the > > Windows Unicode APIs with the \\?\ path prefix, allowing path lengths > > of up to 32k characters, so it can deal fine with deep directory > > hierarchies. > > > > Except when using SVN externals within those deep hierarchies. > > Externals are managed via nested working copies coming with their own > > "wc.db", so it's easy to run into the MAX_PATH limit of 260 > > characters. > > > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg18707.html > > seems to indicate that SQLite is not using those APIs. On the other > > hand, that post is of 2006. > > > > So my questions are: > > > > Is there any way to successfully open a database at such a long path > > location? > > (1) Move the database file to a new location with a shorter pathname.
This won't work in my case, as the path name is dictated by the working copy layout and location - svn expects the wc.db to sit within the ".svn" directory of the working copy. > (2) SQLite version 3.8.0 allows for longer windows pathnames up to 3*MAX_PATH > bytes, which is 3x more space that was allowed before. This is still not 32K > but might be sufficient for your needs. The limit can be extended at > compile-time. >[....] > SQLite version 3.8.0 allows you to recompile with - > DSQLITE_WIN32_MAX_PATH=nnnn with however large of filename length limit you > desire. This sounds like a viable solution. SVN embeds the SQLite amalgamation, IIRC, so it should be possible to raise the limit. I'll relay your suggestion to the SVN developers. Best regards Markus Schaber -- CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH Inspiring Automation Solutions 3S-Smart Software Solutions GmbH Dipl.-Inf. Markus Schaber | Product Development Core Technology Memminger Str. 151 | 87439 Kempten | Germany Tel. +49-831-54031-979 | Fax +49-831-54031-50 E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: http://store.codesys.com CODESYS forum: http://forum.codesys.com Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade register: Kempten HRB 6186 | Tax ID No.: DE 167014915 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
