Messages

76

ThumbsPlus v7-v9 Questions / Images Browsing with Sqlite3 Database

« on: 2013-08-04 04:44:46 »

I tried using en external SQL server (Postgres on a Linux box).

I found that the action you mention is definitively slower than when using the standard local Microsoft database engine (aka "Access") on a file located on the same Linux box and accessed via CIFS (aka Samba),  but by far not as sluggy as you describe.

Of course searching the database is fast as lightning :)

-Michael

77

ThumbsPlus v7-v9 Questions / multiple instances

« on: 2013-08-04 04:34:08 »

> (My DB is reaching its practical limits!)

The new TP allows for using the SqLite databases engine. ( see http://www.cerious.com/release_notes80.shtml )

AFAIK same does not have this limitation.

I suppose there is a way to migrate an existing database.

-Michael

78

ThumbsPlus v7-v9 Questions / Grainy Resizing?

« on: 2013-08-03 08:58:52 »

While "Bicubic" usually works rather well for downsizing, with pictures that include narrow lines (e.g. hair, high voltage wires, ...) I often get results with an unnatural touch (fuzzy highlights added etc).

This can be prevented when applying some blur filter before resizing.

That is why I often use the "Lanczos" algorithm provided by the free Irfanview software. Same usually works perfect for downsizing.

It would be great if TP would provide this algorithm out of the box or as a pluging.

-Michael

79

ThumbsPlus v7-v9 Questions / Custom Menus

« on: 2013-07-21 02:31:42 »

In fact I could drag and drop stuff Like "Customize" -> "Commands" -> "Python" -> "Run"

Into the menu and thus they appear as a sub-menu.

Right click on that sub-menue now allow for changing the the picture shown. But I don't find a way to assign a Python script to that sub-menu.

-Michael

80

ThumbsPlus v7-v9 Questions / Custom Menus

« on: 2013-07-21 02:18:10 »

Thanks for the reply ! (I forgot to check the notification box and so I only now foumnd it)

>Options / Customize / Commands
I did see this before

>Then in Categories scroll down to New Menu at the bottom. Then in Commands, drag New Menu to your menu bar.

Ahhh ! I did not find out that I need to drag&drop !(I do see that it is written there ;) )

>Now you'll have an item in your menu named New Menu. You can right-click on it and edit its properties.

I in fact have the "New Menu" and clicking on same opens an empty sub-menu box.

I was able to rename it following the instructions Daan provided.

>If you shut the Customize dialog you have to reopen it in order to edit the new menu item's properties.

That is what I did.

>I want it so that I can group some frequently used commands in an easy-to-access location. For instance I frequently crop pictures to the same proportion. That's alt-t, ti, r. Doesn't sound like much, but by putting it on a custom menu, it becomes alt-j, c. Much faster and doesn't break my thought process as much.

Nice.

But My intention is to tart some Python scripts I am going to write with that menu. Any Idea how to do that ?

-Michael

81

ThumbsPlus v7-v9 Questions / Custom Menus

« on: 2013-07-14 06:27:13 »

>I've managed to add a menu item to the main menu in the View window, so that the menu now reads: File, Edit, Image, Transform, View, New Menu, Help

How did you do this.

I did try and I was able to create an additional "Custom 1" bar, but I failed on (simply) creating another menue.

I.e. I intend to call one or several a custom Python scripts with this menue or it's siblings.

Do you want to do something like this, as well ?

-Michael

82

ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL

« on: 2013-07-07 04:34:32 »

If you create a database without thumbnail pictures (and somehow done in a way that the TP software sees that it is not meant for external Thu7mbnail pictures) it is very likely that loading this database in TP and rescan all directories will create new thumbnail pictures within the database and leave all additional information untouched.

-Michael

83

ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL

« on: 2013-07-07 04:09:12 »

I don't understand.

The Thumbnail fields are in the old database to be converted, So I think they just stay - as the conversion is an in-place process, just generating filling the new fields with appropriate information (and perhaps purging legacy information).

If you - fro whatever reason - need to re-thumbnail such a huge count of images, it is no wonder that it takes a really long time.

-Michael

84

ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?

« on: 2013-06-29 03:59:59 »

I checked and the inner loop is:

        cols, utimes = tdbcon.execute_with_data(u'select [idThumb], [file_time], [thumbnail_time] from [Thumbnail] where [idThumb] >= %s and [idThumb] <= %s' % (i, i + 999) )
        i = i + 1000
        if not cols:
            continue
        for utime in utimes:
            tdbcon.execute_direct(u"update [Thumbnail] set [file_time_iso] = '%s', [thumbnail_time_iso] = '%s' where idThumb = %s" % (isotime(utime[1]), isotime(utime[2]), utime[0]) )
        done += len(utimes)
        tpprog.doing_progress(done)


I understand that the "tdbcon" object handles access to the database. I doubt that it looks at the image files.

Thus this supposedly just is a very slow database operation.

I am not a database expert, but I do know that in many cases using an index on appropriate fields can speed up certain operations greatly. I understand that this can be done with the mySQL admin tool.

-Michael

85

ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?

« on: 2013-06-29 01:24:30 »

> but to read every image file header from the OS, and then write the time to the database is going to be VERY slow!

Do you suggest that the "upgrade stript" in fact loads the image file and not just works on the database entries ?

We would need to take a look at the python scrip to find this out. Happily the source code pf the script is provided by Cerious and this it can be examined (and modified if appropriate).

-Michael

86

ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?

« on: 2013-06-29 01:19:51 »

> I've checked the script (upgradeserver.py) and it is very close to the end.

How did you check this ?


I am asking, because I would like to do my own Python scrips and (somehow) integrate them in the TP9 user interface (icon, mene entry and/or hotkey).

While I am sure that I can easily learn how do do Python scrips, I did not find any documentation on how to start and debug them. So I did not take on the task yet.

Thanks for any pointers.
-Michael

87

ThumbsPlus v7-v9 Questions / 3928 No database import

« on: 2013-06-29 01:14:12 »

> However adding the import command icon to a tool bar does work.

How did you do that ? Is such action found in the help ?

Thanks,
-Michael

88

ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL

« on: 2013-06-29 01:10:47 »

To me it seems that eporting / importing the database content does not need any specifics of the TP program itself.

Can you try to use native import / exports scripts by mySQL ?

-Michael

89

ThumbsPlus v7-v9 Questions / ThumbsPlus v9 build 3928 is now available!

« on: 2013-06-15 06:16:58 »

Just installed the new release.

In issue I reported has been fixed. Thanks !


OTOH:

I still don't see any hint (in the help or anywhere else) about how to install a user-made python script so that it can be started (by a hotkey and/or menu) to do some work on selected files.

Thanks,

-Michael

90

ThumbsPlus v7-v9 Questions / Thumbnail Orientation 3928

« on: 2013-06-15 06:08:40 »

Obviously, as these don't use the thumbnails at all.

-Michael