text:
Q: Cannot query cache by affinity key when custom cache template is used I noticed that when I query a cache which was created with a custom cache template and include the cache's affinity key in the WHERE clause, no results are returned.
I am running Ignite 2.5 with the following configuration:
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="
   http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans.xsd">
<bean id="grid.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
  <property name="cacheConfiguration">
    <list>
      <bean id="cache-template-bean" abstract="true" class="org.apache.ignite.configuration.CacheConfiguration">
          <property name="name" value="myCacheTemplate*"/>
          <property name="cacheMode" value="PARTITIONED" />
      </bean>
    </list>
  </property>
</bean>

And here is my test code. The code creates 3 caches. The first one is a "root" cache which defines colocation for the others. The other two are caches colocated by the root's key. The first colocated cache (colocated_default) uses the PARTITIONED template and works as expected. The second (colocated_custom) uses the "myCacheTemplate" created in the above configuration. I insert one cache entry into each cache, where the entries in the colocated cache have an affinity key equal to the root cache entry's key.
I then query the caches. I first run a query to ensure there is one entry in each cache. Then I run a query for each key WHERE the affinity key is equal to affinity key of the record inserted. The results for me show that I am able to select from by affinity from both of the PARTITIONED caches, but get no results for the "colocated_custom" cache. Here is the code:
/**
 * Test which shows that creating a cache with a custom cache configuration template doesn't allow
 * for SQL queries to use an affinity key in the WHERE clause.
 */
public class App {

   public static void main(String[] args) {
      // Start Ignite.
      Ignition.setClientMode(true);
      final Ignite ignite = Ignition.start(new IgniteConfiguration());

      // Create caches. Create a root entity, and two entities which are colocated by the root's ID.
      // One uses the custom cache template and one just uses the PARTITIONED template.
      final List<StringBuilder> createTableStringBuilders = new ArrayList<>();

      final StringBuilder createRoot = new StringBuilder();
      createRoot.append("CREATE TABLE IF NOT EXISTS root (\n");
      createRoot.append("  \"key\" VARCHAR(24) NOT NULL,\n");
      createRoot.append("  \"data\" VARCHAR(100),\n");
      createRoot.append("  PRIMARY KEY(\"key\"))\n");
      createRoot.append(
         "WITH \"template=PARTITIONED, affinity_key=key, cache_name=root, value_type=root\";");
      createTableStringBuilders.add(createRoot);

      final StringBuilder createColocatedDefault = new StringBuilder();
      createColocatedDefault.append("CREATE TABLE IF NOT EXISTS colocated_default (\n");
      createColocatedDefault.append("  \"root_key\" VARCHAR(24) NOT NULL,\n");
      createColocatedDefault.append("  \"key\" VARCHAR(24) NOT NULL,\n");
      createColocatedDefault.append("  \"data\" VARCHAR(100),\n");
      createColocatedDefault.append("  PRIMARY KEY(\"root_key\", \"key\"))\n");
      createColocatedDefault.append(
         "WITH \"template=PARTITIONED, affinity_key=root_key, cache_name=colocated_default, key_type=colocated_default_key, value_type=colocated_default\";");
      createTableStringBuilders.add(createColocatedDefault);

      final StringBuilder createColocatedCustom = new StringBuilder();
      createColocatedCustom.append("CREATE TABLE IF NOT EXISTS colocated_custom (\n");
      createColocatedCustom.append("  \"root_key\" VARCHAR(24) NOT NULL,\n");
      createColocatedCustom.append("  \"key\" VARCHAR(24) NOT NULL,\n");
      createColocatedCustom.append("  \"data\" VARCHAR(100),\n");
      createColocatedCustom.append("  PRIMARY KEY(\"root_key\", \"key\"))\n");
      createColocatedCustom.append(
         "WITH \"template=myCacheTemplate, affinity_key=root_key, cache_name=colocated_custom, key_type=colocated_custom_key, value_type=colocated_custom\";");
      createTableStringBuilders.add(createColocatedCustom);

      try (Connection connection =
         DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10800"))
      {
         for (final StringBuilder createTableStringBuilder : createTableStringBuilders) {
            try (PreparedStatement createTableStatement =
               connection.prepareStatement(createTableStringBuilder.toString()))
            {
               System.out.println(createTableStringBuilder.toString());
               createTableStatement.execute();
               System.out.println();
            }
         }
      }
      catch (final SQLException e) {
         throw new AssertionError(e);
      }

      // Create the root entity.
      final BinaryObject root1 = ignite.binary().builder("root")
         .setField("key", "1")
         .setField("data", "Data for 1")
         .build();

      System.out.println("Inserting into \"root\": [\"1\", " + root1 + "]");
      ignite.cache("root").withKeepBinary().put("1", root1);

      // Create the colocated entity which uses the PARTITIONED template.
      final BinaryObject colocatedDefault1 = ignite.binary().builder("colocated_default")
         .setField("root_key", "1")
         .setField("key", "2")
         .build();

      final BinaryObject colocatedDefault1Key = ignite.binary().builder("colocated_default_key")
         .setField("root_key", "1")
         .setField("key", "2")
         .build();

      System.out.println("Inserting into \"colocated_default\": [" + colocatedDefault1Key + ", " +
         colocatedDefault1 + "]");
      ignite.cache("colocated_default").withKeepBinary().put(colocatedDefault1Key,
         colocatedDefault1);

      // Create the colocated entity which uses the custom template.
      final BinaryObject colocatedCustom1 = ignite.binary().builder("colocated_custom")
         .setField("root_key", "1")
         .setField("key", "3")
         .build();

      final BinaryObject colocatedCustom1Key = ignite.binary().builder("colocated_custom_key")
         .setField("root_key", "1")
         .setField("key", "3")
         .build();

      System.out.println("Inserting into \"colocated_custom\": [" + colocatedCustom1Key + ", " +
         colocatedCustom1 + "]");
      ignite.cache("colocated_custom").withKeepBinary().put(colocatedCustom1Key,
         colocatedCustom1);

      // SELECT COUNT(*) on all caches to ensure data exists.
      System.out.println();
      final List<String> selectAllStrings = new ArrayList<>();
      selectAllStrings.add("SELECT COUNT(*) FROM root;");
      selectAllStrings.add("SELECT COUNT(*) FROM colocated_default;");
      selectAllStrings.add("SELECT COUNT(*) FROM colocated_custom;");

      try (Connection connection =
         DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10800"))
      {
         for (final String selectAllString : selectAllStrings) {
            try (PreparedStatement selectAllStatement =
               connection.prepareStatement(selectAllString))
            {
               System.out.println(selectAllString);
               selectAllStatement.execute();

               final ResultSet resultSet = selectAllStatement.getResultSet();
               resultSet.next();
               System.out.println(resultSet.getInt(1));
               System.out.println();
            }
         }
      }
      catch (final SQLException e) {
         throw new AssertionError(e);
      }

      // SELECT COUNT(*) with affinity key in WHERE clause.
      final List<String> selectWhereStrings = new ArrayList<>();

      // Returns 1.
      selectWhereStrings.add("SELECT COUNT(*) FROM root WHERE \"key\" = '1';");

      // Returns 1.
      selectWhereStrings.add("SELECT COUNT(*) FROM colocated_default WHERE \"root_key\" = '1';");

      // Returns 0.
      selectWhereStrings.add("SELECT COUNT(*) FROM colocated_custom WHERE \"root_key\" = '1';");

      try (Connection connection =
         DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1:10800"))
      {
         for (final String selectWhereString : selectWhereStrings) {
            try (PreparedStatement selectWhereStatement =
               connection.prepareStatement(selectWhereString))
            {
               System.out.println(selectWhereString);
               selectWhereStatement.execute();

               final ResultSet resultSet = selectWhereStatement.getResultSet();
               resultSet.next();
               System.out.println(resultSet.getInt(1));
               System.out.println();
            }
         }
      }
      catch (final SQLException e) {
         throw new AssertionError(e);
      }
   }
}

And here is the output:
...Ignite startup logs...
[10:28:05] Ignite node started OK (id=7393583b)
[10:28:05] Topology snapshot [ver=8, servers=1, clients=1, CPUs=8, offheap=3.2GB, heap=8.1GB]
[10:28:05]   ^-- Node [id=7393583B-90FB-4D04-8D51-595F7C4DD4B6, clusterState=ACTIVE]
CREATE TABLE IF NOT EXISTS root (
  "key" VARCHAR(24) NOT NULL,
  "data" VARCHAR(100),
  PRIMARY KEY("key"))
WITH "template=PARTITIONED, affinity_key=key, cache_name=root, value_type=root";

CREATE TABLE IF NOT EXISTS colocated_default (
  "root_key" VARCHAR(24) NOT NULL,
  "key" VARCHAR(24) NOT NULL,
  "data" VARCHAR(100),
  PRIMARY KEY("root_key", "key"))
WITH "template=PARTITIONED, affinity_key=root_key, cache_name=colocated_default, key_type=colocated_default_key, value_type=colocated_default";

CREATE TABLE IF NOT EXISTS colocated_custom (
  "root_key" VARCHAR(24) NOT NULL,
  "key" VARCHAR(24) NOT NULL,
  "data" VARCHAR(100),
  PRIMARY KEY("root_key", "key"))
WITH "template=myCacheTemplate, affinity_key=root_key, cache_name=colocated_custom, key_type=colocated_custom_key, value_type=colocated_custom";

Inserting into "root": ["1", root [idHash=362827515, hash=1928708473, data=Data for 1, key=1]]
Inserting into "colocated_default": [colocated_default_key [idHash=44559647, hash=-132016556, root_key=1, key=2], colocated_default [idHash=1067599825, hash=-132016556, root_key=1, key=2]]
Inserting into "colocated_custom": [colocated_custom_key [idHash=1336001042, hash=-132016555, root_key=1, key=3], colocated_custom [idHash=1856158867, hash=-132016555, root_key=1, key=3]]

SELECT COUNT(*) FROM root;
1

SELECT COUNT(*) FROM colocated_default;
1

SELECT COUNT(*) FROM colocated_custom;
1

SELECT COUNT(*) FROM root WHERE "key" = '1';
1

SELECT COUNT(*) FROM colocated_default WHERE "root_key" = '1';
1

SELECT COUNT(*) FROM colocated_custom WHERE "root_key" = '1';
0

I would like to know if this is a misconfiguration on my part, or a bug in Ignite.

A: Apparently, it's a bug in Ignite. Filed https://issues.apache.org/jira/browse/IGNITE-9964. Thanks for reporting!
The issue only appears when you put data via withKeepBinary(). If you use SQL INSERT instead, SELECT works fine.
I suggest you use INSERT instead of constructing BinaryObjects manually - it's much easier and allows to workaround the bug. If you have to use BinaryObjects then you can try added the first row via INSERT and use binary afterwards - this also worked in my tests.


This is our signature minio box, designed to help you collect and preserve life's mini moments. It makes a perfect gift for friends and family to express just how meaningful the times you have shared together have been. Give a minio box filled with keepsake memories for the holidays, at a milestone birthday, family reunions, thanksgiving, mother's day, father's day, valentine's day - or to see someone through a challenging time. The experiences we share are what makes life so special – minio is a perfect way to keep those memories close to your heart.
2. Customize color - choose between five different color schemes for your divider cards. You can select just the right fit for the look of an event, the type of special occasion or just the colors that best fit the person receiving it. Each theme has a different colors on the front and back to give you even more options.


ASTANA. August 21. KAZINFORM. Regular sitting of the State Commission for Economy Modernization chaired by Prime Minister of Kazakhstan Karim Massimov has taken place in the format of telephone conference in Ukimet Uyi today; Kazinform refers to the PM's press service. Heads of the state bodies, "SamrukKazyna" National Welfare Fund, "KazAgro" Holding, national companies, development institutes, regional akimats and initiators of investment projects within the framework of Program of Forced Industrial Innovative Development of Kazakhstan took part in the sitting. They discussed the proposal of KazAgro Holding on purchase of grain from local producers. Food Corporation will purchase 3 million tons of grain crop of 2009 in the domestic market. The purchase price is 24 750 tenge per ton. Fixing of such price will allow agricultural producers to keep level of income and ensure stable price situation in the domestic market.


text:
/* @flow */

// stepper is used a lot. Saves allocation to return the same array wrapper.
// This is fine and danger-free against mutations because the callsite
// immediately destructures it and gets the numbers inside without passing the
// array reference around.
let reusedTuple: [number, number] = [0, 0];
export default function stepper(
  secondPerFrame: number,
  x: number,
  v: number,
  destX: number,
  k: number,
  b: number,
  precision: number): [number, number] {
  // Spring stiffness, in kg / s^2

  // for animations, destX is really spring length (spring at rest). initial
  // position is considered as the stretched/compressed position of a spring
  const Fspring = -k * (x - destX);

  // Damping, in kg / s
  const Fdamper = -b * v;

  // usually we put mass here, but for animation purposes, specifying mass is a
  // bit redundant. you could simply adjust k and b accordingly
  // let a = (Fspring + Fdamper) / mass;
  const a = Fspring + Fdamper;

  const newV = v + a * secondPerFrame;
  const newX = x + newV * secondPerFrame;

  if (Math.abs(newV) < precision && Math.abs(newX - destX) < precision) {
    reusedTuple[0] = destX;
    reusedTuple[1] = 0;
    return reusedTuple;
  }

  reusedTuple[0] = newX;
  reusedTuple[1] = newV;
  return reusedTuple;
}

redpajama_set_name: RedPajamaGithub


The "Morning Exercise" began with Thomas Case, minister of Mary Magdalene Church on Milk Street, London. He responded to a need for prayer when during the first civil war many were concerned about family and friends serving in harm's way.
1660. The first volume was published by Thomas Case: The Morning Exercise Methodized: or, Certain Chief Heads and Points of the Christian Religion Opened and Improved in Divers Sermons, by Several Ministers of the City of London, in the Monthly Course of the Morning Exercise at Giles in the Fields, May 1659. London, Printed by E. M. for Ralph Smith, at the sign of the Bible in Cornhil, near the Royal Exchange. 1660.
"That since the preaching of these Sermons, there hath been no general review; but every one took care of transcribing his own discourse, and sending me the copy: accordingly I sent it to the press."
The fruits of the Morning Exercise in the city.
Truly God hath been pleased to make this Morning Lecture a great mercy to this city, ever since it was first erected; which was, when Leicester was besieged. It hath been like the ark in the house of Obed-edom, a blessing wherever it hath come, a morning cloud which hath let fall sweet, refreshing showers in every place.
Comfort against fear. For the strengthening of the weak hands, and confirming the feeble knees, of the people of God. (Isai. xxxv. 3, 4.)—Who in this time of England's troubles have been of a fearful heart and of a trembling spirit. Many poor Christians, who in times of public dangers and confusions have come to these morning-assemblies, like the Marys to the sepulchre of our Lord, with their hearts full of fears and their eyes full of tears, have been dismissed those assemblies "with fear and great joy;" (Matt. xxviii. 8;) their hearts have been revived, and their hands strengthened in the Lord their God.
A preservative against apostasy. God hath made use of this Exercise for the preserving of thousands from error and damnable doctrines in these times of sad apostasy.—While many ignorant and unstable souls, being "led away with the error of the wicked, have fallen from their own steadfastness," (2 Peter iii. 17,) there want not multitudes, through grace, who are ready to acknowledge that they owe their confirmation and stability in the truth, (under God,) in a very eminent manner, to the labours of those godly, orthodox divines who have bestowed their pains in these early Lectures from time to time.
Conversion. God hath commanded his blessing upon it for the conversion of many souls to Jesus Christ.—Blessed be God! "the Morning Exercise" hath not been childless since it was set up. Some there be, to my knowledge, who have calculated their spiritual nativity from the time that this Exercise was in the places of their habitation; as in this Place some can bring-in their testimony to the honour and praise of free-grace.
Partly, by reason of the frequency and assiduity of them. Sabbath day-sermons and weekly lectures, being distanced with such long intervals of worldly encumbrances, are for the most part forgotten before the return of their weekly course: whereas, these Exercises treading so close upon the heels one of another, they that have constantly attended them have, as it were, lived under a constant vision, the sun of the gospel arising upon them as assiduously as the sun in the firmament; whereby they have been carried on in a daily progress of gospel-proficiency.
1661. The second volume was edited by Samuel Annesley. The Morning-Exercise at Cripple-gate: or, Several Cases of Conscience Practically Resolved, by Sundry Ministers, September, 1661. London: Printed for Joshua Kirton and Nathaniel Webb, and are to be sold at the Kings Arms, and at the Royal Oak in St. Paul's church-yard, 1661.
1674. Samuel Annesley. A Supplement to the Morning-Exercise at Cripple-gate: or Several more Cases of Conscience Practically Resolved by Sundry Ministers. London, Printed for Thomas Cockerill, at the Sign of the Atlas in Cornhil, near the Royal Exchange, 1674.
1675. Nathaniel Vincent. The Morning-Exercise against Popery: or the Principal Errors of the Church of Rome detected and confuted, in a Morning-Lecture preached lately in Southwark: by Several Ministers of the Gospel in or near London. London, Printed by A. Maxwell for Tho: Parkhurst, at the Bible and three Crowns in Cheapside near Mercers-Chappel, and at the Bible within the Gate on London-Bridge. 1675.
1683. Samuel Annesley. A Continuation of Morning-Exercise Questions and Cases of Conscience, Practically Resolved by Sundry Ministers, in October 1682. London, Printed by J.A. for John Dunton, 1683.
1690. Samuel Annesley. Casuistical Morning-Exercises. The Fourth Volume. By Several Ministers in and about London, Preached in October, 1689. London, Printed by James Astwwod for John Dunton, at the Raven in the Poultrey, over against the Compter. 1690.
The series was republished with reorganized volumes, carefully collated and corrected, with notes and translations, by James Nichols. London: Printed for Thomas Tegg, 73, Cheapside, 1844 and 1845.
Volume 1. The Morning Exercises at Cripplegate, St. Giles in the Fields, and in Southwark: Being Divers Sermons, Preached A.D. 1659–1689. By Several Ministers of the Gospel in or near London. In Six Volumes. 1844 (Contains the 1661 volume - Several Cases of Conscience, etc, sermons 1–28; and part of the 1674 volume, A Supplement to the Morning-Exercise at Cripple-gate, etc. sermons 1–4).
Volume 2. The Morning Exercises at Cripplegate, etc. (Contains the remainder of the 1674 volume, A Supplement to the Morning-Exercise at Cripple-gate, etc. sermons 5–31).
Volume 3. The Morning Exercises at Cripplegate, etc. (Contains the 1683 volume, A Continuation of Morning-Exercise Questions etc., sermons 1–25).
Volume 4. The Morning Exercises at Cripplegate, etc. (Contains the remainder of the 1683 volume, sermons 26–31), and also the Casuistical Morning-Exercises. sermons 1–18).
Volume 5. The Morning Exercises at Cripplegate, etc. (Contains the 1660 volume, The Morning Exercise Methodized, etc., sermons 1–28) and also the 1675, The Morning-Exercise against Popery, etc, sermons 1–6).
Volume 6. The Morning Exercises at Cripplegate, etc. (Contains the remainder of the 1675 The Morning-Exercise against Popery, etc, sermons 7–25). Also contains the indexes of authors, Scriptures, topics, and authors cited.


text:
Yosra T. Karoui
Peace Building - Preventing Violent Extremism
Program Intern - Search for Common Ground
Project Assistant - Jasmine Foundation for Research and Communication
Master's degree in Translation Studies
Yosra is a young and motivated Tunisian who studied English literature, civilization, and linguistics, and then went on to pursue her master's degree in translation. She is passionate about learning new languages, acquiring new skills, and being more engaged in civil society.
She started to discover civil society in Tunisia when she joined Junior Chamber International (JCI). Since then, she has been involved in several initiatives on peace building, humanitarian ties, and youth.
As a Lazord Fellow, she was placed at Search for Common Ground Tunisia where she worked simultaneously on two projects under the big theme of peace building. The fellowship year allowed her to acquire more skills and be more engaged and ambitious.
Yosra has fully benefited from the Lazord Fellowship experience, which is a step forward in civil society in her country – a step that keeps broadening the sphere of her ambitions.

redpajama_set_name: RedPajamaCommonCrawl


text:
Paul Maged – Taking The Time To Put Out A Full In Your Face Record
In today's "give it to me now" society with no attention span it is rare for a musician to take his time releasing a follow up album. This quick rush has been the downfall of many a career when a rushed product is markedly inferior to the record that preceded it and a budding career is dead in its tracks. Our latest find Paul Maged has taken his time to put the most he can into his sophomore effort.
The passing of his father at a young age pushed Paul Maged into songwriting as it helped him deal with a rather tough time. These songs became his first album, In My Time. The pop-rock album with a raw garage feel caught some attention and even had the single "Falling Down" featured on MTV programming. Paul was willing to put in the hard work to secure a professional music career and in turn studied music at the Boston Conservatory and American Musical & Dramatic Academy in New York. He describes himself as a singer/songwriter but is much more than that. He is an alternative rock artist that brings in punk, grunge, classic rock, indie pop and a dramatic flair to his sound that makes it stand out.
The latest release from Paul Maged has been in the works since 2011. The passion has become the 17 track album Diamonds & Demons. Right from the opener "Look At Me" you know you are listening to a real artist that is not afraid to tackle the tough subjects and speak his mind. Enjoy the video here:
Paul shows some diversity with "Images" which has tastes of an Elvis Costello influence while staying powerful and meaningful. The title track "Diamonds & Demons" is the most in your face rock track of the record. It creeps up and pounds you into submission, and you will be humming the chorus for days. The mellow and aptly titled "Somber Song" gives another example of a man who will pour his heart and emotions into a song. There are a few misses that sound a little too reached but overall this is a very entertaining record that deserves a full listen. Go get a taste of Paul Maged at: www.paulmaged.com
Dr. Dance - A Lifelong Dream Fulfilled To Dance Away... Previous
Michael Wien - Knows Music Is A Serious Business Next


Note: You can enter this giveaway three (3) times per e-mail address per day. Deadline is 11:59PM ET 9.18.18.
If you've ever wished you had extra help in the kitchen for all those prep jobs, the Cuisinart Pro Classic 7-Cup Food Processor has got your back. This machine can help you make all your favorites from Ginger and Carrot Stir-Fry and salads, to Homemade Peanut Butter and bread. The 7-cup work bowl can accommodate all your needs and the extra-large feed tube holds whole fruits and vegetables – no extra slicing and dicing needed. A stainless-steel medium slicing disc, stainless-steel shredding disc, chopping blade, small and large pushers, detachable disc stem, compact flat cover, spatula, and instruction/recipe book are also included. This processor may be the best sous chef ever.
NO PURCHASE NECESSARY TO ENTER OR WIN. Void where prohibited by law. Open to legal residents of the 50 U.S., D.C. and Canada (excluding Quebec) who are at least eighteen years old at the time of entry and have internet access. Begins on 7.23.18 at 12:00:00 a.m. ET and ends on 9.18.18 at 11:59:59 p.m. ET. To enter the giveaway, submit your full name and email address on this form. Odds of winning this giveaway depend on the total number of eligible entries received. Only three (3) entries per email address per day. Sponsored by Leite's Culinaria, Inc. For more information, visit our Official Rules. For a list of winners, check out our Very Happy Winners page. Be sure to add giveaways@leitesculinaria.com to ensure notification if you are the winner.


text:
West High School Foundation
We support West High School in Anchorage, Alaska
Media Toolbox
If you're familiar with the West High Alumni Association and the West High PTSA, you're probably wondering about the need for a West High Foundation.
The simple answer is that the West High Foundation provides an opportunity to support large projects and programs for West High, many of which are difficult or out of reach for the PTSA and Alumni Association. The WHS Foundation provides a non-profit conduit for private, corporate, and governmental grants that will directly endow projects and programs to benefit West High over the long term.
For many years, thousands of alumni, parents, teachers, neighbors and Alaskans from across our state have shared and enjoyed West's outstanding academic, performing arts and sports programs and venues. West High has been – from the very beginning – a true center where, as a community, we gather to celebrate and elevate the very best of our diverse talents, skills, cultures and spirits.
The West High Foundation was created on behalf of the many alumni, teachers, parents, neighbors, businesses and, most of all, students who want to strengthen and continue this tradition. By supporting, volunteering and/or donating to the West High Foundation, you will help ensure that West High's commitment to the highest standards of academic achievement, high school sports, extracurricular activities, and community involvement will continue well into the future.
Be a part of the West High Community. Donate today!
We are – West High. We are…


text:
Jeff Sessions Will Recuse Himself In Russian Matters
Attorney General Jeff Sessions indicated in a press conference this afternoon that he will recuse himself in any investigation over Russian interference in the 2016 US Presidential elections, just hours after top Republicans said he should do just that. House Oversight and Government Reform Committee Chairman Jason Chaffetz, R-Utah, tweeted early Thursday that "AG Sessions should clarify his testimony and recuse himself." Later, Sen. Rob Portman, R-Ohio, said in a statement, "Jeff Sessions is a former colleague and a friend, but I think it would be best for him and for the country to recuse himself from the DOJ Russia probe." House Majority Leader Kevin McCarthy, R-Calif., also initially said during an appearance on MSNBC's "Morning Joe" that Sessions should bow out. The comments from prominent Republicans follow revelations that Sessions met with the Russian ambassador during election season. Under oath in front of the Senate Judiciary Committee for his confirmation hearing in January, Sessions had said that he had not met with any Russian officials.
Senators from eight states that have legalized the recreational or medicinal use of marijuana are asking Attorney General Jeff Sessions to uphold the Department of Justice's existing enforcement policy toward states with voter-approved marijuana laws. Massachusetts Democratic Sens. Elizabeth Warren and Edward Markey were among those who signed the Thursday letter. Massachusetts voters backed the recreational use of pot last year. The senators point to comments by White House spokesman Sean Spicer suggesting stepped-up enforcement of federal laws against recreational marijuana. Signatories also include Senators Michael Bennet, Colorado; Brian Schatz, Hawaii; Catherine Cortez Mastro, Nevada; Cory Booker, New Jersey; Ron Wyden and Jeff Merkley, Oregon; Patty Murray and Maria Cantwell, Washington; and the lone Republican Senator, Lisa Murkowski of Alaska.
Colorado is moving ahead with a first-in-the-nation attempt to allow marijuana clubs. But the measure that passed a Republican State Senate committee Wednesday evening doesn't go as far as some marijuana activists hoped. The bill would allow on-site marijuana consumption at private clubs in willing jurisdictions. And those clubs may allow indoor pot smoking, despite health concerns about indoor smoking. But the bill is far from allowing a statewide network of pot clubs. For one, it would allow any jurisdiction to ban them, same as they can currently prohibit retail pot sales. Also, the bill does not permit pot clubs to serve alcohol nor food.
More than 80 percent of Danes are in favour of legalising the medical use of cannabis, a new survey has found, increasing the chance that a pilot scheme planned for next year will lead to an end to prohibition. The survey by Analyse Denmark found that only five percent of people in Denmark opposed medical cannabis, with the remainder saying they did not have an opinion. Denmark plans from January 1 next year to launch a four-year trial which will allow "a defined patient group" to be treated with medical cannabis, after an agreement was reached in the Danish Parliament last November. The Danish Medicine Authority (Lægemiddelstyrelsen) has put forward multiple sclerosis, chronic pain, spinal cord injuries and chemotherapy-induced nausea and vomiting as eligible ailments.
Peruvian President Pedro Pablo Kuczynski has proposed legalizing medical marijuana in the latest pivot away from decades-old restrictions on drug use in Latin America. It is unclear if the right-wing opposition-controlled Congress will pass Kuczynski's proposed legislation, which would allow marijuana to be imported and sold in Peru for medical reasons and could permit domestic production after two years. An Ipsos poll showed 65 percent of Peruvians favor legalizing medical marijuana, and another 13 percent back legalizing the drug for recreational use. If the bill is passed, Peru would follow neighboring Chile and Colombia in legalizing the medical use of marijuana. Mexico's Senate has approved a bill to permit the use of medical marijuana, while Uruguay has fully legalized cannabis from seed to smoke.
A 119-year-old international organization that develops voluntary standards for items ranging from children's toys to commercial spaceflight could soon do the same for cannabis operations. ASTM International on Tuesday launched a volunteer committee on cannabis to discuss and develop standards in areas such as personnel training, cultivation and security, officials and committee members told The Cannabist. The committee was formed following an all-day meeting and vote of 60 stakeholders — representatives from inside and outside the cannabis industry — who gathered at ASTM's headquarters in West Conshohocken, Pa.


This project involved a single storey addition adjacent to the roof-garden of Parliament House, directly above the Jubilee Room of the original 'Rum Hospital'. The aim of the project was to activate the existing lush gardens, while providing much-needed additional office accommodation and meeting rooms for parliamentary staff.
The existing lifts and stairs have been continued upwards from the floors below for access and egress. The requisite bathroom and kitchen facilities were augmented by exterior terrace areas with a BBQ located under a new garden pergola to the south end of the garden.


text:
The Lyle H. Fulton Memorial Bridge is a steel plate girder bridge in Nashville, Tennessee that carries Interstate 65 across the Cumberland River. Between the bridge's completion in 1971 and 2000, the route that the bridge carries was designated as Interstate 265, until I-65 was rerouted onto the bridge, replacing that route.

Description
The Lyle H. Fulton Memorial Bridge carries I-65 across the Cumberland River about  north of downtown Nashville. The segment of I-65 that the bridge is located on is part of a loop of interstate highways that completely encircle downtown Nashville, known locally as the Downtown Loop. The bridge carries six lanes, separated by a jersey barrier, and has no shoulders, unlike the nearby Silliman Evans Bridge on I-24. Directly east of the bridge I-65 splits off into a concurrency with I-24, with the lanes on I-65 splitting off into this interchange less than  beyond the eastern end of the bridge. While I-65 is a north-south route, the bridge is almost directly aligned in an east to west direction. West of the bridge, I-65 gradually curves to the south. In addition to the Cumberland River, the bridge also crosses the Cumberland River Greenway at its western end and a surface street at its eastern end.

History
Work began on the bridge in June 1967. On March 15, 1971 the bridge was opened to traffic, along with the entirety of I-265 to the southwest and a short segment of I-40 west of downtown Nashville. Construction of the bridge cost $2,645,508 (equivalent to $ in ). The bridge was officially dedicated on July 9, 1971 in a ceremony officiated by then-governor Winfield Dunn which partially closed the bridge to traffic. It was named in honor of a state politician who died in 1954 from liver cancer at the age of 31 shortly after receiving the Democratic nomination for state senate. As a result, his brother Richard was elected in his place.

In an effort to relieve traffic congestion on I-24 east of downtown Nashville, I-65 was rerouted from a concurrency with that route to the western freeway loop around downtown Nashville in May 2000, replacing I-265.

References

Bridges completed in 1971
Transportation in Nashville, Tennessee
Bridges on the Interstate Highway System
Interstate 65
Bridges over the Cumberland River
Road bridges in Tennessee
1971 establishments in Tennessee

redpajama_set_name: RedPajamaWikipedia


Complete Taipan II kitset to suit a motorcycle motor. Kit does not include a motor or motor mounts. Includes chassis parts (requires fabrication), all other parts welded. All brakes, steering, pedals, seat, seat slides, harness, floor pan, wheels & tyres. Just requires motor, motor installation, chassis fabrication, painting and assembly.


text:
1st October: President Zeman, 53 Enjoys Mark Nigeria's Independence In The Czech Republic- Amb Kevin
By Editor / October 3, 2021
Nigeria independence was marked in grand style by the Czech Republic President, Milos Zeman The Nigerian Ambassador to the Czech…
Nigeria independence was marked in grand style by the Czech Republic President, Milos Zeman
The Nigerian Ambassador to the Czech Republic, His Excellency Kevin Peter told our correspondent that the 1st October was well marked and attended to by his country home of stay.
Milos was represented by Ambassador Rudolf Jinderek, Adviser to the Czech Republic President on international affairs.
According to him in other to further tie the bilateral knots well between Nigeria and the Czech Republic the independence day was attended by high-profile personalities.
He said Representatives of the Czech Ministry of foreign affairs having the Director Diplomatic Protocol, Dr. Marketa and her team, the Director Sub Sahara Africa, Mrs. Nicol, and her team, Prof Peter konvanlinka, president, Technological Agency of Czech Republic, A team from the Czech Republic Ministry of defense honored Nigeria and mark its independence day.
Kevin revealed that other prominent Nigerians living in the Czech Republic, Business tycoons, companies/individuals in all areas of endeavors seeking partnership with Nigeria were also in attendance.
Peter while sending them greetings from President Muhammadu Buhari on this unique day in the history of the country he said:
"Interestingly 53 Ambassadors accredited to the Czech Republic were in attendance to celebrate our dear nation. I reminded everyone in attendance that Nigeria is a country endowed with a lot of human and natural resources that are potentially waiting for any interested party to visit the country for good purposes.
" The country under the leadership of President Muhammadu Buhari is doing well in the area of peaceful coexistence and creating an enabling environment for international companies, partners, and individuals to invest."
Representative of President, Rudolf in his remarks emphasized that Nigeria is one of the strong countries in Africa, and her relationship with the Czech Republic is never taken lightly


text:
Q: getting sum from two diffrent tables sql i have two tables with names stock_in and stock_out with following colums
stock_in (recid,itemid,units)

stock_out (recid,itemid,units)

what i want is to get sum of units from both tables and then calculate remaining units from stock_in to stock_out where i can specify the itemid for any item
Thanks

A: SELECT
  (SELECT SUM(units) FROM stock_in WHERE itemid = 7) -
  (SELECT SUM(units) FROM stock_out WHERE itemid = 7)
  AS difference;

A: select
    stock_in.itemid,
    sum_stock_in.sum as sum_in,
    sum_stock_in.sum as sum_out
from
    stock_in
    left join (
        select itemid, sum(units) as sum from stock_in group by itemid
    ) as sum_stock_in on sum_stock_in.itemid = stock_in.itemid
    left join (
        select itemid, sum(units) as sum from stock_out group by itemid
    ) as sum_stock_out on sum_stock_out.itemid = stock_in.itemid
where
    stock_in.itemid in (1, 2, 3)

-- edit:
group by
    stock_in.itemid

In this query, it is assumed that stock_out is a subset of stock_in, i.e., stock_in contains every possible itemid.

A: Make a stored procedure out of it
SELECT @SUM1=SUM(*)
FROM STOCK_IN
SELECT @SUM2=SUM(*)
FROM STOCK_OUT

SELECT @SUM1-@SUM2

Thats the best solution I can think of, the one mentioned by Dan is not working since using two from, the actual work done is inner join

A: Since this is under PHP:
$queryString = "SELECT
  SUM(stock_in.units) - SUM(stock_out.units) as difference
FROM
  stock_in
INNER JOIN stock_out
ON stock_in.itemid=stock_out.itemid
WHERE stock_in.itemid = ".$value_to_query;
$result = mysql_query($queryString);

Tests:
create database sumgetter;
use sumgetter;
CREATE TABLE stock_in (
         recid INT,
         itemid INT,
         units INT
);
CREATE TABLE stock_out (
         recid INT,
         itemid INT,
         units INT
);
INSERT INTO stock_in VALUES (1, 1, 2);
INSERT INTO stock_out VALUES (1, 1, 3);
INSERT INTO stock_in VALUES (2, 2, 2);
INSERT INTO stock_out VALUES (2, 2, 2);

SELECT
  SUM(stock_in.units) - SUM(stock_out.units) as difference
FROM
  stock_in
INNER JOIN stock_out
ON stock_in.itemid=stock_out.itemid
WHERE stock_in.itemid = 1;

//result
+------------+
| difference |
+------------+
|         -1 |
+------------+
1 row in set (0.00 sec)

redpajama_set_name: RedPajamaStackExchange


you can see that the lxc client of the snap package is located in the /snap/bin directory.
Therefore, you need to add /snap/bin to the $PATH.
Normally, the shell's $PATH has /snap/bin. In your script though, you set the $PATH to specific values, therefore you need to take care of adding /snap/bin in there yourself.
Sorry for recovering an old post but maybe it worths a mention.
Reverting from deb to snap lxc installation I was banging my head why server backup scripts stopped being able to be executed from home (remotelly). Could be ran locally though.
The reason is that interactive users on a system with snaps, get /snap/bin/ into their $PATH through /etc/profile.d/apps-bin-path.sh.
If somehow this /etc/profile.d/apps-bin-path.sh does not run for you (like in cron), you do not automatically get /snap/bin into your $PATH.


Some liberals (and myself) will definitely feel some disappointment as Obama's change becomes more reconciliatory and pragmatic than ideological. In part, these naysayers have already been underwhelmed by the recycling of the Washington status quo for Obama's cabinet. Nevertheless (and irregardless of the fact that the press is helping), there is an amazing sense of national and ideological reconciliation taking place, and that is indeed very much part of the hope and change that Obama preached on the campaign trail.
Just look at the numbers. Remember all of those Republican haters who cried Armageddon and feared that Obama would destroy the nation with his extreme liberal policies, radical pals, elitist blackness, and the kitchen sink? Now there are actually more Republicans who support Barack Obama than George W. Bush, and in a National Journal Political Insider's Poll, 96% of Democrats and 82% of Republicans said that Obama would be a "very/somewhat likely successful" president. That sounds like hope to me. And after the culture wars and negative tone of the past two presidencies, those numbers also indicate a remarkable change. Of course, politics are politics, and politicians don't get elected by agreeing with each other — otherwise they'd never come up with a reason, scandals aside, to vote against incumbents. So when the dust finally settles after the inaugural honeymoon, they'll all eventually get back to their bickering true selves.
Even if change is watered down by pragmatism and reconciliation is only temporary, there is one cosmetic (even cosmic) change that is so powerful it transcends all the rest and cannot be denied even by Hillary Clinton, John McCain or either of their supporters. And it is about more than just race, for neither Hillary Clinton (who is notoriously polarizing) nor John McCain (who simply lacked the necessary vitality) could have built this historically unique grass roots movement turned media love affair and iconic juggernaut. No one else had what it took to both create and capture the moment.
As former Bush strategist Matthew Dowd said yesterday on This Week with George Stephanopoulos, this change will only be fully apparent right after the inauguration, when the presidential limo pulls up in front of the White House and Barack, Michelle and their two daughters get out and open the door to their new home.
hey, did you show up at the Democrats abroad inauguration party in Madrid?
As may be clear by now, I am pretty much the biggest non-Republican Obama critic that I know of and in his first day he has impressed me. He seems to be addressing the Gitmo detainees; curbing lobbyist powers (if only slightly); he has opened up the Executive branch to (more) public scrutiny (than Bush and his secrecy) and is pushing for a speedy(ier) exit from Iraq. In other words, I have been impressed by Obama's first day in office.
I do wish he came out the first day aggressively against Israel, but let's he does so tomorrow.
It should be noted that although I am impressed by Obama's first day in office, I remain his number #1 non-Republican critic (and maybe number #1 overall).
shhiiiiiii, nachostyle? i heard it was free with lost of mujeres and booze?
talked to dima last night..you going to dubai for possible work? wtf is wrong with you? you need to go back to the roots brotha.


I know many people have managed to get up and running with Google+ fairly easily. The usual snags have been reported, of course, as users get used to the idiosyncrasies of the network, and as new etiquette and conventions emerge.
Today, it's become clear that there are some deeper issues emerging, as Google enforces a "real names only" policy. Erm, good luck with that, in a hard identity sense, guys. Unless you're going to try and peg people back to a state-issued identifier… (no, I'm not even going to go down that road of horror).
There've also been a few nasties creeping out of the woodwork as users realise some of the drawbacks of putting it all in the cloud. One wrong step with your service provider, and you'll be writing a rant like this as thousands of hours of curation, not to mention thousands of irreplaceable and irretrievable content files, are briskly wiped out.
But for me, Google's latest foray into social networking has pretty much been a non-experience. Although I was invited fairly early on, and signed up successfully for a few days, it all went belly-up pretty soon afterwards.
Why? Because of the cack-handed way in which Google identities work, that's why. Here's the detail.
Like most people, at some point I signed up for a Gmail account. I didn't get a very nice address, as I wasn't in there early enough, but it is a version of my name.
That email address is pretty much the way in which I'm identified for all services I use that are based on email address. In many ways it is my self-asserted identity on the Internet.
So it won't surprise you to learn that when I came to create a Google profile, based on an email address, I used my "home" email identity.
So far so good, and for a couple of years everything worked smoothly. Google Apps did the things Google Apps did (email, calendar, contacts). And for the other Google services I used (Analytics, and probably not much more than that), I logged in with my Google profile. All was well. I had a slightly uncomfortable feeling that there may be trouble down the line though, with two identically-named identities that were logically separate.
A few days after I joined Google+ I got a friendly-but-firm email from Google. "We're consolidating your accounts," they told me. This dual use of the same email address can't go on. Not optional. Indeed.
As I'd been invited to Google+ using the "profile version" of my email address, I feared the worst. And I was right. That was the account which was going to be stripped of my preferred email address. To be replaced by a "temporary address"–something horrible with a percentage sign in the middle of it. Great. The G+ connections dried up–nobody knows me as "the percentage sign email guy"–they know me as my ordinary, erm, email address. Bugger.
It got worse. To be able to get into G+ at all I didn't just have to log in to Google using the temporary profile, I also had to log OUT of Apps (explicitly, even if I were already logged out of "normal" Google)–otherwise Google thought I was attempting to access G+ using a "business identity". The horror!
The solution–according to Google–was to assign my Google profile an entirely new email address. Right. A new identity, for what could emerge as a pretty important service, should Google actually get their act together. An identity, and email address, that I didn't need or use anywhere else. Not. Ideal.
Why would I waste time now building up a social network where I, quite literally, don't know who I am?
But it explains why I'm not part of this party, remain unconvinced of Google's ability to handle the basics of social interaction, and am pursuing a wholesale review of my domains, addresses and identities for what now seems an inevitable clean break, sooner or later, with Google. Nice work, chaps.
Is there any real significance in all this? Surely this is just the moaning of yet another free-service user who didn't read the Ts&Cs? Nothing paid, nothing to complain about.
Identity, and cross-platform identity, are hugely important in an ever-more-connected world. Mess with those and you mess with the core of user experience: user existence.
Like it or not, it's hard to see how a relationship with Google won't form some part or other of everyone's Internet activity at least over the next few years. This makes a Google profile (whatever neglect Google may have shown for it to date) disproportionately important.
The attempt to enforce "realness" is weak. Google's requests for reference to "government-issued ID" (redacted or not)–whether to "prove" age or identity–is a troubling step. It puts a little friction in the path of being anonymous, sure, but if you want to, you can be.
And these characteristics (inflexibility, heavy-handedness, dependence) are all indicators of things that we'll need to worry much more about in the future.
Google account administration functions really are up the spout. Here's a good piece by Dan Harrison on Google administration in general, and another on Google Apps deficiencies in particular. I've said it before: if a profit-focused, cash-rich organisation like Google finds identity so difficult, do we really hold out much hope for government?
Google Wave also revealed some of these flaws. I actually thought, briefly at the time, that the whole Wave concept was actually a Trojan Horse to get people to sign up for a Google profile (or to take one more seriously if they already had). And what did they force me to have as my Wave ID, despite me already having a friendly Apps address, and a slightly less friendly Gmail address? Something like paulclarke0001@gmail.com (I actually forget how many zeroes.) Face hits palm.
Very interesting Paul. I have a similar issue, although thankfully it's not reached the point yours has, in that I use apps for my email but my G+ account is linked with a largely unused gmail email (same as you really). I'm ploughing on with it this way but it is particularly inelegant way to handle usernames/identities. Hope you get yours sorted.
They cancelled @BennyCrime:disqus s account and I see that there is a possibility that in redacting your access they can lock you out of your services ( read email, calendars, reader, analytics ) which is pretty damned worrying.
I had taken time to point out wierd problems and issues on G+ only to be shouted down that I was being too serious and that it was all in beta and would soon be fixed. FML if it isnt like being the child in the emperors clothe tale all over again.
I have two gmail accounts and three google apps for your domain accounts running but my Google Profile is on my work related gmail account so I am suitably concerned that being locked out of G+ might royally screw me over.
I find gmail/google apps for your domain to be a bloody marvellous service suite but Google should stop trying this social stuff , they just keep screwing it up.
Interesting post on the drawbacks of using #G+ for #SocialMedia – worth reading.
I didnt deem it necessary to provide my DoB but again G+ would have none of that, indeed when I spoofed a duff DoB they suspended my account until such time that I parted with my credit card details, I chose that as opposed to giving them a copy of my driving licence!?!
Like you Paul I have my reservations with G+ as the new social media platform for the masses and even more reservations about the insidiuos nature of Googles data collection, today we call them Google tomorrow….. what?….. skynet…. big brother…. HAL http://bit.ly/oxocbP?
Great post, I had a similar thing with the 'new' unused gmail acct and have to have two browsers on my mac to avoid continuously logging out and in again. The issue of having your whole identity in one cloud is superbly illustrated by the rant you linked to. I wrote a post along similar lines here http://bit.ly/owmI4G when I started getting nervous about it last week. After reading ThomasMonopoly's 'dear Google' letter I may have to work out another strategy!


text:
Tyler Hubbard Strikes Out on His Own
Valentino Toasts Store Architect at Paris Dinner
The brand officially opened of its renovated flagship on Avenue Montaigne.
By Joelle Diderich Plus Icon
Joelle Diderich
Bureau Chief, Paris
Recent Articles by Joelle Diderich
LVMH Confident on Chinese Recovery
EXCLUSIVE: Louis Vuitton Launches First Baby Collection
Couture Auctions Promise Bounty for Bargain Hunters
March 6, 2013, 2:26pm
DOUBLE DUTCH: A table groaning with Delft vases, flowers and mounds of berries greeted guests at the Valentino dinner Tuesday night in honor of British architect David Chipperfield, following the official opening of its newly renovated flagship on Avenue Montaigne.
Maria Grazia Chiuri, co-creative director with Pierpaolo Piccioli, said the decor at the Hôtel Salomon de Rothschild — like the Valentino fall collection — was inspired by a recent retrospective of the work of Johannes Vermeer and other 17th century Dutch painters in Rome.
"We wanted to transfer the mood of our catwalk show to the dinner," she explained. "Even the tables have been named after his paintings."
Valentino Garavani, accompanied by his business partner Giancarlo Giammetti, gave the soiree his seal of approval. "I love it because I have the impression that I'm in a corner of my house," said the founder of the brand.
RELATED STORY: Valentino Fall 2013 >>
Guests including Jessica Alba, Elettra Wiedemann, Margherita Missoni, Ana Girardot and Cécile Cassel feasted on a meal prepared by Michelin-starred chef Yannick Alléno. Alighting at her table, French actress Mélanie Bernier exclaimed: "This is so beautiful! Did you see the buffet with the grapes and the strawberries? It makes you feel like a queen."
Indeed, Marie Antoinette would have had a field day with the dessert buffet that was laid out after dinner. Tallulah Harlech stood impassive next to the spread, explaining that she has been working out ferociously since January with a trainer at Equinox in London.
"I am all about becoming the leanest and meanest of all," she said. What about the glass of red wine she was sipping? "This is an antioxidant, it's good for you," Harlech said.


Gateway, Inc. has introduced Gateway College:)Ware, a package of accessories, software and training designed specifically for college students. The program is designed to fit in a colle ge student's budget, while offering students solutions for data storage, reference, computer training, printing, and more.
Among the package's offerings are an Iomega 100MB Zip drive, an MP3 software player, a surge protector for desktops, a carrying case for notebooks, a subscription to Gateway's online training program, and access to Web-based instruction on everything from computer applications to sociology. The package suits any level of computer proficiency, and is available for $369. Gateway, Inc., N. Sioux City, SD, (800) 846-2000, www.gateway.com/collegeware.


text:
Alberts Ready to Rock on in Surry Hills
Alberts, a leading Australian music rights management company and the spiritual home of legendary rock bands AC/DC, The Easybeats and The Angels, will be moving to Surry Hills.
Alberts required new premises after its Neutral Bay office was sold. The company, which for than a century has helped shape Australia's musical, cultural, entertainment and media landscape, has secured approximately 600 sqm of commercial space at Level 4, 68-78 Wentworth Avenue, Surry Hills.
The leasing deal was negotiated by Ray White Commercial South Sydney's John Skufris on behalf of a private client while Alberts were consulted by Ian Dalgarno of Daltor Property.
John Skufris said: "The office space provides a plug and play solution for more than 30 staff, with main offices and meeting rooms, an oversized kitchen/breakout area and timber flooring throughout.
"The tenancy is a short walk to Hyde Park, Museum Station and Central Station and surrounded by local eateries including Longrain, Spice I am and Nomad."
The lease expires 31 December 2016 with a three year option at an initial gross rental of approximately $430 per sqm per annum.


The names of bygone retailers are lined up like tombstones, set in tile and terrazzo along Mission Street. Nobody knows or cares except Dorothy Harders, who has made it her business to go along and take pictures of them.
"I want to stress that this really doesn't dominate my life. This is just a little something that I got a whim on," Harders was saying the other day as she kicked aside a doormat to check for a name inlaid beneath it. "I'm not bashful," she says, after sleuthing out the word "Union," which she recognizes as all that's left of the Union Furniture Store.
"These people just cover them up," she says, as a quizzical clerk watches her snap a picture. "It doesn't mean anything to them." It wouldn't mean anything to Harders either if she hadn't visited a dentist named Eric Debbane on Mission at 24th. Walking into the storefront, she stepped over the word "Wigham" set in tile. Nobody in the office knew what Wigham meant, and this didn't sit right with Harders as she sat in the dentist's chair.
"It just preyed on my mind," she recalls. So the next time she rode BART from her Daly City home to see Dr. Debbane, she skipped the 24th Street Station, got off at 16th Street and walked back, head down at every entryway.
This is how she came across the name "16th Street Theatre" spelled out in green on white tile and now half covered by the ticket booth for the Victoria.
It helps that Harders spent her teenage years, in the 1940s, in a flat on 19th Street and can remember what businesses used to be where. She also remembers the streetcar that said "cemeteries" on the side, and terminated at Colma. But she is not nostalgic for the old Mission Street. "I hated it then, and I don't like it now," says Harders, who thinks of herself more as a documentarian.
The best-preserved example of her whim is Redlick-Newman -- bold black letters against a pale green backdrop with orange stripes on the southeast corner of 17th and Mission. "There were two separate furniture stores in two buildings," she says. "One was called Redlick's, and the other was Frank Newman. Evidently they went together."
The older names are in tile mosaic. The newer and brighter ones are in terrazzo, a poured mixture of marble chips and cement.
"This was in the '20s and '30s, before my time," Harder says. "I think there was an air of permanence to it." There wasn't. Redlick-Newman is now a thrift store. The Hub, once a dress shop, now sells luggage, its name partially covered by camouflage duffel bags on display.
That's the charm of Mission Street signage. New merchants don't bother to get rid of the relics of the old.
Further along she encounters the letters "axma." But Harders knows this is "Waxman's," with the outside letters covered by a display of dresser- drawers pushing toward the sidewalk. "I remember it absolutely," she says. "I think it was called Waxman's Starlight Furniture."
At 22nd Street, she crosses to the west side of Mission to admire the big green dollar sign in the sidewalk on the northwest corner of Mission and 22nd. "I thought I hit pay dirt when I found this," she says, not pardoning the pun. '$' represents "The National Dollar Stores." "During the Second World War, they put a big sign in the window -- We Are 100% Chinese. They didn't want anyone thinking they were Japanese."
The only original sidewalk-sign still in business is Crescent Jewelers. "Step on in. I give you 70 percent off today," says the salesman, who's out polishing it.
A few doors up is a name scratched out but for an "R" and an "M," which Harders pieces together as "Walter May." Still legible is "Karl's" from the shoe store. "Remember Debbie Reynolds?" she asks. "She married Karl."
Karl's is next to "Mode 'O Day," but only an old-timer can decipher it because the bottom half is cut off by pavement. Si's Flowers got a fate worse than that. The name was jackhammered out not long after Harders got a picture of it.
She's not finished yet. "There are more out there, I know it," she says after a morning's search. And what will she do when her photography project is finished? "Put them away," she says. "I thought about putting them all together into a little book, but I thought, 'Who else would be interested in this besides me?' "
Just in case, she has written some text: "A few are intact, but most are in sad shape, dirty or missing letters and sit there like orphans. . . . They are gradually disappearing . . . these steppingstones to the past."


text:
Simon and Schuster BYR
Home » Simon and Schuster BYR
Halloween Books Roundup by Christine Van Zandt
Ages 14 and up, Ages 14 and up, Ages 4-8, Ages 7-10, Animals - Bunny Rabbits, Chapter Book, Children's Book Reviews, Fantasy, Gay & Lesbian, Halloween, Holidays & Celebrations, Humorous Stories, Humorous Stories, Imagination & Play, Juvenile Fiction, LGBTQ, Mystery & Detective Stories, Picture Book Series, Romance, Witches & Witchcraft, Wizards & Witches, YA Fiction
CHILDREN'S HALLOWEEN BOOKS ROUNDUP 2022
CREEPY CRAYON! (Creepy Tales! series)
Written by Aaron Reynolds
Illustrated by Peter Brown
(Simon & Schuster BYR; $18.99, Ages 4-8 )
Aaron Reynolds delights us with book three of the Creepy Tales! series featuring his beloved Jasper Rabbit. In Creepy Crayon! Jasper's not-great day gets a boost when he finds a bright purple crayon—with a crazy grin on its face! Soon, the crayon is helping Jasper zoom his grades up to straight As. Cool, right? Maybe . . . until the crayon takes BFF to the next level.
As in the first two books, Peter Brown's art is a perfect blend of funny and spooky: Crayon's glowing antics contrast with the lurking shadows. Kids will love the hilarious expressions on Jasper's face.
Flawless interplay between text and high-contrast art make this author and illustrator duo New York Times best-sellers. Fans will appreciate the can-you-spot-them references to Creepy Carrots! and Creepy Pair of Underwear! We own this outstanding three-book series and do not tire of them; they're a fit for Halloween or any day you need some funny bunny in your life.
CRIMSON TWILL: Witch in the City (book one, series)
Written by Kallie George
Illustrated by Birgitta Sif
(Candlewick Press; $14.99, Ages 7-9)
The chapter-book series opener, Crimson Twill: Witch in the City, by Kallie George will bewitch you with its main character, spunky little Crimson Twill. True to her name, Crimson rocks a big bow on her red witch's hat—no standard black for this girl! Her clothes and actions also set her apart. But, the various ways she's different from others don't bother her at first.
With Mom just a wave of her wand away, Crimson sets off to explore the big Broomingdale's department store where the elevator's buttons are shaped like what's sold on that floor. Crimson hopes to get a glimpse of those things called puppies. Instead, she immediately encounters disdain for her unique attire, creating a crack of doubt in her self-assurance.
The clever puns, humor, and heart make this book a standout. Illustrations by Birgitta Sif add an array of fun, diverse witches. Kids new to reading will appreciate the short, simple chapters that are engaging and fast-paced. For this age audience, navigating a large store truly is an adventure. And any place with a cat floor is alright by me! Crimson ultimately finds that Broomingdale's does have "everything a witch could itch for" but what she end up with may surprise you!
THE LOST COAST
Written by A. R. Capetta
(Candlewick Press; Paperback $10.99, Ages 14 and up)
The beautifully written YA, The Lost Coast, by A. R. Capetta grabbed hold of me with its opening lines describing Danny's first glimpse of ancient redwoods. She and her mom move to this specific coastal northern California town because Danny has been mysteriously drawn there. Danny quickly finds herself in deep with a group of queer high school witches who call themselves the Grays. They're awesome, but their most powerful member is missing and they expect Danny to find her.
Nonlinear narration and alternating viewpoint chapters heighten the suspense as we try to understand what's really going on. The foggy forest gives nature a presence on the page and sets the mood for magic, secrets, and discovery. This book is an A+ for me because of its realistically complex and interwoven friendships and love, plus the group's frank discussions about identity. Ideal for fans of The Graces novels. I highly recommend The Lost Coast to YA readers who enjoy clever, twisted tales that are atmospheric gorgeously crafted. Available in hardcover, paperback and Ebook.
Reviewed by Christine Van Zandt (www.ChristineVanZandt.com), Write for Success (www.WriteforSuccessEditing.com), @ChristineVZ and @WFSediting, Christine@WriteforSuccessEditing.com
Picture Book Review by Tracy C. Gold – If Your Babysitter is a Bruja
Action & Adventure, Ages 4-8, Children's Book Reviews, Foreign Language learning, Guest Blogger, Guest Post, Halloween, Holidays & Celebrations, Juvenile Fiction, Spanish, Spanish Language, Witches & Witchcraft
IF YOUR BABYSITTER IS A BRUJA
Written by Ana Siqueira
Illustrated by Irena Freitas
(Simon & Schuster BYR; $18.99, Ages: 4-8)
If Your Babysitter Is a Bruja starts as a spooky Halloween tale and then develops layers as it goes on. Written in second person, If Your Babysitter Is a Brujachronicles how a child is scared of her babysitter. Clever illustrations by Irena Freitas show how a terrifying "bubbling cauldron" is actually a bathtub, a magic broomstick is a bicycle, and a slide is a magic castle. A clever scene showing the babysitter's hat in a pile of water worries the child that her babysitter has melted, but the babysitter lives on … with delicious Pan de Muerto to ease the relationship.
Interior spread from If Your Babysitter is a Bruja written by Ana Siqueira and illustrated by Irena Freitas, Simon & Schuster BYR ©2022.
From there, the babysitter and child become BFFs (or perhaps best brujas), and the night ends with the child looking out the window, sad the babysitter has left. This book will be perfect for kids anxious about being left with a babysitter or for those who are shy about making friends with new people. Certainly, that is something many families will struggle with following lengthy Covid lockdowns.
Interior art from If Your Babysitter is a Bruja written by Ana Siqueira and illustrated by Irena Freitas, Simon & Schuster BYR ©2022.
Ana Siqueira's rhythmic text smoothly incorporates Spanish words and intertwines cultures with tasty treats from Dia de Los Muertos combined with Halloween decorations. The illustrations are quirky and sweet.
Review by Tracy C. Gold
ORDER COPIES:
For signed copies –
https://www.portkeybooks.com/
https://tombolobooks.com/
FOLLOW THE AUTHOR HERE:
You can learn more about Ana, by following her.
Website: https://anafiction.com/
Twitter: https://twitter.com/SraSiqueira1307
Instagram: https://www.instagram.com/asiqueira1307/?hl=en
FOLLOW THE ILLUSTRATOR HERE:
You can learn more about Irena by following her.
Website: https://www.irenafreitas.com/
Twitter: @irenafreitas
Instagram: @irenafreitas
FOLLOW THE REVIEWER HERE:
Learn more about Tracy C. Gold, writer, and editor by following her.
Website: tracycgold.comTwitter: @tracycgold
Tracy's Books: Everyone's Sleepy but the Baby, and Trick or Treat, Bugs to Eat
ANA'S OTHER BOOKS:
EL PATO QUIERE UVAS
Order here: Teacher's Discovery 2019
BELLA'S RECIPE FOR SUCCESS –
Order here: Beaming Books- July 2021
Blog Tour for My Pet Feet by Josh Funk
Ages 4-8, Alphabet, Animals - Ferret, Blog Tour, Children's Book Reviews, Concepts, Humorous Stories, Juvenile Fiction, Read-alouds
MY PET FEET
Written by Josh Funk
Illustrated by Billy Yong
(Simon and Schuster BYR; $18.99, Ages 4-8)
GoodReadsWithRonna.com has the pleasure of participating in the blog tour for My Pet Feet. I made sure not to read any advance buzz about the book (easy 'coz I've been on vacation) so that I'd come to it with no expectations which, to be honest, is a hard feat (ha!) knowing how terrific all Josh's previous picture books are.
When the letter R disappears from the main character's alphabet wall covering, chaos and hilarity ensue in My Pet Feet, the wacky, wonderful new picture book from Josh Funk with illustrations by Billy Yong.
It doesn't take long for the little girl narrator of this zany 48-page tale to discover that her pet ferret, Doodles, has become her pet feet since all Rs have mysteriously gone missing in her town. Yong's whimsical spreads where the main character first encounters the absence of Rs are (ha!) so funny and clever, that readers will have to slow down to study every delightful detail he has depicted. The images of a policewoman on the back of a galloping hose or the little girl's pal Lucas behaving like a fiend and especially the flying cows are sure to make kids LOL. In fact, I actually noticed even more things on my second read (e.g. the man on the motorcycle with ties as tires) so I intend to go back a few more times to make sure I caught everything. Children will likely do the same. And, despite being a rollicking fast-paced read, the idea of taking time to appreciate all the clever wordplay and creativity of the story's concept is recommended.
Interior spread from My Pet Feet written by Josh Funk and illustrated by Billy Yong, Simon and Schuster BYR © 2022.
As the search to find the reason behind the missing letter R continues, the girl accidentally hurts the feelings of Doodles who runs away. She looks low and eventually high—way, way, way up high—where a subtle clue for the savvy reader can be spotted anchored out at sea. But still no sign of the 18th letter of the alphabet and now Doodles. Could the pet actually know the Rs' whereabouts? Will this determined child ever find her beloved pet? And will he forgive her? I wanted to find out, but yet I didn't want the story to end.
Interior art from My Pet Feet written by Josh Funk and illustrated by Billy Yong, Simon and Schuster BYR © 2022.
In Funk's satisfying and humorous resolution, the main character's luck and mood change. She locates her pet feet which leads her to the culprits behind the stolen letter R. Young readers will love seeing ferret and owner reunited while getting the chance to pronounce a plethora of words incorporating Rs that Funk has mustered up. But just when this happy child thinks she can relax and catch some zzzzs, an oh-so-unexpected alphabet ending presents a potential new dilemma or possible premise for a second book.
There are myriad ways to enjoy this entertaining picture book: from the mystery of the missing Rs, to the superb silliness of the pet feet, from the zaniness of the town inhabitants oblivious to the absent Rs to the engaging art that keeps us glued to the page. I'm thrilled I had this opportunity to read and review My Pet Feet and help spread the word about this fun new story. And while a pet ferret is probably pleasing, I think there are times when having pet feet could come in handy (pun intended) too!
When Staying Alive Means Staying Apart – Five Feet Apart by Rachael Lippincott
Ages 12 and up, Ages 12 and up, Children's Book Reviews, Contemporary Fiction, Difficult Discussions, Diseases, Growing Up & Facts of Life, Growing Up & Facts of Life, Health, Illness, Love, Romance, Romance, YA Fiction
Written by Rachael Lippincott
With Mikki Daughtry and Tobias Iaconis
(Simon & Schuster BYR; $18.99, Ages 12 and up)
In Rachel Lippincott's superb novel, Five Feet Apart, with its PG13 film version releasing in March (starring Cole Sprouse and Haley Lu Richardson), we're introduced to the growing love story of two teen cystic fibrosis (CF) patients. Stella has been a CF patient for most of her life. She seems complacent and at ease from knowing all the nurses, every corner of the hospital, and having a precise routine and arrangement for her medical cart. Her habits at the hospital seem invulnerable to change until she meets Will, a reckless newcomer who also has CF.
As is the rule, CFers must stay six feet apart from each other to avoid contamination. For Stella, being close to Will could cost her the new set of lungs she's awaiting on the transplant list and the promise of a new life. However, with the couple spending more time together, the six-foot apart rule becomes challenging to maintain, even for rigid, routine follower Stella. But if they can never touch, can they still love each other from a set distance? Or can they safely bend the rules, take away one foot but maybe tread in dangerous territory? Will it make a difference?
Lippincott's novel is an exciting emotional rollercoaster with elements of hope, fear, and love that intertwine seamlessly. Lippincott does a great job conveying the longing between the two patients. She also includes diverse characters and family relationships that are not usually portrayed in novels that I read. If you loved books like The Fault in Our Stars or Everything, Everything, then you will want to read Five Feet Apart. Maybe, like the main characters, you too will find it hard to remain five feet apart from this great read.
Reviewed by Rachel Kaufman
Rachel Kaufman is a current sophomore studying communications at the University of Southern California. She's passionate about books and hiking with her dog, Scout. Rachel enjoys how books reshape her imagination of the world around her. Rachel knows firsthand how important books are in aiding children's futures, working with a reading program, Reach Out and Read, by reading, organizing, and donating over 200 children's books. In her free time you can find her either reading or thinking about what she might read next.
Listen here for an excerpt from Five Feet Apart.
Our Favorite Kids' Christmas Books Part Three
Ages 0-5, Ages 2-5, Ages 2-6, Ages 4-8, Christmas, Christmas Traditions, Christmas Tree, Holidays & Celebrations, Juvenile Fiction
NEW CHRISTMAS BOOKS FOR CHILDREN 2018
– A ROUNDUP –
A UNICORN NAMED SPARKLE'S FIRST CHRISTMAS
Written and illustrated by Amy Young
A Unicorn Named Sparkle's First Christmas, Amy Young's third book in this funny series, doesn't disappoint. Cutie pie Sparkle continues to delight readers with silly antics offset by his true friendship with the little girl who loves him.
Lucy—perhaps like someone you know—believes the best thing about Christmas is "Lots and lots of PRESENTS!" And, of course, who better to give great presents than your BFF? However, even with Lucy's insistent reminders, Sparkle doesn't quite grasp the concept. It is, after all, his first Christmas.
Young's illustrations capture the exciting buildup of holiday madness (cookies, ice skating, the mall) and, of course, a crazy-messy wonderful house. If you enjoy playful underscored by heartfelt friendship, this book's for you.
LITTLE CHRISTMAS TREE
Written and illustrated by Jessica Courtney-Tickle
(Big Picture Press; $15.99, Ages 2-5)
★Starred Review – Publisher's Weekly
This beautiful, extra-large, 12-page board book's sparkling art invites readers to journey into wintery landscapes. Each scene has several lift-the-flap opportunities for little hands to discover hidden wonders.
Written in rhyme, the story takes the reader through a day in the forest. First, the little Christmas tree awakens to find the woods have turned from green to white. Creatures explore until the sky clouds over and snowflakes fall once more.
Jessica Courtney-Tickle's digital illustrations in Little Christmas Tree convey the best of snowy weather. Brightly colored berries and animals contrast well with the forest's earth tones. Silver foil accents add a lovely effect. Young readers will delight in revisiting these tranquil sceneries.
MERRY CHRISTMAS, LITTLE ELLIOT
Written and illustrated by Mike Curato
(Henry Holt BYR; $17.99, Ages 4-8)
Merry Christmas, Little Elliot is a lovely addition to the seasonal standards with its fresh look at a familiar theme. You may know Little Elliot (an elephant with pastel spots) from previous books. In this holiday adventure, Elliot isn't excited because he doesn't have Christmas spirit.
So he sets off with Mouse to try and find this elusive thing. None of the typical wonders (The Nutcracker ballet, a spectacular tree, or sledding) incite Elliot until a mysterious envelope leads the two friends to discover what this time of year truly means.
Mike Curato's classic art enhances and amplifies the story line. The beautiful book has an old-fashioned feel with a timeless message. Santa tells Elliot that he can't give him the Christmas spirit, "You have to find that yourself."
Be sure to look under the picture book's dust jacket for a clever alternate cover image.
The above three books were reviewed by Christine Van Zandt
MERRY CHRISTMAS, LITTLE POOKIE
Written and illustrated by Sandra Boynton
(Little Simon; $5.99, Ages 0-5)
I'll be honest. Pookie can do no wrong by me. Sandra Boynton is a personal fave so I'm biased when it comes to her books as anyone who follows me on Twitter knows.
On Christmas Eve, little Pookie pig is ready for a walk in the snow with Mama. When noses get frozen, it's time to head inside because "There are garlands to make and lights to turn on and cookies to bake." Family and friends will soon be arriving and Christmas songs will be sung. Boynton's 18-page rhyming board board is festive and endearing and features all the trademark cuteness that make this a wonderful addition to the beloved go-to series. With eight books available, there's definitely a great selection to keep your youngest ones entertained. And now, with Merry Christmas, Little Pookie in the mix, children can easily spend all year with Little Pookie!
THE BROKEN ORNAMENT
Written and illustrated by Tony DiTerlizzi
(Simon & Schuster Books; $17.99, Ages 4-8)
Be careful what you wish for is what I kept thinking as I read The Broken Ornament, a touching picture book about empathy, thoughtfulness and self-reliance. As the story opens "Jack wanted this to be the best Christmas ever." When that means adding more ornaments on the tree, Jack's mother warns him about the one he intends to hang. It shatters and his mom hastily retreats upstairs followed by his dad with a box of tissues. Clearly that ornament was meaningful to his mom. It's only when a fairy named Tinsel emerges from the ornament shards that Jack gets the over-the-top Christmas experience he longed for. But something was missing. Was there a way to replace the broken ornament? Tinsel helps Jack learn the story behind the ornament's importance and explains that only Jack has the power to come up with a solution. Once Jack puts his mind to it, he figures out a beautiful way to show his remorse over his action that, while not bringing back the old ornament, helps everyone have a joyful Christmas after all. Sometimes there's magic in the small things. I absolutely loved DiTerlizzi's spread of Tinsel's magical creatures (Santa, elves, snowmen, reindeer, nutcrackers) gathered in the snow outside the living room window looking in at the happy family. Santa's got a spotlight on him as he holds a glowing Tinsel in his hand. Young readers will be thrilled to witness the positive outcome along with the Christmas cast of characters. Buy local and treat yourself to this beautiful book to share with your family this holiday season.
The above two books were reviewed by Ronna Mandel
Please click here for Part One of our 2018 Christmas Books Roundup.
Please click here for Part Two of our 2018 Christmas Books Roundup.
The Remember Balloons & Maximillian Villainous – Two Heart-filled Books
Ages 4-8, Ages 5-9, Animals - Bunny Rabbits, Being true to yourself, Children's Book Reviews, Coping with illness, Difficult Discussions, Emotions & Feelings, Family & Relationships, Family ties, Grandparent - grandfather, Growing up & facts of life, Humorous Stories, Juvenile Fiction, Kindness, Love, Monsters, Multigenerational, Self-acceptance, Social Situations - Friendship
MAXIMILLIAN VILLAINOUS
Written by Margaret Chiu Greanias
Illustrated by Lesley Breen Withrow
(Running Press; $16.99, Ages 4-8)
THE REMEMBER BALLOONS
Written by Jessie Oliveros
Illustrated by Dana Wulfekotte
(Simon and Schuster; $17.99, Ages 5-9)
The monster members of Max's family cannot understand why he is SO good and not at all villainous, as they are. MAXIMILLIAN VILLAINOUS is kind, helpful and constantly scrambling to make amends for his family's mischievous misdeeds. When Max brings home a bunny, his family decides to offer him the ultimate test. He must complete three devious, villainous tasks in order to keep his sweet, fluffy and otherwise unsuitable pet.
Max and bunny do try to tackle their tricky To Do list, but they are too nice! They fail repeatedly and humorously, although they persist in finding creative solutions. Eventually Max begins to despair that he can succeed in behaving badly. Will he be forced to give up his beloved rabbit? With comic antics and heart-tugging earnestness, eager readers will be delighted to discover whether Max and his bunny can uncover a solution that saves the day.
Withrow's adorable illustrations are colorful, bright and filled with expression. Max and his family are clearly monsters, adorned with horns, fangs and claws, but they are also incredibly child-friendly, cute and appealing. Clever, whimsical elements are tucked onto every page for young readers to discover. Greanias' playful dialogue and crisp pacing enhance the odds that MAXIMILLIAN VILLAINOUS will become a read-it-again, monstrous favorite in many homes.
In THE REMEMBER BALLOONS, debut author Oliveros features a three-generation family coping with an elderly grandfather's memory loss. Using colored balloons to represent treasured memories, each family member carries bunches ranging from small to large. "This one's my favorite," says the young boy narrator as he points to a blue balloon. It's filled with special scenes from his birthday party. "When I look at it I can see the pony again. I can still taste the chocolate frosting."
But Grandpa's balloons are beginning to slip away, one by one, as his memories start to fade. The narrator struggles with sadness and anger as he witnesses his grandfather's decline, metaphorically paired with the shrinking number of balloons. His helplessness is palpable, as is his deep love for his grandfather. When even a most precious memory of a special fishing trip is lost, the boy's parents step in to offer consolation. Although it is bittersweet when the boy discovers that the number of his balloons continues to grow, the tale arrives at a comforting and heartwarming conclusion that will satisfy all.
Wulfekotte's adept illustrations place detailed vignettes of special memories within a broad spectrum of delicately tinted balloons. The family, in soft, black and white lines and gray shading, is often nestled in close, companionable connection. Settings are simple and understated, allowing the significance of the balloons to hold the focus. Oliveros uses clear, direct language to relay this poignant story in a manner that keeps it accessible for a wide range of readers. THE REMEMBER BALLOONS beautifully expresses the enduring love and importance of family memories in a gracious and meaningful book. Kirkus, starred review
Reviewed by Cathy Ballou Mealey
Harriet Gets Carried Away by Jessie Sima
Ages 4-8, Animal - Penguins, Birthdays, Children's Book Reviews, Clothing & Dress, Family - Parents, Father & Children Relationship, Holidays & Celebrations, Humorous Stories, Imagination & Play, Juvenile Fiction, Penguin Stories, People & Places, Polar Region
HARRIET GETS CARRIED AWAY
Written and illustrated by Jessie Sima
(Simon & Schuster BYR; $17.99, Ages 4-8)
Harriet … oh, amazing and wonderful Harriet, the star of HARRIET GETS CARRIED AWAY along with her two incredible dads, will make readers all Sima fans if they aren't already!
My students couldn't get enough of this brilliant 48-page story … from Harriet's desire to dress-up no matter what the occasion to her phenomenal imagination and charm, they were hooked.
Harriet is SO excited about her upcoming dress-up themed birthday party, and the task at hand is to venture into the city with her dads to buy party supplies since everything else has been taken care of. One stipulation: She's asked not to "get carried away" when searching for birthday hats at the store. But in Harriet's world getting carried away comes easy and she soon finds herself wandering off in her penguin costume with real life penguins. She becomes stranded on an iceberg and realizes she must make her way back to her dads at the store and find the party hats before it's too late.
When her attempts at leaving the penguins don't pan out, Harriet's helped by an orca and some delightful pigeons. Harriet returns to her dads and has the best dress-up birthday party ever … with only ONE of her party attendees getting carried away!
This is one of those stories that will be requested numerous times since it provides a unique, yet fully relatable, experience for youngsters. The writing is quick to action and paced beautifully for children to silently take in every delicious illustration that accompanies the beautiful prose. My favorite moment is when a penguin tells Harriet to "lose the bow tie" she has proudly put on over her penguin costume. Instead, she adjusts her fabulous red bow tie and does things her own way.
Read HARRIET GETS CARRIED AWAY and delight in her message of inclusivity, imagination and pure joy
All interior artwork from Harriet Gets Carried Away by
Jessie Sima courtesy of Simon & Schuster Books for Young Readers ©2018.
Reviewed by Ozma Bryant
Best Picture Books of 2015
Ages 2 and up, Ages 3 and up, Ages 3-7, Ages 4-8, Juvenile Fiction
THIS YEAR'S BEST PICTURE BOOKS
Making a List and Checking it Twice!
Bookseller and reviewer Hilary Taber's Top 15 Picks
Of course this list of 15 picture books is influenced by my own personal taste, but as a bookseller of many years I hope to guide you to some of my personal favorites from the 2015 publishing year. This is by no means a comprehensive list because I have so many favorites, but these are the picture books I would really love to give as gifts. I've tried to arrange these in age order and hope that helps you if you plan to give books as presents to children this holiday season. Happy Reading!
Vegetables in Underwear
Written by Jared Chapman
(Abrams Appleseed; April 2015, $14.95. Ages 2-5)
What could be funnier than veggies in undies? Clever text pairs brilliantly with discussion of all different types of underwear and the text can help a child transition from diapers to underwear. Or it can just be a hysterical, giggly book about underwear. Consider Vegetables in Underwear appropriate for two-year-olds and up.
It's Tough to Lose Your Balloon
Written and illustrated by Jarrett J. Krosoczka
(Alfred A. Knopf BYR; $17.99, Ages 3-7)
Anyone who has ever taken care of a child knows this truth. It is really hard to loose your balloon to the sky above when you let go of it! In a simple and straightforward way Krosoczka points out that many childhood hardships are tough, but there's an upside to a lot of them. You could scrape yourself, but you also might get a glow in the dark band aide! We grown-ups tend to forget how these common childhood dramas are powerful and important to children. The strength of this book is in affirming that the adult in their lives notices these hard times. At the end of the book the author encourages children to notice that when it rains you can look for the rainbow in all kinds of situations! A great reminder to get your kiddo to be able to reframe, stay positive, and look on the bright side.
Written by Kathi Appelt
Illustrated by Rob Dunlavey
Black, white and red illustrations accompany perhaps the most perfect book about crows I've seen. With their red scarves on they fly to get some snacks. They snack all the way to a dozen. In the meantime a cat has been watching these crows with a possible snack in mine! Counting Crows is a charming counting book that I highly recommend!
If You're a Robot and You Know It
By Ukelele and Drum Combo, Musical Robot
Illustrated by David A. Carter
(Scholastic; $16.99, Ages 3-5)
A new pop-up book! What fun! Carter delivers yet another wonderful book! Set to the words from the song, "If You're Happy and You Know It" with "If you're a robot and you know it clap your hands, jump and beep, shoot laser beams out of your eyes!" Children will delight in the familiar song set to a new theme, and the pop up elements are used to make the robot do everything that's in the song. With the pull of a tab the robot claps it's hands, jumps, shoots lasers out of its eyes, and more! Recommended for those children able to handle a pop-up book with care.
Written and illustrated by Elly MacKay
(Running Press Kids; $16.95, Ages 3 and up)
This book gave me the chills because it's that beautiful. A girl moves from the country to the city, and finds that next door is a Butterfly Park. She wonders where all the butterflies have gone! Soon all her new neighbors are helping her to discover that what is needed here are flowers to attract the butterflies. The park is restored and a special fold out page reveals the Butterfly Park full of children and butterflies once more. Each page is filled with light and glowing color. A science lesson on the side provides depth, while the illustrations provoke awe and wonder. A picture book that does not disappoint!
The Moon is Going to Addy's House
Written and illustrated by Ida Pearle
(Dial Books; $17.99, Ages 3-5)
This dreamy, magical book is a cut paper triumph. With gold swirls in the night sky on some pages, this book begins with the end of a play date. Addy begins the nighttime journey back to her own home. Addy and her sister play a game of hide and seek with the moon as they watch it seemingly disappear and then reappear on the car ride home. Under a bridge and behind a mountain the moon seems like a constant friend who follows you home. Rich colors and a masterful command of the cut paper style make this a perfect bedtime book. Is this book a possible Caldecott winner? Only time will tell!
Once Upon a Cloud
Written and illustrated by Claire Keane
Veteran Disney animator Claire Keane, whose background includes her work on Disney's "Tangled" and "Frozen," brings to life Celeste's dream journey on her
request to bring back the perfect gift for her mother. Along the way she meets the stars, moon and sun. However, the right gift for her mother just doesn't present itself. The next morning she is inspired by all the beauty she has seen! She finds flowers that remind her of the stars in her dream and ties up the perfect gift with her own hair ribbon. A visual delight in purple and pink, Once Upon a Cloud makes a perfect gift for a thoughtful child you know who particularly delights in fantastic illustrations.
A Tower of Giraffes: Animals in Groups
Written and illustrated by Anna Wright
(Charlesbridge $17.95 Ages 3-7)
What a gorgeously illustrated book. Did you know that a group of geese is called a gaggle? Or that a group of owls is called a parliament of owls? Or that a group of peacock is called ostentation of peacocks? Each page introduces the groups by their collective names and gives a brief summary of each animal. A wonderful introduction to animals! Pen and ink drawings are combined with watercolor or fabric pieces. My favorite page is a group of sheep in sweaters made with a swatch of sweater fabric. You only have to look at each page to see how lovingly each page was created. I would be pleased to see this win the Caldecott!
The Bear Ate Your Sandwich
Written and illustrated by Julia Sarcone-Roach
(Alfred A.Knopf BYR; $16.99 Ages 3-7)
This is by far one of the best picture books this year for gift giving. A narrator who is unknown at the beginning of the book directly tells the audience about who took your sandwich. A bear wakes up one eventful day in the woods to follow a truck filled with the delicious scent of berries all the way to the big city! Many adventures ensue with the discovery of the sandwich in question. Visual clues give away the fact that our narrator is in fact a dog seen in the park on one page. He is one unreliable narrator because guess what? He ate your sandwich! Sure he saw the whole thing happen. Blame the bear! Grin worthy text pairs nicely with illustrations infused with light and the bear's epic journey from woods to city and back again.
Lenny and Lucy
Written by Philip C. Stead and illustrated by Erin E. Stead
(Roaring Brook Press; $17.99, Ages 3-7)
Philip Stead brought us the Caldecott Award winning Sick Day for Amos McGee, and this new book is equally endearing. Peter and his dog, Harold, have just moved into a new house on the edge of a wood. Feeling that they need some backup, Peter wisely uses big pillows to create Lenny to guard the bridge that runs between their house and the woods beyond. Lenny is a wonder to behold! However, maybe Lenny is lonely out there all alone? Enter a new big, pillow friend for Lenny in the form of Lucy! The four of them become great friends and add one more to the group. Peter's next-door neighbor is a little girl who is fond of owls. So, the woods beyond the bridge might not be so bad after all, especially with good friends by your side.
(HMH Books for Young Readers; $17.99, Ages 4-7)
A girl borrows a magical book from her teacher, but when the words spill out, the little girl is disappointed. However she soon realizes that she can create her own story out of all the words that were once inside the book! A celebration of imagination married with absolutely stunning illustrations make me wonder if this might be a Caldecott winner this year.
Written by George Shannon and illustrated by Blanca Gomez
How many things can the number one be? A counting book and also an ode to all the different kinds of families out there make this multicultural picture book a must have for your family. Children will enjoy scenes they see everyday from doing laundry to going to the zoo. "One is one and everyone. One earth. One world. One family." This strong ending helps us all to recognize how important all families are.
We Forgot Brock!
Written and illustrated by Carter Goodrich
How I love this book. Phillip has an imaginary friend named Brock who is always up for adventure. Off goes Phillip's family to the fair, along with Brock of course. Brock wants to ride the big kid rides, but Phillip and Brock get separated. When Phillip finds that his imaginary pal is missing, he goes searching for him. Luckily another little girl who has an imaginary princess friend with her at the fair sees Brock and takes him home with her. Phillip is at last reunited with Brock, and now they have two brand new friends. All imaginary friends are drawn in crayon which gives this book a special flair!
Written and illustrated by Kevin Henkes
(Greenwillow Books; $17.99, Ages 4-8)
Caldecott Award winner Kevin Henkes hits another one out of the ballpark with this sweet story of five toys who sit on a windowsill waiting for things to happen. Each toy has a special thing that they enjoy seeing. The owl waits for the moon. A pig with an umbrella waits for the rain. This tale of friendship amongst toys is a special one with soft illustrations on rich, creamy paper. The toys move to different spots on the windowsill and it's up to the child to say if they are being moved or do they move by themselves? What a treat! This is especially good for youngsters transitioning to longer picture books. I'm calling possible Caldecott on this one! Those gorgeous, but simple illustrations are simply genius. Henkes does it again.
The Song of Delphine
Written and illustrated by Kenneth Kraegel
This story of an orphan named Delphine tells the tale of the power of a kind soul and a song sung from the heart. Delphine serves the Princess Theodora where they both live on the savannah. Delphine's life is very difficult, so she sings to lift her spirits. When Theodora's niece, Beatrice arrives Delphine's expectations of having a playmate her own age are dashed when Beatrice proves to be spoiled and prone to blaming Delphine for her own mistakes. Delphine's song is heard by twelve giraffes who take her on a journey across the savannah. When they return Delphine to her home they mistakenly put her in Beatrice's room. There Delphine finds the reason for Beatrice's unhappiness for Beatrice's own mother had recently passed away. Beatrice is comforted by Delphine's song and the two go on magical adventures together. Kraegel's The Song of Delphine, a Cinderella story with a magical twist of visiting giraffes? I'll take it!
We hope this helps you to make your list and check it twice! Wishing you and your loved ones a happy holiday season!
– Reviewed by Hilary Taber
Good Reads With Ronna is proud to be an IndieBookstores Affiliate. Doing so provides a means for sites like ours to occasionally earn modest fees that help pay for our time, mailing expenses, giveaway costs and other blog related expenses. If you click on IndieBound and buy anything, we may receive a small commission at no extra cost to you. Your purchase supports our efforts and tells us you like the service we're providing with our reviews, and for that we sincerely thank you.