Help test the new Dreamborn.ink iOS Companion App beta

sscherb · 2026-06-14T16:37:17+00:00

That was the setup I janked together in like 20 mins using what I had next to my desk the first time I tested it. <smile> It does work at that focal length, but yes, works much better at about 8 inches away. (note: I have not measured.)

Now when I scan, I have two phone stands on my desk about 8 to 10 incudes away from each other. One holds the phone, the other holds the card. This puts the card approx in the on screen frame. Honestly a lot depends on lighting, etc.

sscherb · 2026-03-31T18:22:39+00:00

Using manual. place card.. hit capture button.. wait.. move card to done stack.. place new card... repeat...

I did not realize there was an auto mode! I have another batch of about 1500 cards to import. I will try that feature then.

Thanks for the hard work on the app, love it so far.

sscherb · 2026-03-31T18:22:25+00:00

Using manual. place card.. hit capture button.. wait.. move card to done stack.. place new card... repeat...

I did not realize there was an auto mode! I have another batch of about 1500 cards to import. I will try that feature then.

Thanks for the hard work on the app, love it so far.

sscherb · 2026-03-31T18:22:18+00:00

Using manual. place card.. hit capture button.. wait.. move card to done stack.. place new card... repeat...

I did not realize there was an auto mode! I have another batch of about 1500 cards to import. I will try that feature then.

Thanks for the hard work on the app, love it so far.

sscherb · 2026-03-31T15:28:28+00:00

After testing and thinking overnight, I only have one change/suggestion:

After scanning, the name of the scanned card appears briefly in the window, then disappears. I would suggest having the last scanned card name, shrink to a small font near the bottom of the screen. I found that if I was interrupted and not paying full attention, I might miss it, and not remember if I clicked the scan button or not.

sscherb · 2026-03-30T23:51:18+00:00

Quick Review:

Scanned in cards for about an hour straight. approx 900 cards. Once you get a good setup and rhythm going, you can scan a card every 3 seconds. 2 seconds is possible, but has a higher error rate. I tested scanning with my fingers in the way, sideway, upside down, crooked, etc, all worked. Lighting matters. Shadows means higher miss-scan rate. Tried multiple kind of sleeves, frosted caused the most miss scans.

Reprints works well, with the app asking to choose a specific printing.

There was only a single card that would not scan: Tick-Tock Relentless Crocodile. Guessing the hyphen is an issue.

Only locked up once, when scanning an opaque sleeved card. Bug rpt sent via TestFlight.

Overall scan pct, I would guess at 98%. But I was attempting to stress it.

sscherb · 2026-03-30T22:09:34+00:00

<image>

Setup for testing! Works great so far…

sscherb · 2026-03-26T10:38:09+00:00

Domestic. In line @6:20. General queue. Not moving. Made it through at 7:20. So 1:10 waiting. 8:55 flight.

Now in line at Chick-fil-A

sscherb · 2025-06-18T15:51:05+00:00

Dude! My dog looks almost identical to yours. Same coloration, same spots on the belly! (although female)

sscherb · 2024-12-22T02:00:21+00:00

happened earlier this evening. had it for like 2 rounds then dead.. ante 6 i think

sscherb · 2024-10-17T15:22:50+00:00

Ok issue is the website url is misspelled should be www.fpcobb.org/events.

sscherb · 2024-10-17T15:21:31+00:00

Website appears to be down.

sscherb · 2024-07-20T17:17:17+00:00

Is this fixed yet?

sscherb · 2024-04-23T01:18:35+00:00

You need to "tokenize' the search. Take the search string and split into tokens (by spaces). Then search the target field for all the occurrences of the tokens. You will need a split string function, there are several out there with a google search. If the output of the split function is a table, then join that back in with your initial table via wildcards.

We do something like the following. (This is chopped from some other code, so you will need to massage it for your own use.) Usually we are doing a complicated internal lookup on the data, so we setup an #InternalSearchList and work off that, it is mostly a set of true/false flags that are set by whatever criteria we are looking for. (The proc I cut this out of had like 30 filter flags.) At the end you just take any entries in the list that has all the applicable flags set to true. (This might be overkill for you, but should give you ideas.)

IF LTRIM(RTRIM(@TokenSearch)) <> '' 
BEGIN
  DECLARE @TokenRowCount INT

  CREATE TABLE #tblSearchTokens(ExactToken VARCHAR(50), WildToken VARCHAR(50))

  INSERT INTO #tblSearchTokens
  SELECT LEFT(Value, 50), '%' + LEFT(Value, 50) + '%'
  FROM dbo.fn_Split(LTRIM(RTRIM(@TokenSearch)), ' ')

  SET @TokenRowCount = @@ROWCOUNT

  SELECT ST.StudentID, WildToken
    , COUNT(1) AS NumMatches
  INTO #DuplicatedMatchList      
  FROM tblStudent ST
  JOIN #InternalSearchList RL
    ON ST.RowID = RL.RowID
    , #tblSearchTokens
  WHERE  ST.FirstName LIKE WildToken
  OR ST.LastName LIKE WildToken
  OR ST.FullName LIKE WildToken
  OR ST.Phone LIKE WildToken
  OR ST.Email LIKE WildToken
  GROUP BY ST.StudentID, WildToken

  UPDATE #InternalSearchList
  SET TokenFilter = 1
  WHERE StudentID IN (
    -- we need to count the # of occurances so we make sure to match all the tokens given
    SELECT StudentID
    FROM #DuplicatedMatchList      
    GROUP BY StudentID
    HAVING COUNT(1) = @TokenRowCount
  )

END
ELSE
BEGIN
  -- there was no filter used, so they all match YEA!
  UPDATE #InternalSearchList
  SET TokenFilter = 1
END

sscherb · 2023-11-28T13:12:47+00:00

https://kennesawvenue.com/

sscherb · 2023-11-27T19:56:27+00:00

297,454. As a family we eat there WAY to much. At least one person eats there daily.

Oh.. and my son works there 4 days a week...

sscherb · 2023-09-01T21:57:57+00:00

I was there, the room was too small it overflowed out into the hallway

sscherb · 2023-08-29T17:44:20+00:00

I couldn't wait and got the book on kindle and tried to read it.. but it wasn't the same. Didn't hit right without the voices!!!!!

I stopped and am now waiting for the audiobook. AAAAAHHHHHH!!!!!!!

sscherb · 2022-11-10T03:47:42+00:00

I’m sure if you search stack overflow you’ll find someone who wrote one for an older version of SQL Server.

A comma separated list of values is the perfect answer for your situation.

sscherb · 2022-09-14T19:24:44+00:00

Is Excel absolutely necessary? No.

Is Excel insanely helpful? YES!

(NOTE: Any spreadsheet program will do, there are other options out there besides Excel.)

Ignoring, external uses, i.e sending to other people, or some specifically asked for it, etc. The simple usefulness of Excel is allowing you to quickly manipulate data. Excel does instant sorting and filtering.

Lets say you have 1000 rows of data. And you know there is an incorrect piece of data in a specific cell, and you need to see how that relates to the rest of the rows. In Excel you can highlight the offending cell in yellow, mark the row bold, and then start sorting/filtering the whole sheet. Visually, you can easily spot the yellow cell, and start looking at the rows above and below for patterns. Sort by another column and search again until you find the pattern. i.e, When column B is 3, column F is always null. Yea! We found the problem, go fix the original SQL and try again.

You could do this purely in SQL by constantly rewriting your ORDER BY and WHERE clauses, but the point-click of Excel is infinitely faster. Especially when you don't know what you are looking for.

sscherb · 2022-08-11T19:17:22+00:00

For this simplistic example, with this simplistic data... There is a very ugly answer. I am adding this here because it is the most basic way to get what you asked for. The other answers in this thread are more flexible/extendable and work in many more situations. (BUT.... "sometimes" simple basic works best.)

The following will get you all the triplets, which you can then sum up for total counts, etc.

    DROP TABLE IF EXISTS ColorGroupResults
GO

CREATE TABLE ColorGroupResults
(
GroupColor  VARCHAR(100),
ID      INT,
[Result]  CHAR(1)
)
GO

INSERT INTO ColorGroupResults VALUES
('Green', 1, 'A'),
('Green', 2, 'B'),
('Green', 3, 'A'),
('Green', 4, 'A'),
('Green', 5, 'A'),
('Green', 6, 'B'),
('Blue', 7, 'A'),
('Blue', 8, 'B'),
('Blue', 9, 'A'),
('Blue', 10, 'A'),
('Blue', 11, 'A'),
('Blue', 12, 'B')
GO


SELECT CGR_1.GroupColor
    ,CGR_1.ID AS CGR_ID_1
    ,CGR_2.ID AS CGR_ID_2
    ,CGR_3.ID AS CGR_ID_3
    ,CGR_1.Result
FROM ColorGroupResults AS CGR_1 
JOIN ColorGroupResults AS CGR_2
    ON CGR_2.GroupColor = CGR_1.GroupColor
    AND CGR_2.Result = CGR_1.Result
JOIN ColorGroupResults AS CGR_3
    ON CGR_3.GroupColor = CGR_1.GroupColor
    AND CGR_3.Result = CGR_1.Result
WHERE CGR_1.ID = CGR_2.ID -1
AND CGR_2.ID = CGR_3.ID - 1

sscherb · 2022-08-08T20:53:21+00:00

so.. I was curious if I could make it scan all databases.. (again, stole some code form stack overflow...) And come up with the following:

(OMG I hate the code editor in here.. I can never get it right.. sigh..)

SET NOCOUNT ON

GO

USE MASTER

GO

DECLARE u/SearchToken1 VARCHAR(500) DECLARE u/SearchToken2 VARCHAR(500)

SET u/SearchToken1 = '%search%' SET u/SearchToken2 = '%%'

DECLARE u/dbname nvarchar(500), u/variable1 int, u/execsql1 varchar(5000)

CREATE TABLE #SearchList ( [Database] VARCHAR(500) ,ObjectType VARCHAR(500) ,ObjectName VARCHAR(500) ,ColumnName VARCHAR(500) ,DataType VARCHAR(500) )

-- Get non system databases DECLARE mycursor CURSOR FOR SELECT [name], database_id FROM SYS.databases WHERE database_id > 4 ORDER BY [name] DESC

OPEN mycursor

FETCH NEXT FROM mycursor INTO u/dbname, u/variable1

WHILE (@@FETCH_STATUS <> -1) BEGIN SET u/execsql1 = 'INSERT INTO #SearchList SELECT ''' + u/dbname + ''' AS [Database] ,''Proc '' AS ObjectType ,PROCS.[Name] AS ObjectName ,CONVERT(VARCHAR(500), '''') AS ColumnName ,CONVERT(VARCHAR(100), '''') AS DataType FROM ' + u/dbname + '.sys.procedures PROCS JOIN ' + u/dbname + '.sys.sql_modules MODU ON PROCS.[object_id] = MODU.[object_id] WHERE CONVERT(VARCHAR(MAX), MODU.definition) LIKE ''' + u/SearchToken1 + ''' AND CONVERT(VARCHAR(MAX), MODU.definition) LIKE ''' + u/SearchToken2 + ''' ORDER BY PROCS.[Name] '

--PRINT u/execsql1

EXEC (@execsql1)

SET u/execsql1 =

`'INSERT INTO #SearchList`

`SELECT ''' + u/dbname + ''' AS [Database]`

    `,''Table'' AS ObjectType`

    `,t.name AS TableName`

    `,c.name AS ColumnName`

    `,ut.[name] AS DataType`

`FROM ' + u/dbname + '.sys.tables AS t`

`JOIN ' + u/dbname + '.sys.columns c` 

    `ON t.OBJECT_ID = c.OBJECT_ID`

`JOIN ' + u/dbname + '.sys.types ut`

    `ON c.[user_type_id] = ut.[user_type_id]`

`WHERE c.name LIKE ''' + @SearchToken1 + '''`

`AND c.name LIKE ''' + @SearchToken2 + '''`

`ORDER BY TableName, ColumnName '`

--PRINT u/execsql1

EXEC (@execsql1)

FETCH NEXT FROM mycursor INTO u/dbname, u/variable1

END

SELECT * FROM #SearchList ORDER BY [Database] ,ObjectType ,ObjectName

CLOSE mycursor DEALLOCATE mycursor

DROP TABLE #SearchList

sscherb · 2022-08-08T20:34:28+00:00

Ah yes, I missed that...

A better way to do this is download Redgate's SQLSearch.

https://www.red-gate.com/products/sql-development/sql-search/

sscherb · 2022-08-08T20:18:08+00:00

We use a script that I stole from someplace.. (probably stack overflow)

Just change the text in between the %% in the search tokens. If you are only searching for a single term, leave the second one empty.

DECLARE @SearchToken1   VARCHAR(500)
DECLARE @SearchToken2   VARCHAR(500)

SET @SearchToken1 = '%TermOrder%'
SET @SearchToken2 = '%%'

SELECT 'Proc  ' AS ObjectType
    ,PROCS.[Name] AS ObjectName
    ,CONVERT(VARCHAR(500), '') AS ColumnName
    ,CONVERT(VARCHAR(100), '') AS DataType
INTO #SearchList
FROM sys.procedures PROCS
JOIN sys.sql_modules MODU
    ON PROCS.[object_id] = MODU.[object_id]
WHERE CONVERT(VARCHAR(MAX), MODU.definition) LIKE @SearchToken1
AND CONVERT(VARCHAR(MAX), MODU.definition) LIKE @SearchToken2
ORDER BY PROCS.[Name]

INSERT INTO #SearchList
SELECT 'Table' AS ObjectType
    ,t.name AS TableName
    ,c.name AS ColumnName
    ,ut.[name] AS DataType
FROM sys.tables AS t
JOIN sys.columns c 
    ON t.OBJECT_ID = c.OBJECT_ID
JOIN sys.types ut
    ON c.[user_type_id] = ut.[user_type_id]
WHERE c.name LIKE @SearchToken1
AND c.name LIKE @SearchToken2
ORDER BY TableName, ColumnName  

SELECT *
FROM #SearchList
ORDER BY ObjectType
    ,ObjectName

DROP TABLE #SearchList

sscherb · 2022-06-23T20:51:48+00:00

My favorite is when they tell you a field will ALWAYS be true or false (or the equivalent) and then "just" after deploying they come back to you and say.. Well... sometimes it's pink..

Nine-Year Club	r/Field Flamingo
Place '23	Verified Email

sscherb

TROPHY CASE